CRM Report Issue

I designed a custom report to run pending activities & assigned
activities of current loggin user.

This report is running in report server and showing current user's
assigned activities. i am passing current user name in parameters as
@User Name from sql query. After deploying this report into crm. its
throwing an error message like this.

"An error has occurred during report processing.
The Value expression for the query parameter =91@UserName=92 contains an
error: Index was outside the bounds of the array"

The current user name passing from crm report as "NT AUTHORITY\NETWORK
SERVICE".

Environment : CrmServer and SQL Server2008 is installed in seperate
box. data connector also installed.
0
Siva
2/22/2010 10:31:49 AM
sqlserver.reportingsvcs 542 articles. 0 followers. Follow

0 Replies
785 Views

Similar Articles

[PageSpeed] 11

Reply:

Similar Artilces:

Recent Exchange 2003 issues
Hi Everyone I recently installed Exchange 2003 onto our AD domain and now have the following 2 issues When we click on the send/recieve button we get the following message ' Task Microsoft Exchange Server reported error (0x80040107): could not open the item. try again' Also we have setup all Outlook users to point to the new server, then someone will say that they haven't recieved any e-mails for a while and i have to delete their account off of Outlook then add them in again, then all their mail appears, its a bit strange!! Any help would be greatly appreciated Thanks ...

Changing text in X and Z reports
Hi, I want to change a text in X and Z reports. The original text is "Paid on Account." I want it to say "On Account." How can I do the change? I already found the XML report template but don't know where to go from there. Thank you in advance. Win open file in Frontpage or text editor. Do "find" and type in "paid on account" to get you to the section quickly. or, just roll down until you find this section =========================== Section: Grand Total Out =========================== --> <!--BOOKMARK--> <ROW...

Free/Busy Info and OWA 2003 Issue.
Greetings! We are running Exchange 2003 Front-End, Back-End and Exchange 5.5 in a mixed mode. Exchange 5.5 does not host any mailboxes or public folders. They all were migrated to the Exch 2003 Back-End server .We are getting an issue where clients using OWA 2003 are not able to see the Free/Busy information for the other users when scheduling a meeting,however it works just fine with the old OWA 5.5 . This works also if people are using full Outlook client 2000,2003,XP - no problems with the Free/Busy time at all. Thanks in advance! Did you create a replica of the Free/Busy folde...

Interested in Microsoft CRM
My company is a Financial Services company that is interested in implementing MS CRM. This would initially be done for the Investment Advisory portion of our business and later implemented for the rest of the organization. Are there any MS CRM customers/clients in the Investment Advisory business that can comment on their deployment of MS CRM and there overall experience as far as usage of this solution? Also, can you comment on whether the solution was useful without customization or was there customization to the product. If there was customization, then how much (% amount) and wh...

disable reports daterange dialog to show up twice
Hi, I created a report with daterange parameters. Everythings works fine but when I want to print some report, the report asks the user again for the date parameters. Having installed the CRM update CRM1.2-KB834913-Server.exe which should repair this bug, I noticed no change. The reports always asks twice for the parameters. Is there any secret for this mystery... Greetings Thomas Ott are all these parameters in a single report or are you using sub reports as well? -- John O'Donnell Microsoft CRM MVP http://www.microsoft.com/BusinessSolutions/Community/CRMFaqLanding.aspx "Th...

Track in CRM Button
For some users, the track in crm button does not appear when they try to setup calendar appt using outlook. We did install on clean machine for one user experiencing this and the crm button does not appear. Our enviromentL 1. Outlook 2007 2. IE 2007 3. CRM 3.0 with Rollup Update 2 also looked at the following hotfix http://support.microsoft.com/kb/939175/en-us which only applies to Outlook 2003. Are there any other hot fixes that may apply to Outlook 2007? Thanks. ...

CRM HTTP Error 401.1 IIS
Hei, I installed CRM on the Windows Server 2003 on three box for 100 users. All users registred in the CRM Server and working on the clients. A: 1 for Active Directory Domain controler (ADSRV) B: 1 for SQL 2000 + CRM Server ver 1.2 (CRMSRV) C: 1 for Exchange Server 2003 (EXSRV) i have one problem that when i type http://crmwebsite on the CRMSRV then i get "HTTP Error 401.1, Unauthorized: Access is denied due to invalid credentials. Internet Information Services (IIS)". When i try it on the ADSRV then it works well. It is also working well on the client c...

