Solved

How do use multiple Datasets with CRM 2011 BIDS Fetch Extension

Posted on 2011-09-30
1
1,861 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

710 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