| Author |
Topic |
|
fireloard
Starting Member
23 Posts |
 Posted - 2005-08-29 : 14:47:22
|
| I have report that I want to pass the parameter of the cell clicked on to an asp .Net page. Under the navigation I entered the URL ofhttp://local/local.aspx?Unit= =First(Fields!unit_name.Value, "AllUnits")but of course it doesn't process the field. Is there any way to call an aspx page and pass it the value of the field being clicked on? I tried google and search of the forum but I can't seem to find a good example of this. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-29 : 14:56:18
|
| Check out the article "URL access" in SQL Server Reporting Services Books Online.Tara |
 |
|
|
fireloard
Starting Member
23 Posts |
Posted - 2005-08-29 : 17:27:01
|
| Do you have a link to this article? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-29 : 17:31:14
|
| Books Online is installed on any computer that you have installed Reporting Services on. Go to Start..Programs..Microsoft SQL Server..Reporting Services..Reporting Services Books Online.Tara |
|
|
|
fireloard
Starting Member
23 Posts |
Posted - 2005-08-30 : 07:54:08
|
| Seems to give a lot of information about how to pass parameters to a report using a URL but not how to pass parameters to a webpage using a URL. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-30 : 07:59:17
|
| The mechanism is identical, whatever other details you need are documented in the Visual Studio and .Net Framework help. Look for "Request" and "Querystring" as well. |
|
|
|
fireloard
Starting Member
23 Posts |
Posted - 2005-08-30 : 10:54:29
|
| I found my problem I needed to change the URL to "http://local/local.aspx?Unit=" & Fields!unit_name.ValueI wonder why this was so hard that no one could just give me this example. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-08-30 : 13:19:44
|
| I wonder why it was so hard for you to research the answer in the first place. |
|
|
|
fireloard
Starting Member
23 Posts |
Posted - 2005-08-30 : 15:30:43
|
| It wasn't listed in the article... I determined it from trial and error. |
|
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-09-13 : 07:50:12
|
| Fireloard thanks for the example. That also helped me out.I've been in situations where you are now, where it could take someone 2 seconds to tell me what it is but instead tell me where to look and don't find the answer or will need to dig in for about 30minutes or more to find the answer. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-13 : 13:50:28
|
| I'm not sure why you guys think that we shouldn't direct you to the place that has the information. You do realize that we answer questions for free, right? Granted we do provide exact answers occasionally, but it depends on the level of information provided in the initial post. But, I didn't have the exact answer to the question so I led him to an article that I thought was appropriate.Tara |
|
|
|
|
Pass parameter to aspx page?