| Groups | Blog | Home |
sql server reporting services : Passing parameters thru URL to ASP.NET
do i retrieve the parameters values from the URL using ASP.NET? And also vice versa. that means how do i pass parameters from ASP.NET to reporting services and how do i retrieve the parameters values using reporting services.
ok.. so the example u given me is for passing parameters from asp.net to
reporting services? and how do i display the parameters value that is been passed in the URL to display in my report textbox? for the other way on passing parameters from report services to asp.net.. is because i got a page(done in RS) where user can click on the column call "Suggestion ID" and they will be transfer to a aspx page where i need the suggestion ID to query the database tables to get extra information to display in that aspx page and they are able to evaluate the suggestions from that aspx page by clicking on the Accept, Reject button available on the page. I done this in aspx page because my supervisor wants a real button instead of those "textbox" like button in reporting services. thanks for your help! [quoted text, click to view] "avnrao" wrote:
> Generally parameters are flown from ASP.Net to reports. > > If you are getting parameter values to ASP.Net app in query string use this > : > myParamValue = Request.QueryString["paramName"]; > // append it to report URL > http://serv/reportserver?/path&myParam=myParamValue > > If you are getting parameter values to ASP.Net in form submit, use this : > myParamValue = Request.Form["paramName"]; > // append it to report URL > http://serv/reportserver?/path&myParam=myParamValue > > and about the Other way, passing parameters from reporting services to > ASP.Net?? I dont think why we need to do this? do you have any specific > requirement? > > "JiaN" <JiaN@discussions.microsoft.com> wrote in message > news:C51CAFD7-665A-4173-81EA-1716F70779A1@microsoft.com... > > How do i pass parameters from reporting services to ASP.NET thru URL? and > > how > > do i retrieve the parameters values from the URL using ASP.NET? > > > > And also vice versa. that means how do i pass parameters from ASP.NET to > > reporting services and how do i retrieve the parameters values using > > reporting services. > > > > Thanks in advance for the help. > >
1. ya ok, i had follow ur instructions and is now able to display the
parameters values in my report.. Thanks alot! 2. Now for the second point. I will tell you what i wan to accomplish in this part. Ok, so for example now i am viewing a page(done in reporting services) that got all the suggestions submitted. And in order to view the full information of the suggestions, i had to click on the Suggestion ID column and it will invoke into an aspx page where the full information can be displayed. So for now, i does not know how to display the full information for the aspx page base on the respective Suggestion ID that had been clicked when at the reporting services page. (Reporting Services Page) --------------------------------------------------------- Suggestions ID Suggestion Title 1 Carpark 2 Toilet ... ... ... ... --------------------------------------------------------- So i am now viewing the page done in reporting services, and in order to view the full information of the suggestions, i had to click on the Suggestions ID. For example, i click on Suggestion ID "1", user will be transfer to a aspx page where they can view the complete information of Suggestion ID "1". And so what should i do in order to display the correct information for Suggestion ID "1" in the aspx page when user clicks on the Suggestion ID "1" from the reporting services page. hope you understand my problem so far.. sorry for the trouble and time spent. thanks [quoted text, click to view] "avnrao" wrote:
> 1. you can make the parameters appear in Report textbox by placing > Parameters!ParameterName.Value in the report text. does this serve your > purpose? > > 2. You are trying to invoke an aspx page from a report. so have a link in > Report which points to your aspx page > (http://server/aspxapp/my.aspx?parameters) and you have to pass parameters > in query string only. (tell me if you can use a form to submit..i dont know > that). > > hth > > "JiaN" <JiaN@discussions.microsoft.com> wrote in message > news:9F8D8FC3-6E84-441A-A4CE-CA14BEFB182A@microsoft.com... > > ok.. so the example u given me is for passing parameters from asp.net to > > reporting services? and how do i display the parameters value that is been > > passed in the URL to display in my report textbox? > > > > for the other way on passing parameters from report services to asp.net.. > > is > > because i got a page(done in RS) where user can click on the column call > > "Suggestion ID" and they will be transfer to a aspx page where i need the > > suggestion ID to query the database tables to get extra information to > > display in that aspx page and they are able to evaluate the suggestions > > from > > that aspx page by clicking on the Accept, Reject button available on the > > page. I done this in aspx page because my supervisor wants a real button > > instead of those "textbox" like button in reporting services. > > > > thanks for your help! > > "avnrao" wrote: > > > >> Generally parameters are flown from ASP.Net to reports. > >> > >> If you are getting parameter values to ASP.Net app in query string use > >> this > >> : > >> myParamValue = Request.QueryString["paramName"]; > >> // append it to report URL > >> http://serv/reportserver?/path&myParam=myParamValue > >> > >> If you are getting parameter values to ASP.Net in form submit, use this : > >> myParamValue = Request.Form["paramName"]; > >> // append it to report URL > >> http://serv/reportserver?/path&myParam=myParamValue > >> > >> and about the Other way, passing parameters from reporting services to > >> ASP.Net?? I dont think why we need to do this? do you have any specific > >> requirement? > >> > >> "JiaN" <JiaN@discussions.microsoft.com> wrote in message > >> news:C51CAFD7-665A-4173-81EA-1716F70779A1@microsoft.com... > >> > How do i pass parameters from reporting services to ASP.NET thru URL? > >> > and > >> > how > >> > do i retrieve the parameters values from the URL using ASP.NET? > >> > > >> > And also vice versa. that means how do i pass parameters from ASP.NET > >> > to > >> > reporting services and how do i retrieve the parameters values using > >> > reporting services. > >> > > >> > Thanks in advance for the help. > >> > >> > >> > >
Generally parameters are flown from ASP.Net to reports.
If you are getting parameter values to ASP.Net app in query string use this : myParamValue = Request.QueryString["paramName"]; // append it to report URL http://serv/reportserver?/path&myParam=myParamValue If you are getting parameter values to ASP.Net in form submit, use this : myParamValue = Request.Form["paramName"]; // append it to report URL http://serv/reportserver?/path&myParam=myParamValue and about the Other way, passing parameters from reporting services to ASP.Net?? I dont think why we need to do this? do you have any specific requirement? [quoted text, click to view] "JiaN" <JiaN@discussions.microsoft.com> wrote in message news:C51CAFD7-665A-4173-81EA-1716F70779A1@microsoft.com... > How do i pass parameters from reporting services to ASP.NET thru URL? and > how > do i retrieve the parameters values from the URL using ASP.NET? > > And also vice versa. that means how do i pass parameters from ASP.NET to > reporting services and how do i retrieve the parameters values using > reporting services. > > Thanks in advance for the help.
[quoted text, click to view]
JiaN wrote: > 1. ya ok, i had follow ur instructions and is now able to display the > parameters values in my report.. Thanks alot! > > 2. Now for the second point. I will tell you what i wan to accomplish in > this part. > Ok, so for example now i am viewing a page(done in reporting services) that > got all the suggestions submitted. And in order to view the full information > of the suggestions, i had to click on the Suggestion ID column and it will > invoke into an aspx page where the full information can be displayed. So for > now, i does not know how to display the full information for the aspx page > base on the respective Suggestion ID that had been clicked when at the > reporting services page. > > (Reporting Services Page) > --------------------------------------------------------- > Suggestions ID Suggestion Title > 1 Carpark > 2 Toilet > ... ... > ... ... > --------------------------------------------------------- > So i am now viewing the page done in reporting services, and in order to > view the full information of the suggestions, i had to click on the > Suggestions ID. For example, i click on Suggestion ID "1", user will be > transfer to a aspx page where they can view the complete information of > Suggestion ID "1". > And so what should i do in order to display the correct information for > Suggestion ID "1" in the aspx page when user clicks on the Suggestion ID "1" > from the reporting services page. > > hope you understand my problem so far.. sorry for the trouble and time > spent. thanks > > "avnrao" wrote: > > >>1. you can make the parameters appear in Report textbox by placing >>Parameters!ParameterName.Value in the report text. does this serve your >>purpose? >> >>2. You are trying to invoke an aspx page from a report. so have a link in >>Report which points to your aspx page >>(http://server/aspxapp/my.aspx?parameters) and you have to pass parameters >>in query string only. (tell me if you can use a form to submit..i dont know >>that). >> >>hth >> >>"JiaN" <JiaN@discussions.microsoft.com> wrote in message >>news:9F8D8FC3-6E84-441A-A4CE-CA14BEFB182A@microsoft.com... >> >>>ok.. so the example u given me is for passing parameters from asp.net to >>>reporting services? and how do i display the parameters value that is been >>>passed in the URL to display in my report textbox? >>> >>>for the other way on passing parameters from report services to asp.net.. >>>is >>>because i got a page(done in RS) where user can click on the column call >>>"Suggestion ID" and they will be transfer to a aspx page where i need the >>>suggestion ID to query the database tables to get extra information to >>>display in that aspx page and they are able to evaluate the suggestions >>>from >>>that aspx page by clicking on the Accept, Reject button available on the >>>page. I done this in aspx page because my supervisor wants a real button >>>instead of those "textbox" like button in reporting services. >>> >>>thanks for your help! >>>"avnrao" wrote: >>> >>> >>>>Generally parameters are flown from ASP.Net to reports. >>>> >>>>If you are getting parameter values to ASP.Net app in query string use >>>>this >>>>: >>>>myParamValue = Request.QueryString["paramName"]; >>>>// append it to report URL >>>>http://serv/reportserver?/path&myParam=myParamValue >>>> >>>>If you are getting parameter values to ASP.Net in form submit, use this : >>>>myParamValue = Request.Form["paramName"]; >>>>// append it to report URL >>>>http://serv/reportserver?/path&myParam=myParamValue >>>> >>>>and about the Other way, passing parameters from reporting services to >>>>ASP.Net?? I dont think why we need to do this? do you have any specific >>>>requirement? >>>> >>>>"JiaN" <JiaN@discussions.microsoft.com> wrote in message >>>>news:C51CAFD7-665A-4173-81EA-1716F70779A1@microsoft.com... >>>> >>>>>How do i pass parameters from reporting services to ASP.NET thru URL? >>>>>and >>>>>how >>>>>do i retrieve the parameters values from the URL using ASP.NET? >>>>> >>>>>And also vice versa. that means how do i pass parameters from ASP.NET >>>>>to >>>>>reporting services and how do i retrieve the parameters values using >>>>>reporting services. >>>>> >>>>>Thanks in advance for the help. >>>> >>>> >>>> >> >> I guess you could use the "Navigation" properties in the advanced option tab. Use the "Jump To Url" set value like below: ="http://www.anyurl.com/page.aspx?p=" & Parameters!paramXYZ.Value
[quoted text, click to view]
Jonas Montonen wrote: > JiaN wrote: > >> 1. ya ok, i had follow ur instructions and is now able to display the >> parameters values in my report.. Thanks alot! >> >> 2. Now for the second point. I will tell you what i wan to accomplish >> in this part. >> Ok, so for example now i am viewing a page(done in reporting services) >> that got all the suggestions submitted. And in order to view the full >> information of the suggestions, i had to click on the Suggestion ID >> column and it will invoke into an aspx page where the full information >> can be displayed. So for now, i does not know how to display the full >> information for the aspx page base on the respective Suggestion ID >> that had been clicked when at the reporting services page. >> >> (Reporting Services Page) >> --------------------------------------------------------- >> Suggestions ID Suggestion Title >> 1 Carpark >> 2 Toilet >> ... ... >> ... ... >> --------------------------------------------------------- >> So i am now viewing the page done in reporting services, and in order >> to view the full information of the suggestions, i had to click on the >> Suggestions ID. For example, i click on Suggestion ID "1", user will >> be transfer to a aspx page where they can view the complete >> information of Suggestion ID "1". >> And so what should i do in order to display the correct information >> for Suggestion ID "1" in the aspx page when user clicks on the >> Suggestion ID "1" from the reporting services page. >> >> hope you understand my problem so far.. sorry for the trouble and time >> spent. thanks >> >> "avnrao" wrote: >> >> >>> 1. you can make the parameters appear in Report textbox by placing >>> Parameters!ParameterName.Value in the report text. does this serve >>> your purpose? >>> >>> 2. You are trying to invoke an aspx page from a report. so have a >>> link in Report which points to your aspx page >>> (http://server/aspxapp/my.aspx?parameters) and you have to pass >>> parameters in query string only. (tell me if you can use a form to >>> submit..i dont know that). >>> >>> hth >>> >>> "JiaN" <JiaN@discussions.microsoft.com> wrote in message >>> news:9F8D8FC3-6E84-441A-A4CE-CA14BEFB182A@microsoft.com... >>> >>>> ok.. so the example u given me is for passing parameters from >>>> asp.net to >>>> reporting services? and how do i display the parameters value that >>>> is been >>>> passed in the URL to display in my report textbox? >>>> >>>> for the other way on passing parameters from report services to >>>> asp.net.. is >>>> because i got a page(done in RS) where user can click on the column >>>> call >>>> "Suggestion ID" and they will be transfer to a aspx page where i >>>> need the >>>> suggestion ID to query the database tables to get extra information to >>>> display in that aspx page and they are able to evaluate the >>>> suggestions from >>>> that aspx page by clicking on the Accept, Reject button available on >>>> the >>>> page. I done this in aspx page because my supervisor wants a real >>>> button >>>> instead of those "textbox" like button in reporting services. >>>> >>>> thanks for your help! >>>> "avnrao" wrote: >>>> >>>> >>>>> Generally parameters are flown from ASP.Net to reports. >>>>> >>>>> If you are getting parameter values to ASP.Net app in query string >>>>> use this >>>>> : >>>>> myParamValue = Request.QueryString["paramName"]; >>>>> // append it to report URL >>>>> http://serv/reportserver?/path&myParam=myParamValue >>>>> >>>>> If you are getting parameter values to ASP.Net in form submit, use >>>>> this : >>>>> myParamValue = Request.Form["paramName"]; >>>>> // append it to report URL >>>>> http://serv/reportserver?/path&myParam=myParamValue >>>>> >>>>> and about the Other way, passing parameters from reporting services to >>>>> ASP.Net?? I dont think why we need to do this? do you have any >>>>> specific >>>>> requirement? >>>>> >>>>> "JiaN" <JiaN@discussions.microsoft.com> wrote in message >>>>> news:C51CAFD7-665A-4173-81EA-1716F70779A1@microsoft.com... >>>>> >>>>>> How do i pass parameters from reporting services to ASP.NET thru >>>>>> URL? and >>>>>> how >>>>>> do i retrieve the parameters values from the URL using ASP.NET? >>>>>> >>>>>> And also vice versa. that means how do i pass parameters from >>>>>> ASP.NET to >>>>>> reporting services and how do i retrieve the parameters values using >>>>>> reporting services. >>>>>> >>>>>> Thanks in advance for the help. >>>>> >>>>> >>>>> >>>>> >>> >>> > > I guess you could use the "Navigation" properties in the advanced option > tab. Use the "Jump To Url" set value like below: > ="http://www.anyurl.com/page.aspx?p=" & Parameters!paramXYZ.Value > > // Jonas Montonen Oops, I read your message again. I guess what you want is: ="http://www.anyurl.com/page.aspx?suggId=" & =Fields!SuggestionId.Value
1. you can make the parameters appear in Report textbox by placing
Parameters!ParameterName.Value in the report text. does this serve your purpose? 2. You are trying to invoke an aspx page from a report. so have a link in Report which points to your aspx page (http://server/aspxapp/my.aspx?parameters) and you have to pass parameters in query string only. (tell me if you can use a form to submit..i dont know that). hth [quoted text, click to view] "JiaN" <JiaN@discussions.microsoft.com> wrote in message news:9F8D8FC3-6E84-441A-A4CE-CA14BEFB182A@microsoft.com... > ok.. so the example u given me is for passing parameters from asp.net to > reporting services? and how do i display the parameters value that is been > passed in the URL to display in my report textbox? > > for the other way on passing parameters from report services to asp.net.. > is > because i got a page(done in RS) where user can click on the column call > "Suggestion ID" and they will be transfer to a aspx page where i need the > suggestion ID to query the database tables to get extra information to > display in that aspx page and they are able to evaluate the suggestions > from > that aspx page by clicking on the Accept, Reject button available on the > page. I done this in aspx page because my supervisor wants a real button > instead of those "textbox" like button in reporting services. > > thanks for your help! > "avnrao" wrote: > >> Generally parameters are flown from ASP.Net to reports. >> >> If you are getting parameter values to ASP.Net app in query string use >> this >> : >> myParamValue = Request.QueryString["paramName"]; >> // append it to report URL >> http://serv/reportserver?/path&myParam=myParamValue >> >> If you are getting parameter values to ASP.Net in form submit, use this : >> myParamValue = Request.Form["paramName"]; >> // append it to report URL >> http://serv/reportserver?/path&myParam=myParamValue >> >> and about the Other way, passing parameters from reporting services to >> ASP.Net?? I dont think why we need to do this? do you have any specific >> requirement? >> >> "JiaN" <JiaN@discussions.microsoft.com> wrote in message >> news:C51CAFD7-665A-4173-81EA-1716F70779A1@microsoft.com... >> > How do i pass parameters from reporting services to ASP.NET thru URL? >> > and >> > how >> > do i retrieve the parameters values from the URL using ASP.NET? >> > >> > And also vice versa. that means how do i pass parameters from ASP.NET >> > to >> > reporting services and how do i retrieve the parameters values using >> > reporting services. >> > >> > Thanks in advance for the help. >> >> >>
Thanks Jonas, i can now pass my parameters from RS to aspx. But i not sure
how do i retrieve my SuggestionID value from the URL. i need this value for a select statement. "SELECT Title from Suggestions WHERE SuggestionID=????" - What should i fill in for the ???? part? Thanks alot for your help. [quoted text, click to view] "Jonas Montonen" wrote:
> Jonas Montonen wrote: > > JiaN wrote: > > > >> 1. ya ok, i had follow ur instructions and is now able to display the > >> parameters values in my report.. Thanks alot! > >> > >> 2. Now for the second point. I will tell you what i wan to accomplish > >> in this part. > >> Ok, so for example now i am viewing a page(done in reporting services) > >> that got all the suggestions submitted. And in order to view the full > >> information of the suggestions, i had to click on the Suggestion ID > >> column and it will invoke into an aspx page where the full information > >> can be displayed. So for now, i does not know how to display the full > >> information for the aspx page base on the respective Suggestion ID > >> that had been clicked when at the reporting services page. > >> > >> (Reporting Services Page) > >> --------------------------------------------------------- > >> Suggestions ID Suggestion Title > >> 1 Carpark > >> 2 Toilet > >> ... ... > >> ... ... > >> --------------------------------------------------------- > >> So i am now viewing the page done in reporting services, and in order > >> to view the full information of the suggestions, i had to click on the > >> Suggestions ID. For example, i click on Suggestion ID "1", user will > >> be transfer to a aspx page where they can view the complete > >> information of Suggestion ID "1". > >> And so what should i do in order to display the correct information > >> for Suggestion ID "1" in the aspx page when user clicks on the > >> Suggestion ID "1" from the reporting services page. > >> > >> hope you understand my problem so far.. sorry for the trouble and time > >> spent. thanks > >> > >> "avnrao" wrote: > >> > >> > >>> 1. you can make the parameters appear in Report textbox by placing > >>> Parameters!ParameterName.Value in the report text. does this serve > >>> your purpose? > >>> > >>> 2. You are trying to invoke an aspx page from a report. so have a > >>> link in Report which points to your aspx page > >>> (http://server/aspxapp/my.aspx?parameters) and you have to pass > >>> parameters in query string only. (tell me if you can use a form to > >>> submit..i dont know that). > >>> > >>> hth > >>> > >>> "JiaN" <JiaN@discussions.microsoft.com> wrote in message > >>> news:9F8D8FC3-6E84-441A-A4CE-CA14BEFB182A@microsoft.com... > >>> > >>>> ok.. so the example u given me is for passing parameters from > >>>> asp.net to > >>>> reporting services? and how do i display the parameters value that > >>>> is been > >>>> passed in the URL to display in my report textbox? > >>>> > >>>> for the other way on passing parameters from report services to > >>>> asp.net.. is > >>>> because i got a page(done in RS) where user can click on the column > >>>> call > >>>> "Suggestion ID" and they will be transfer to a aspx page where i > >>>> need the > >>>> suggestion ID to query the database tables to get extra information to > >>>> display in that aspx page and they are able to evaluate the > >>>> suggestions from > >>>> that aspx page by clicking on the Accept, Reject button available on > >>>> the > >>>> page. I done this in aspx page because my supervisor wants a real > >>>> button > >>>> instead of those "textbox" like button in reporting services. > >>>> > >>>> thanks for your help! > >>>> "avnrao" wrote: > >>>> > >>>> > >>>>> Generally parameters are flown from ASP.Net to reports. > >>>>> > >>>>> If you are getting parameter values to ASP.Net app in query string > >>>>> use this > >>>>> : > >>>>> myParamValue = Request.QueryString["paramName"]; > >>>>> // append it to report URL > >>>>> http://serv/reportserver?/path&myParam=myParamValue > >>>>> > >>>>> If you are getting parameter values to ASP.Net in form submit, use > >>>>> this : > >>>>> myParamValue = Request.Form["paramName"]; > >>>>> // append it to report URL > >>>>> http://serv/reportserver?/path&myParam=myParamValue > >>>>> > >>>>> and about the Other way, passing parameters from reporting services to > >>>>> ASP.Net?? I dont think why we need to do this? do you have any > >>>>> specific > >>>>> requirement? > >>>>> > >>>>> "JiaN" <JiaN@discussions.microsoft.com> wrote in message > >>>>> news:C51CAFD7-665A-4173-81EA-1716F70779A1@microsoft.com... > >>>>> > >>>>>> How do i pass parameters from reporting services to ASP.NET thru > >>>>>> URL? and > >>>>>> how > >>>>>> do i retrieve the parameters values from the URL using ASP.NET? > >>>>>> > >>>>>> And also vice versa. that means how do i pass parameters from > >>>>>> ASP.NET to > >>>>>> reporting services and how do i retrieve the parameters values using > >>>>>> reporting services. > >>>>>> > >>>>>> Thanks in advance for the help. > >>>>> > >>>>> > >>>>> > >>>>> > >>> > >>> > > > > I guess you could use the "Navigation" properties in the advanced option > > tab. Use the "Jump To Url" set value like below: > > ="http://www.anyurl.com/page.aspx?p=" & Parameters!paramXYZ.Value > > > > // Jonas Montonen > > > Oops, I read your message again. > I guess what you want is: > ="http://www.anyurl.com/page.aspx?suggId=" & =Fields!SuggestionId.Value > > // JoNtE
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |