Microsoft CRM Report Viewer Bug ? 04-15-07

When viewing report in Microsoft CRM Report Viewer, it extracts 
the filter info from the RDL file. When user saves the default 
filter it's also stored in the RDL. The filter info is actually 
the Fetch XML which is build dynamically by the viewer control. 

I've created a report and in the RDL file specified the Fetch XML 
with linked entities and attributes for each linked entity. This 
way when report is executed, the Fetch XML is converted to the SQL 
statement which is used as report data (when executed). Report 
viewer displayes the filter correctly BUT when it builds the Fetch 
XML again, it does not include the attributes for the linked 
entities. For this reason the SQL statement is incorrect - because the 
fields from the join table 
(link entity) are not included. 


Is it bug ? Is there any way to solve this problem ? 

Any help is appreciated. 

Thanks in advance
0
Utf
4/15/2007 2:14:01 PM
crm 35858 articles. 1 followers. Follow

0 Replies
656 Views

Similar Articles

[PageSpeed] 45

Reply:

Similar Artilces:

Use Form to prompt for report criteria
I have a form that I am using to prompt for report criteria. When I run the query outside of the form, it works fine - prompting me for both criteria. However when I run from the form, I get #Error#. Can you see what I am doing wrong? Thanks in advance. I have two combo boxes that I have put in my underlying query. In the fields of the query are: [Forms]![frmSelection Criteria Form]![OfficeNumber] [Forms]![frmSelection Criteria Form]![Manager] *** On the OnClick event is the following: Private Sub Command6_Click() On Error GoTo Err_command6_Click Dim stDocName As String st...

Microsoft CRM server is not responding
Hi, Workflow Manager write: The specified Microsoft CRM server is not responding. This might happen if it is currently unavailable, it is not a Microsoft CRM server, or you are not a valid user. Fro more information, contact your system administrator. How fix it? In IE i can logon to CRM. ----- wbr, Eugene I've resolved this problem by restoring the metabase with the original version in IIS Regards Edgard Eugene wrote: > Hi, > > > Workflow Manager write: > > The specified Microsoft CRM server is not responding. This might happen if > it is currently un...

Report.SalesPlusTax
I don't know if you guys have ever try to show the total tax sale on the z report, but when i make the modified on the z report it came out that the total tax is 0. It didn't show me anything, i don't know if the script is wrong or the script is not working for RMS V1.3?? Has anyone ever tried that?? <ROW> "Taxable Sales|" Report.SalesPlusTax </ROW> ...

Microsoft Great Plains SDK Documentation.
Any idea where i can find Microsoft Great Plains SDK Documentation.(We dont have Microsoft Great Plains License). Thanks Nath Nath -- If you have a Universal subscription to MSDN you are able to download the SDK information for Microsoft Great Plains. -- Kirsten Any views contained within are my personal views and not necessarily Microsoft Business Solutions policy. This posting is provided "AS IS" with no warranties, and confers no rights. "Nath" <Nath@discussions.microsoft.com> wrote in message news:BAB062FF-8C3D-42F8-BA00-0F83A95D5B64@microsoft.com... &g...

Report CRM 3.0
Hi, I would need to find out the detailed procedure (step by step) to customize a report…. Could anybody inform about any links or documents concerning this issue? Thank's Marco I'm not sure if it's detailed enough, but the technical training manual has a section on creating and customizing reports. You can find it here: http://www.microsoft.com/businesssolutions/crm/using/whatsnewtechnical.mspx HTH, -- Jeffry van de Vuurst CWR Mobility www.cwrmobility.com -- "Marco Rocca" <Marco Rocca@discussions.microsoft.com> wrote in message news:CEF80683-EC26-456C-82C...

Metadata Cache Error 04-14-04
When trying to "Go Offline" after synchronization completes I receive the: "Metadata Cache Error" No Entity Anyone experience/solve this issue? Hi, You may have replication setup issue on your SQL server, I suggest you to go through this article : http://mbs.microsoft.com/TechKnowledge/techknowledge.asp?print=true&id=33588&code=7842 If this is OK, you may test the following manipulation : Open SQL Enterprise Manager; go to Start select All Programs and then Microsoft SQL Server. Expand Microsoft SQL Servers, expand SQL Server Group, expand your Microsoft CR...

Accessing MIcrosoft Outlook
Yesterday, when I tried to access Outlook in my home pC, I received the following message: Cannot open MIcrosoft Office Outlook. Cannot open the Outlook window. The set of folders cannot be opened. The file C:|Users \jillandgordon\AppData\Local\Microsoft\Outlook\Outlook.pst is not a personal folders file. Does anyone have any ideas as to how I can fix this? Masny thanks, Gordon in TX Try this first http://support.microsoft.com/kb/287497/ "Gordon McDougall" <braidwoodboy@gmail.com> wrote in message news:d0e17ac8-0215-431c-971f-bd862b58a245@y17g2000yqd....

Just Testing 09-07-07
Just Testing please ignore -- Jim Bunton ...

CRM 4.0 Custom Report Filter Problem
I am using the Report Wizard to create a simple report. Report is using Quotes and Quote Products I have a custom field in Quote Products which is a bit field Yes-No When I use that field as a filter for report output, I get all records. The filter criteria appears to be ignored Is this an inherent problem with Report Wizard or Am I doing something wrong? Thanks. depends on your business logic and what you want to see. If you have three quotes: Quote-1 has three products, all with the custom field set to Yes Q2 has three products, two set to Yes, 1 to No Q3 has three products, all set...

stock variance report
Hi there, Is there any way to edit that stock variance report at HQ? There are no $$ values and this is quite important at HQ. How do others work with this? IB Ivan, Create a custom report using the Quantity Discrepancy List as a template, add the SnapShotCost, SnapShotLastCost and/or SnapShotReplacementCost column from the ItemDynamic table times the qty difference. -- * "Ivan Brebner" <ibrebner@premiumretail.com.au> wrote in message news:%23Idw6wPAGHA.2912@tk2msftngp13.phx.gbl... Hi there, Is there any way to edit that stock variance report at HQ? There are no ...

Excel 12-06-07
How do I split a text line into two or more lines? -- spørger On Thu, 6 Dec 2007 01:46:02 -0800, ladyhund <navn@discussions.com> wrote: >How do I split a text line into two or more lines? Hit ctrl-enter where you want the line break, at least in Access (the subject of this newsgroup). If you want an Excel-specific answer, please scroll down the list of subject areas and post in an Excel group. John W. Vinson [MVP] ...

Limiting CRM application ability to aasigning user to approprite CRM security group
IT administrator that I have for client does not like the idea of CRM application assigning user group automatically. They prefer to do the security group assignment manually. Is this possible? What do I need to do to achieve that? Thanks Kyaw Hi Kyaw, I did it the following way for a customer: 1) You will need to precreate the five groups within your AD. There is no need of having a own OU (Container, Organizational Unit) for them. Follow the naming convention of your company or use the default namings from Microsoft for the five groups. There is no need for your AD Admin to assig...

Report Filter focus
Hey all, I am experiencing an issue with the report filters in RMS. It is not a show stopper, but annoying. When I launch a report in SO Manager on a win XP machine, RMS version 1.3, the report filter is there, but the correct field is not selected and the filter under Filters is not selected. When this happens and I want to change the filter, I first need to click on the Filter itself in the bottom box and then select the correct field out of the Fields list, then change the Value. Is there anything I can do to fix this? To use a real report as an example, When I run the Detailed Sales rep...

Outlook reports OLE registration error
I have Office 2000 running in Windows Me on a Dell Dimension XPS D266 with 64 meg ram. Outlook stopped working so I ran Repair from Office 2000 CD and then Re- install Office from same source. Both times Outlook says" An OLE registration error occured. Program is not correctly installed. Run Setup again." Doesn't seem to be much sense in running it again. What now? Reinstall Outlook Express. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal acco...

Object error when trying to print custom reports
I am getting an [object error] message when trying to print custom reports or modified versions of canned reports. They display just fine within CRM, we just can't print them. I have already tried deleting the ActiveX to force a reload and manually reinstalling it using http://crmserver/viewer/activexviewer/en/npviewer.exe with no luck. This is occuring on systems regardless of whether Crystal Designer is loaded. Any ideas? Open the reports in Crystal that you are having problems with and make sure that the "Save data with reports" option is not checked. (In Crystal...

Exchange server reporting tool
Could someone recommend an exchange server reporting tool other than promodag? I will really appreciate the help. Thanks sl =?Utf-8?B?c2xhd2Fs?= <slawal@discussions.microsoft.com> wrote in news:735D2C55-FB0E-44F4-8F6B-274B754A9FBE@microsoft.com: > Could someone recommend an exchange server reporting tool other than > promodag? I will really appreciate the help. Quest messagestats is good stuff. Regards, -- Arlo Clizer FAQ: http://www.exchangefaq.org Archives: http://groups.google.com i second that... -- Susan Conkey [MVP] "Arlo Clizer" <aclizer@online.goo...

