Report Designer: Only fields from the curent Dataset 'DSMain' can be added
Hi, Posting for the first time in "Reporting Services" forum. Practicing Report Sever Projects. I have developed a report over the CRM 4.0 using Report Wizard and then downloaded it to modify in VS 2008 BIDS. I came to know that I shouldn't modify the dataset DSMain (generated by CRM Report Wizard). Instead make my own dataset to add fields I wanted to add in the DSMain. I referred to the following post CRM customized SSRS reports error in DSMain and won’t upload Now I have developed a new dataset according my needs, but when I go to add any field from this new dataset to the existing report table. But it is not allowing to do so. Error: Only fields from the current dataset 'DSMain' can be added If I can't add fields from multiple datasets to a single table, then how could I arrange those fields (from two datasets) over a single (detail) line of report? Regards,Paradise lies at the feet of thy mother. - Prophet Mohammed (PBUH)
January 14th, 2011 5:32am

Hi Ali.NET, By generally, a report data region control could only display the datafields in one dataset, if you want to utilize the datafield contained in the other dataset, you have to redesign your T-SQL to join there dataset together under database. Only in SSRS2008 R2 version, can we use Lookup, MultiLookup and LookupSet to do the exact kind of pk/fk lookups between datasets. Of course you could degisn a subreport utilizing a different dataset, then display the subreport in your main report. For more information about Lookup Function, please sse: http://msdn.microsoft.com/en-us/library/ee210531.aspx Thanks, Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
January 17th, 2011 3:24am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics