Creating Dataset From Multiple "entities", SQL Server 2008 R2
Sep 30 2016, 02:13 PM
Joined: 5-June 15
I am muddling around in MSSR builder and have figured out how to make multiple reports, but I can't figure out how to make a report that pulls fields from multiple 'entities'. I choose the schema I want to pull data from and then am shown all the available entities and their fields, but as soon as I select a single field from an entity the rest of the entities disappear. I hope that this is a relatively easy fix that I am just missing, because I feel like am picking more up from experimenting than I have trying to read on this. Any help you can give is much appreciated.
Oct 20 2016, 02:50 PM
Joined: 27-February 09
Not sure I'm following what you're doing. Are you using SSRS to build your reports or Report Builder? Since I have SQL Server and the dev tools on my laptop, and I'm the administrator, I can just create stored procedures in Mgmt Studio and then consume them in SSRS... just point to a stored procedure that returns the data I want to use as the basis of my report, and I'm most of the way there.
How much are you allowed to do inside the database? If the stored procedures to return all the data are already written for you, you can right-click on the DataSets folder and choose Add Dataset, and then select "use a dataset embedded in my report", choose your database, and finally select the stored procedure that returns the data you need.
If there is no query/stored procedure that returns the data you want, you can click the Query Designer button and build one yourself.
Oct 28 2016, 11:03 AM
Joined: 5-June 15
Thank you for your response. I was having an issue with the permission levels that I was given. Once this was cleared up I was able to actively make changes and additions. Thank you.
|Search Top Lo-Fi||23rd March 2017 - 11:19 PM|