Solved

How do use multiple Datasets with CRM 2011 BIDS Fetch Extension

Posted on 2011-09-30
1
1,787 Views
Last Modified: 2012-05-12
I am trying to create a report using CRM 2011 BIDS Fetch Extension. In my BIDS Project, I am able to set my datasource type to "Microsoft Dynamics CRM Fetch" and set the XML for the Dataset Query. This pulls data successfully. I have placed a table on the report that displays company name, etc as I navigate through the pages. That is all good.

Now, I want to add another table to the report and bind that to a different dataset, but what I am not sure is how this dataset, or second table, knows what group is being displayed as each group is navigated? Do I specify something in the query (i.e. XML)?

Sorry for the ignorance....a little new to working with this.
0
Comment
Question by:obautista
1 Comment
 
LVL 10

Accepted Solution

by:
GDG_DBA earned 500 total points
ID: 36900099
You can't create another dataset to bind to groups like you've described.  It sounds like what you want is a sub-report.  

To do this:
1. Create another report with a dataset and layout you want displayed for any particular group in the first report.  
2. Create parameter(s) in the second report to control what data is in the dataset.  
3a. If you want to expand the details of the second report within the first, drag a sub-report object into a cell at the group or detail level you want it. (Set the values for the subreport object and the values from the first report's values to send to the second report's parameters.)
3b. If you want to drill-through to the second report, choose a text box in the group or detail level row and set the action to open the sub-report. (Select the subreport and the values from the first report's values to send to the second report's parameters.)

Let me know it you have further questions.

Best Regards,
-G

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now