Exchange GAL in CRM
Is there an easy way to import the Exchnge Gal into CRM Contacts? ...

MS CRM 3.0 Customer Case Problem
Dear CRM Experts, I have a problem with MS CRM 3.0: I want to create a web based form in our company website that customers create their Cases (tickets) by it and we (I and my Tech. staff) response to them (Ticketing system). It seems for security reasons we shouldn’t allow CRM browsing outside of our Internal Network (Intranet). Please help me how can present solution for this problem. Best Regards, Mohsen Ahmadi You have a couple of options. There are third-party apps that will let you integrate CRM with your website, but with 3.0 you would probably need to purchase the External C...

How to stop tracking a Contact in CRM 4.0
How do I stop tracking an Outlook Contact that has been set to "Track in CRM" Hi Ken, The "Track in CRM" for contacts turns to "View in CRM" when a matching contact record is created in the CRM database. If you no longer want that contact in CRM then you can delete it, then it will say "Track in CRM" again. "Ken Florian" wrote: > How do I stop tracking an Outlook Contact that has been set to "Track in CRM" ...

Error while import BCM Database into CRM 3.0
I am trying to import BCM Database into CRM 3.0 When I run " Data Migration for Microsoft Outlook Business Contact Manager" wizard I get an unexpected error. Can someone help ? thanks Here is the Log: 8/21/2007 5:15:38 PM------>Transitioning to next screen. From: Welcome screen. To: PreconditionCheck screen. 8/21/2007 5:15:38 PM------>Connecting to Microsoft CRM Shamir_Systems_MSCRM 8/21/2007 5:15:39 PM------>Checking that Microsoft CRM Data Migration Pack is installed: Success 8/21/2007 5:15:39 PM------>Establishing connection to CDF database: Success 8/21/2007 5:1...

CRM 1.2
I am going to move the CRM SQL databases to a new server. We will also be moving Great Plains off the CRM server and on to the new SQL server. We are bouncing around the idea of naming the new SQL server to the name that the current CRM server uses and renaming the current CRM server. The thinking here is that we won't have to touch the Great Plains clients. What kinds of issues can I expect in this scenario? I believe that CRM "might" make us of the SID in which case I would need to use SysPrep to create the new one? I wouldn't think that this is that unusal of a proje...

Outlook vs. webaccess crm 4.0
Hi 1) Could someone specify the pros and cons (especially the difference in the "functionality" options) for the end users - if they use the Outlook client or if they use a Webbrowser? 2) What are most common ? thanks for any feedback... It's true you can do everything on the web version or the Outlook version. The biggest feature of CRM is the fact you can everything inside of Outlook and not have to go a different application. Outlook: 1 - Easier concept for end users (especially Sales folk) to grasp. "you don't need to learn a new application - it's ju...

CRM 4.0 DESKTOP client for Outlook don't load all options (?)
Today I found some problem in CRM Desktop Outlook client...when I try to create e-mail quick campaign I did't find option "e-mail via mail merge" and the same option for list. In CRM menu (in Outlook) under Otions I didn't found "synchronization" tab. After restart Outlook for few hours all was ok, but after I observed the same situation, restart and all is ok... Is some solution of this problem... ...

Viewing toolbar while in report
I've pretty much got this danged database ready for users, but am having a problem with the custom print toolbar I created not showing up in reports. I designated the custom print toolbar in each report property box (those that use it), but the toolbar doesn't appear. Am I doing something wrong? Linda ...

Filter Report by Form
I'm using the following code from the wonderful Allen Browne which works perfectly in an either or scenario (either by Start/End Date(s) OR filtering by client name; but I don't know what syntax to use to filter by Start/End date(s) AND anything typed in the client name field. I'm sure it's easy but I can't get my head around it. I appreciate any and all assistance!! Private Sub cmdPreview_Click() 'On Error GoTo Err_Handler 'Remove the single quote from start of this line once you have it working. 'Purpose: Filter a report to a date r...

How to print Z report twice?
Last night I run the Z report but the paper got stuck. When I tried to run it again it shows 0 sales. My trainer told me that the Z report can only be run once. Is it true? If not how can i retrieve the information again and run the report for the 2nd time? You can find it in the journal viewer just like a receipt and reprint it from there. <oez4u@yahoo.com> wrote in message news:1154589409.592371.315400@i42g2000cwa.googlegroups.com... > Last night I run the Z report but the paper got stuck. When I tried to > run it again it shows 0 sales. My trainer told me that the Z report...

