Report behaves different in Development Studio and ReportServer (IE)

[philipnl]

Hi everybody,

I have two reports. Report nr1 shows a list of users. Report nr2 lies on top of it, showing the number of users within a certain server and mailserver. Report nr2 has a tabular form and shows a grid with numbers (the number of users per servers/mailserver). Let's say I have 6 users. The table would look like

Server 1 MailServer 1 2
Server 1 MailServer 2 1
Server 2 MailServer 3 2
Server 3 MailServer 6 1

When I press the first '2' I get redirected to Reportnr1 (subreport in this occasion) and the 2 users linked to Server 1 and MailServer 1 are shown. When I press the second '2' in the example above, I go to Reportnr1 and the 2 users linked to Server 2 and MailServer 3 are shown.

Server and MailServer are parameters passed on to the subreport. For the numbers I use the property Action in the cell of the table, choose 'Go to report' in the Action properties tab. The two parameters are passed on there.

The strange part is, that when I run the report in the development studio using the Preview tab everything works correct. In Internet Explorer though (ReportServer), the report behaves differently. I will always get the parameter passed on to the subreport of the very first row in my table in the top report. So I will always get Server 1 and MailServer 1 as parameters even though I choose for the other numbers (wich are linekd with other parameter values for Server and MailServer).

How is it possible that the reports behave differently between BIDS and IE??

Thanks a lot in advance

 

[xlbo]

Lets get the basics out of the way - what version of SSRS and have you definitely deployed the latest version of your report

Also, please confirm that when you say subreport, do you mean another report embedded within the main report?

When you set up your action, do you set it to jump to report 1 ro report 2?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question