Report sorting 03-16-10
Hi, I have a continious form that displays four fields for each records of a table. On the form I have a sort button for each of the four fields which sorts the records based on the field selected. I also have a report button that prints a report that produces one page per record. My problem is that I want the report to be in the same order that the records appear on the screen which is based on the sort selected. How do I get my report to print in the same order as the records appear on the screen? Your help would be appreciated. Thanks, I would use some code to extract...

New to CRM
In the Contact/Accounts/Leads entry form, is there a preferred or recommend way of typing in the phone, fax, etc. numbers. E.g. 604 222-2222 or 6042223333 or 604-222- 3333? Also in the Address when creating, the Address Name would be the building E.g. Shaw Tower, and for addresses, what is recommended - Address 1 for 123 Main Street, and Address 2 for P.O. Box? With this in mind, what is the best way to enter the Address in Outlook Contacts to ensure a smooth conversion? Thanks! Shauna Microsoft CRM does not care how you enter these values. Currently there is no formatting checks f...

Reports with multiple tables
The layout--- 5 Fields to be searched pre table FieldA, FieldB, FieldC, FieldD, FieldE I have a db with 25 tables. In each of the tables there are multiple fields, but I only want to search through 5 of them (listed above). I want a user to select on what field to search and by what criteria (i.e. Where FieldA=123), and then display this is the report. In the report I want to display the results, but also other information that attached to the record or records(date, time, etc.). How would I go about doing this? To have even a chance of searching 5 fields in 25 different tables, yo...

how do i construct a bar in microsoft word?
how do i construct a bar in microsoft word? > how do i construct a bar in microsoft word? Use Word to write a letter to a general contractor. Ask the contractor for a quote to build a tavern to your specifications. Be as specific as you can about the specs. ...

Microsoft 2007 Access
Please help. I am trying to convert my access from 2000 to 2007 and running into two problems so far. first is that i am told that the gotocontrol on a macro to go from a form to a subform is no longer available. what do i use? how do i get around this? second the field in my main table is called letter and is what is unique to all of my tables. when i try to access a client's info from a form that opens a clients subform - I am told that error 2538 has occured and that this letter field could refer to more than one table listed. and then error number 2950 appears. any ideas? ...

Report Grand totals problem
I have a report with a a few subreports. One sub report has the total fees for an Exhibitor My problem is with in the Report Footer section the grand totals display correctly but when the report is printed to a printer, the grand total section is not correct. Below is what I have More details on the problem: For example if the user is on the last page of the report the total section was doubled. I then added the GrandTotalFees = 0 part and that fixed that problem. If the user is on the first page and prints the report to a printer the total section on the last page is off by the tot...

Is CRM 3.0 available
Hello, We purchased CRM 1.2 with SA. Is 3.0 now available or is it still in beta? Jake Hi, Microsoft will launch Ms. CRM 3.0 on February 2006, but now full version has already released.... the package is different with CRM 1.2. CRM 1.2 we got 7 cds, while this new version, CRM 3.0, only includes 2 cds, Server and Outlook Client only. Regards, Surianto Phen "Jake Smythe" wrote: > Hello, > > We purchased CRM 1.2 with SA. Is 3.0 now available or is it still in > beta? > > Jake > > > Hi Suri! "Suri Phen" wrote > Microso...

CRM Sucks ..
CRM is another Spyware .. It causes the system to freez , popups. Its slow . Specialy if you run it from DOS : * you forgot one, it smells funny too -Gary "Smartie" <anonymous@discussions.microsoft.com> wrote in message news:5EA1C0BB-1C80-46BF-83E6-336057D1214B@microsoft.com... > CRM is another Spyware .. It causes the system to freez , popups. Its slow .. Specialy if you run it from DOS. > :( > > > * Find another product if you that unhappy with MS-CRM. >-----Original Message----- >CRM is another Spyware .. It causes the system to freez , popups. I...

SOP Blank Order Report
is it possible to show the user responsible for holding an order? i tried adding the Sales Process Holds Work and History Table but in order to do this i have to remove the Sales Serial/Lot Work and History from the report table relationship and i need that table because i get an error when i try to print the report if i dont have it on the Report Table Relationship. Thanks. Hoquee, Not sure I am totally understanding what you are attempting, but if your goal is to show who placed an order on hold (from the holds table) then you will need to add this information by using Report Writer...