October 20, 2009 at 6:09 am
Hi. I would like to 'Jump' from Report 1 in folder A to Report 2 in Folder B on the report server and pass a parameter.
Report A - User enters ProductId string @ProductId (i.e. 14).
Report A lists all products beginning with 14.
If user then selects one of the Products returned from report A I want to jump to Report B, rendering using the value selected in Report A
I was able to use 'Jump to Report' by putting the reports in the same project. In the real world the report sit in different folders.
Both reports accept the same parameter '@ProductId'. I added 'Jump to URL' from the ProductId field in Report A as follows:
="http://MyPath/Pages/Folder.aspx?ItemPath=%2fMyFolder%2fReports%2My+Subfolder&ViewMode=Detail/Folder Name&rs:Command=Render"
[/Code]
The folder opens 'Folder Name' in my example but the report did not render. I have not attempted to add the @ProductId parameter as I was unsure of the syntax.
Any help as always very much appreciated.
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
October 20, 2009 at 6:31 am
I amended code as follows:
="http://MyPath/Pages/Folder.aspx?ItemPath=%2fMyFolder%2fReports%2My+Subfolder/Folder Name&rs:Command=Render"
I also tried
="http://MyPath/Pages/Folder.aspx?ItemPath=%2fMyFolder%2fReports%2My+Subfolder/Folder Name&rs:Command=Render&ProductId=@ProductId"
When I select the link reporting services returned error:
[Quote]
The operation you are attempting on item "/MyFolder/Reports/Sub Folder/Folder" is not allowed for this item type. (rsWrongItemType) Get Online Help
[/Quote]
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
October 20, 2009 at 8:00 am
Still searching.....
I have:
="void(window.open('" & Globals!ReportServerUrl & "?%2fTopLevelFolder%2fSubFolder%2fMy+Folder+Report+Name&rc:ToolBar=False&rc:Parameters=False&ProductId=" & Fields!ProductId.Value & "', 'popup','location=no,toolbar=no,left=100,top=100,height=600,width=800'))"
The above does nothing when the ProductId field is clicked in the report so my sysntax is wrong.
I an unsure how I should be referencing the Report Server.
I do have a DNS records for the Reports Server, users can enter - http://company/reports rather than http://servername/Reports
Any ideas?
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
October 20, 2009 at 9:04 am
The resolution was as follows:
="http://server-name/ReportServer/Pages/ReportViewer.aspx?%2fTopLevelFolder%2fSubFolder%2fSubFolder%2fReport+Name&rs:Command=Render&ProductId=" & Fields!ProductId.Value
Thanks to all those who took time to review this post and I hope the resolution helps others.
Kind Regards,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply