Friday, March 23, 2012

Passing data from a sub-report to the main report

Hi,

I'm working with SRS2000.
I have a report with a sub-report.
I need to pass data from the sub-report to the main report.

How to do this ?

Ok, after sending messages to SRS specialists, it seems that there is no answer to this question...

It is impossible to do that with Reporting Services 2000!

Crystal Report 1 - SSRS 0.

|||

That's correct - you can't pass parameters from a subreport to the main report.

When I was using Crystal reports I used a lot of subreports. However, with SSRS, for many of the reports that used to require a subreport, I now use stored procedures - so I can gather all of the data, then create a sql select statement that outputs the data - all inside the stored procedure

|||

jamvir:

That's correct - you can't pass parameters from a subreport to the main report.

When I was using Crystal reports I used a lot of subreports. However, with SSRS, for many of the reports that used to require a subreport, I now use stored procedures - so I can gather all of the data, then create a sql select statement that outputs the data - all inside the stored procedure

Right, I use the same technic so this is workaround.

|||

Pluginbaby:

jamvir:

That's correct - you can't pass parameters from a subreport to the main report.

When I was using Crystal reports I used a lot of subreports. However, with SSRS, for many of the reports that used to require a subreport, I now use stored procedures - so I can gather all of the data, then create a sql select statement that outputs the data - all inside the stored procedure

Right, I use the same technic so this is workaround.

Is it a workaround when it becomes more efficient?

No comments:

Post a Comment