CODEWITHSUNDEEP
reporting-servicesdatasetreportingservice
Alex
Alex

Reputation: 2011

Reporting Services - HOWTO: Create a DataSet from another DataSet!? Is it possible?

I have a report with two Datasets. The first loads a lot of data displayed in a tablix. The second DataSet is used to display a Chart with an alternative perspective on the same data.

I dont want to load the data twice, so currently I store the data from the first query in a special cache table in the database. The second query reads only from the cache table.

Now it would be much nicer if I could create the second Dataset directly within SSRS and saving this second round-trip to the DB. Preferably I'd like to define the second dataset something like:

SELECT val1, val2 FROM dataSet1 WHERE val3 = 'something'

Anybody know if this is possible?

Any hints appreciated!

Upvotes: 1

Views: 772

Answers (1)

user359040
user359040

Reputation:

If both the tablix and graph are representing the same data (even from different perspectives), then I would suggest using the same dataset for both the tablix and the graph.

Upvotes: 1

Related Questions