Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 430
  • Last Modified:

Reporting Services 2005 - Shared Dataset

I've searched and seen this same question asked several times on EE, but I just have to ask again. Is there not some simple way to create a dataset (not a datasource) once, and then use that dataset in multiple reports without having to manually add it into each report by hand? I already saw someone posted that you can copy/paste the desired sections from the XML (view source) of the RDL file....but that's not really what I was looking for.

Is there still no built-in functionality in Reporting Services 2005 to accomplish this?
0
friskyweasel
Asked:
friskyweasel
  • 2
  • 2
2 Solutions
 
SQL_SERVER_DBACommented:
Not that I know of, that doesn't mean it doesn't exists! You know this Im sure, but you could just create a stored procedure and have the reports call that.
0
 
friskyweaselAuthor Commented:
yup that's true - but i guess it's the idea that you even have to "create" another dataset in the first place...even if that dataset is populated by a stored proc rather than hand-writing the sql every time.

If i have a drop-down filter that allows a user to select a color...and i know that filter will be used multiple times across my reports...i shouldn't have to create a dataset named "dsColorFilter" over and over if i know it will be used in every report

It's being a bit picky I know...but imagine when you have 40 and fifty reports to do...and 3 out of 5 filters/dropdowns on each report are actually common to all reports...you could save a lot of time if you could just create them one time and then re-use them.

I'll leave the question open for a while longer to see if there are any other ideas or something i'm missing here.
0
 
SQL_SERVER_DBACommented:
oh, I see you have a point...I don't think I can help you here but it is good food for thought.
0
 
PFrogCommented:
Your best bet is to set up a single report how you want it, with all common datasets, titles, headers + footers etc.
Then copy the file to the following directory:
     C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject

Then, when you create a new report, the report you just copied will be available in the templates. This saves recreating it every time. It also helps create a standard look and feel across all of your reports.
0
 
friskyweaselAuthor Commented:
thanks for your efforts guys - PFrog I think your suggestion probably comes the closest, but SQL Server DBS's is also viable - i'm going to do an 90/10 split
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now