May 5, 2011 at 7:44 am
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
May 5, 2011 at 7:52 am
I've never seem this particular behavior.
I've seen groupinigs work slightly differently so yes this is definitely possible.
Can you post a screenshot of the 2 action setups you have for the parameters? Maybe you missed something obvious.
Have you run started a trace to see what parameters are sent to the server and confirmed that the queries return the correct results?
Other than that I have no idea of what's going on.
May 5, 2011 at 8:00 am
Hi Ninja
thx for your quick reply.
I have added the screenshots you asked. If I provided you the wrong ones, please let me know. I can set the action properties on both the textbox as the placeholder. If I press in the cell I get the selected text/placeholder properties window, if I press on the cell border, I get the textbox properties. So I configured both and send a screenshot from both.
The queries work correctly.
I have checked the parameters passed on and in de BIDS, the correct parameters are passed on each time, but in IE, I found out that only the parameters for the first row get passed on no matter which row you click on.
So the problem lies indeed in the wrong parameters, what I dont get is why? In BIDS the correct parameters get passed on, in IE not... 🙁
May 5, 2011 at 8:06 am
Parameters are annoying in deployement (sometimes they don't erase correctly and that part of the update fails).
Go in IE, DELETE both reports. Redeploy.
That always solves my problems with parameters in ssrs 2005. Maybe that bug carried on in 2008.
May 5, 2011 at 8:12 am
Sorry, already tried that one, didnt work 😀
A colleague who has more experience with SSRS 2005 also does the same thing you suggested, that solution works for him too (in 2005)
May 5, 2011 at 8:17 am
Right now I would be adding textboxes in the subreport to display the parameter values.
Something just doesn't add up and I'm not seeing it.
I'm sure you'll figure this out, I'm out of options at this point and I don't see your screen !
May 5, 2011 at 8:22 am
I am glad we are thinking in the same direction :-).
I also used textboxes on the subreport to check what parameters are passed on.
BIDS: correct parameters
IE: only the parameters of the first row.
This is a really strange problem. Why would it work in BIDS and not in IE??!!
May 5, 2011 at 8:23 am
pkloukas (5/5/2011)
I am glad we are thinking in the same direction :-).I also used textboxes on the subreport to check what parameters are passed on.
BIDS: correct parameters
IE: only the parameters of the first row.
This is a really strange problem. Why would it work in BIDS and not in IE??!!
PSS support.
You did all you could at this point.
Are you up to date in the service packs?
May 5, 2011 at 8:33 am
I am not the server administrator, I will ask the guys here about the service packs. I guess we are talking about the Microsoft SQL Server 2008 R2 service pack right? And not the OS (Windows 2008 R2) service packs.
Now that I am looking into it, this is the info I get for the system itself...
Windows 2008 R2 No Service Pack (2008R2.X64.2.6)
May 5, 2011 at 8:38 am
pkloukas (5/5/2011)
I am not the server administrator, I will ask the guys here about the service packs. I guess we are talking about the Microsoft SQL Server 2008 R2 service pack right? And not the OS (Windows 2008 R2) service packs.Now that I am looking into it, this is the info I get for the system itself...
Windows 2008 R2 No Service Pack (2008R2.X64.2.6)
Probably both. Last time (only time) I called they asked to have the latest packs on. Saves lots of time on troubleshooting.
Also when the product is near the end of the support cycle, you can't even call if you don't have the latest (and only) supported version.
I think you're still alright with 2k8 and PSS.
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply