Friday, March 23, 2012

reporting services Parameters Postbacks

Hi,
I had an experiment with the reporting services.
I created a report with 2 parameters param1 and param2, while param2 depend
on param1 (i.e., while selecting param1 param2 refreshed). In the SQL Server
profiler i can see that while selecting param1, the param1 stored procedure
run again (sometimes more than once).
Does someone know if there is a SSRS bug?On Jan 19, 1:08 pm, Shlomi <Shl...@.discussions.microsoft.com> wrote:
> Hi,
> I had an experiment with the reporting services.
> I created a report with 2 parameters param1 and param2, while param2 depend
> on param1 (i.e., while selecting param1 param2 refreshed). In the SQL Server
> profiler i can see that while selecting param1, the param1 stored procedure
> run again (sometimes more than once).
> Does someone know if there is a SSRS bug?
I do believe that this might be due to the postback in the Report
Manager (as you eluded to). A long shot might be to try checking web
config settings in the SSRS path (normally located at: C:\Program Files
\Microsoft SQL Server\MSSQL.2 -or- MSSQL.3\Reporting Services
\ReportManager). There might be a way to change the postback nature,
though not very likely. Sorry that I could not be of greater
assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

No comments:

Post a Comment