Installing CRM on 2003 Web Edition
Has anyone installed CRM 1.2 on Windows Server 2003 Web Edition. The implementation guide is says it is a supported OS, I am planning on attaching WS03 Web Edition to an SBS 2003 server. I know that the supported configuration has everything on the single SBS box, but I would much rather put some things on other boxes. I am also planning on putting SQL Server on its own box as well. Any comments on this configuration? thanks, Geoff Hi, Beware that SQL Server cannot be installed on a Web Server edition ! -- Olivier Schmitt Microsoft Business Solutions Support Ce message est fourni...

KB Article
I can't get Money 04 to sign in via Passport under one of my computer's profiles. All others work ie. Domain Administrator when logged into the domain and the normal user under the "this computer" profile. However, the one profile I would like to use for normal user login doesn't work. I have tried removing Money, removing all references to Money in the System Registry (HKEY_LOCAL_MACHINE & HKEY_CURRENT_USER), and then reinstalling without being able to resolve the problem. I have also Registered the Msxml3.dll file all to no avail. I have seen postings si...

CRM and Exchange Problems
Dear All, i have a problem between CRM and exchange, my setup is as follow:- i have a single computer with Windows Server 2003 installed, Exchange 2003, and CRM 1.2, CRM is working just fine, the samething is with Exchange OWA, however, i can't get CRM to send mails throught Exchange, i've installed the Exchange E-Mail Router but with no success, is there is any kind of incompatability between CRM and Windows or Exchange 2003, is there is any guide to follow to solve this? Thanks in advance GQ ...

Creating opportunity using CRM api
Looking for an example of how to load the crm api to create an opportunity using C#. I'm way new to this and have downloaded the CRM 3.0 sdk but not sure how I access the information it contains. What I'm hoping to find is an example of creating an opportunity with just the necessary information so I can build on it from there. I appreciate any help! Hi Jeffa When you install the SDk you will notice there is a help file in the installed directory of the SDK, I think it is crmsdk3_0.chm Open the helpfile and search for create, there are lots of examples let me know if you get s...

Crystal Reports 9.2.3 and CRM
Hi, I'd like to know if CRM does work fine with the Crystal Reports Pro Version 9.2.3. I know the recommanded version is 9.2.2 but was just wondering if somebody successfully worked with 9.2.3/CRM Thanks Eric I have used a version line 9.2.4 so I would assume yes it will work. Only way to be sure is to try it. -- John O'Donnell Microsoft CRM MVP http://www.mscrmfaq.us "Eric" <NOSPAMerich742001@yahoo.fr> wrote in message news:%23GB4wV9SFHA.1040@TK2MSFTNGP10.phx.gbl... > Hi, > > I'd like to know if CRM does work fine with the Crystal Reports Pro Ve...

Moving CRM
Hi All. I am in the process of relocating CRM 1.2 to a new SBS 2003 Server. If I have not created any custom reports with Crytal Reports, is it really necessary for me to back that up and then restore it on the new server? Since I have only been using the default reports, shouldn't everything be fine??? THanks! Jake, You shouldn't need to migrate the reports. But, are you using the redeployment tool for this? If so, then there may be some reasons that this introduces that make it a requirement. Matt Parks MVP - Microsoft CRM ---------------------------------------- ---------...

CRM 3.0 Mobile for Cingular 8525 (HTC Hermes)
I was just looking at the minimum requirements for CRM 3.0 Mobile and I see only the Texas Instruments and Intel processors listed. The 8525 uses a Samsung 400MHz processor. Is there a plan in place to test and release on this platform? The Intel processors usually mean Xscale processors or ARM processors. The Samsung chip is almost certainly a repacked ARM processor so should work. ============================== John O'Donnell Microsoft CRM MVP http://www.crowecrm.com "captbackfire" <captbackfire@discussions.microsoft.com> wrote in message news:A818737C-44F3-4...

Slow acces CRM 3.0
Hi, We have a problem, our CRM goes slow. There are 10 active users using CRM with web browse, and sometimes Outlook client. Our server is a Compaq Proliant with 2 processor Xeon and 2 Gb of RAM. We installed CRM SBS, exchange, sql server in the same server. We accomplish all recommended requierements says by Microsoft but when I go to open an account it's delay about 10 seconds. Why?? thanks in advance I have recently come accross a client that forgot to turn of the tracing in CRM, and this was causing a lot of delays, and the type of wait time's that you describe. Could it...