Solved

How do use multiple Datasets with CRM 2011 BIDS Fetch Extension

Posted on 2011-09-30
1
1,762 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
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.

705 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

18 Experts available now in Live!

Get 1:1 Help Now