Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How do use multiple Datasets with CRM 2011 BIDS Fetch Extension

Posted on 2011-09-30
1
Medium Priority
?
1,931 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 2000 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

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

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…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

670 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