Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
swenri
Yak Posting Veteran
72 Posts |
 Posted - 2007-09-05 : 14:08:46
|
| Hi All, Is there a way using the report servers default Reports website is there anyway to pass the variable in the url string? If so can someone please let me know what the url would look like.All inputs are highly appreciated.Thanks, |
|
|
jhermiz
3564 Posts |
Posted - 2007-09-06 : 13:20:28
|
quote:
Originally posted by swenri
Hi All, Is there a way using the report servers default Reports website is there anyway to pass the variable in the url string? If so can someone please let me know what the url would look like.All inputs are highly appreciated.Thanks,
I assume you mean a parameter for a report. The answer is well sort of..you're actually using office web components if you want to do that. What you want to do is this:Open a report from the RS websiteSelect any parameter for that report, provided that you have a report that takes parametersIn the export section select office web components I think is the selection and allow the report to export.Copy and paste that url to something like notepad...and analyze it. Look how SSRS passes parameters in the URL.Now when you want to open the report and pass the parameter from a web interface or a windows form just create a similiar URL like the one you pasted above. Pass the parameter and open the report and you will have the data you need.Thanks,JonWeblog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
Kristen
Test
22859 Posts |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-06 : 15:14:24
|
Ah ... I see you beat me to it  |
|
|
|
|
|
|
any way to pass URL ?
you might like to take a look at the recent posts with zero replies in this forum