data set reuse in the same report

Is there a way to reuse a data set in a report?
Example:
report has 2 data sets, ds1 and ds2.
ds1 calls a sproc that returns the data.
ds2 use the same data but filters it and displays it in a different
way.
the queries that generate the data are long (over 1 hour) and I don't
want to call the sproc again to generate the same data for ds2.
is there a way to reuse the data from ds1?
thanksOn Apr 10, 11:03 am, "jlemm" <beasyou...@.gmail.com> wrote:
> Is there a way to reuse a data set in a report?
> Example:
> report has 2 data sets, ds1 and ds2.
> ds1 calls a sproc that returns the data.
> ds2 use the same data but filters it and displays it in a different
> way.
> the queries that generate the data are long (over 1 hour) and I don't
> want to call the sproc again to generate the same data for ds2.
> is there a way to reuse the data from ds1?
> thanks
You should be able to reference the data from ds1 via something (an
expression) like this (if using a textbox control):
=Sum(Fields!SomeFieldName.Value, "ds1")
You should be able to reuse the dataset as well in another table
control (via selecting ds1 as part of the general properties), etc;
however, as far as, not re-executing it, I can't say. I would suggest
trying to improve the performance of your query as well (via the Data
Engine Tuning Advisor, SQL Profiler, etc). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

data not appearing

In the data flow, I have an "OLE DB source" container that calls an SP. The SP does a select statement at the end. If I hit the "Preview" button I'm seeing the results come back, however, when I go to the columns I'm not seeing anything. I don't see the column name. Is there any reason why I don't seem to see this column coming back?

Thanks,

Phil

That issues has been address in this fourm. Try searching..I just found these:

http://forums.microsoft.com/MSDN/Search/Search.aspx?words=OLE+SOurce+stored+procedure&localechoice=9&SiteID=1&searchscope=forumscope&ForumID=80