all groups > sql server reporting services > february 2006 >
I need to create a report with some parameters for filtering data. This report must be called by URL link on an Html page. This link must contains the values of these parameters; I don' want specify the values when I see the report by clicking on View report button. Is it possible? How? What is the format of link for passing parameters to filter data?
1. Try leaving the parameter Prompt blank... This should prevent the parameter from displaying, (but you must provide a default value...) 2. Search for URL Access in Books on line and you will get an entire list of all of the things you can do via URL in reporting services. Hope this helps.. -- Wayne Snyder MCDBA, SQL Server MVP Mariner, Charlotte, NC I support the Professional Association for SQL Server ( PASS) and it''s community of SQL Professionals. [quoted text, click to view] "Pasquale" wrote: > I need to create a report with some parameters for filtering data. > This report must be called by URL link on an Html page. > This link must contains the values of these parameters; I don' want > specify the values when I see the report by clicking on View report button. > Is it possible? How? > What is the format of link for passing parameters to filter data? >
I tried passing parameters in URL address successfully, but I see some parameters that the user hasn't change! Moreover, if I change the parameter property "User request" by setting to false value, the call of report dumps! The issue is partially solved! I need to pass a parameter by Url and these parameters cannot change by a user. Can I solve this problem URGENTLY? Many thanks [quoted text, click to view] "Wayne Snyder" wrote: > 1. Try leaving the parameter Prompt blank... This should prevent the > parameter from displaying, (but you must provide a default value...) > > 2. Search for URL Access in Books on line and you will get an entire list > of all of the things you can do via URL in reporting services. > > Hope this helps.. > -- > Wayne Snyder MCDBA, SQL Server MVP > Mariner, Charlotte, NC > > I support the Professional Association for SQL Server ( PASS) and it''s > community of SQL Professionals. > > > "Pasquale" wrote: > > > I need to create a report with some parameters for filtering data. > > This report must be called by URL link on an Html page. > > This link must contains the values of these parameters; I don' want > > specify the values when I see the report by clicking on View report button. > > Is it possible? How? > > What is the format of link for passing parameters to filter data? > >
I have executed several tries modifying the parameter settings. I have followed your suggests, but the solution isn't complete: or I see the parameter or I cannot modify the parameter that I pass via URL (an error occurs!!!)! Many thanks [quoted text, click to view] "Bruce L-C [MVP]" wrote: > Read the rest of Wayne's post. He is telling you how to hide a parameter so > the user doesn't see it. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Pasquale" <Pasquale@discussions.microsoft.com> wrote in message > news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@microsoft.com... > >I tried passing parameters in URL address successfully, > > but I see some parameters that the user hasn't change! > > Moreover, if I change the parameter property "User request" > > by setting to false value, the call of report dumps! > > > > The issue is partially solved! I need to pass a parameter by Url > > and these parameters cannot change by a user. > > > > Can I solve this problem URGENTLY? > > > > Many thanks > > > > > > "Wayne Snyder" wrote: > > > >> 1. Try leaving the parameter Prompt blank... This should prevent the > >> parameter from displaying, (but you must provide a default value...) > >> > >> 2. Search for URL Access in Books on line and you will get an entire > >> list > >> of all of the things you can do via URL in reporting services. > >> > >> Hope this helps.. > >> -- > >> Wayne Snyder MCDBA, SQL Server MVP > >> Mariner, Charlotte, NC > >> > >> I support the Professional Association for SQL Server ( PASS) and it''s > >> community of SQL Professionals. > >> > >> > >> "Pasquale" wrote: > >> > >> > I need to create a report with some parameters for filtering data. > >> > This report must be called by URL link on an Html page. > >> > This link must contains the values of these parameters; I don' want > >> > specify the values when I see the report by clicking on View report > >> > button. > >> > Is it possible? How? > >> > What is the format of link for passing parameters to filter data? > >> > > >> > Many thanks > >
Read the rest of Wayne's post. He is telling you how to hide a parameter so the user doesn't see it. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Pasquale" <Pasquale@discussions.microsoft.com> wrote in message news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@microsoft.com... >I tried passing parameters in URL address successfully, > but I see some parameters that the user hasn't change! > Moreover, if I change the parameter property "User request" > by setting to false value, the call of report dumps! > > The issue is partially solved! I need to pass a parameter by Url > and these parameters cannot change by a user. > > Can I solve this problem URGENTLY? > > Many thanks > > > "Wayne Snyder" wrote: > >> 1. Try leaving the parameter Prompt blank... This should prevent the >> parameter from displaying, (but you must provide a default value...) >> >> 2. Search for URL Access in Books on line and you will get an entire >> list >> of all of the things you can do via URL in reporting services. >> >> Hope this helps.. >> -- >> Wayne Snyder MCDBA, SQL Server MVP >> Mariner, Charlotte, NC >> >> I support the Professional Association for SQL Server ( PASS) and it''s >> community of SQL Professionals. >> >> >> "Pasquale" wrote: >> >> > I need to create a report with some parameters for filtering data. >> > This report must be called by URL link on an Html page. >> > This link must contains the values of these parameters; I don' want >> > specify the values when I see the report by clicking on View report >> > button. >> > Is it possible? How? >> > What is the format of link for passing parameters to filter data? >> > >> > Many thanks
Two different things. First is getting the parameters to work. Then making them hidden. Do you have them working properly so you know your URL is correct. Be sure that your parameter is with the correct case since RS is case sensitive with parameters. Once you know your URL is correct because your report works properly then you can deal with hidding the parameters. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Pasquale" <Pasquale@discussions.microsoft.com> wrote in message news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@microsoft.com... >I have executed several tries modifying the parameter settings. > I have followed your suggests, but the solution isn't complete: > or I see the parameter or I cannot modify the parameter > that I pass via URL (an error occurs!!!)! > > Many thanks > > > "Bruce L-C [MVP]" wrote: > >> Read the rest of Wayne's post. He is telling you how to hide a parameter >> so >> the user doesn't see it. >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "Pasquale" <Pasquale@discussions.microsoft.com> wrote in message >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@microsoft.com... >> >I tried passing parameters in URL address successfully, >> > but I see some parameters that the user hasn't change! >> > Moreover, if I change the parameter property "User request" >> > by setting to false value, the call of report dumps! >> > >> > The issue is partially solved! I need to pass a parameter by Url >> > and these parameters cannot change by a user. >> > >> > Can I solve this problem URGENTLY? >> > >> > Many thanks >> > >> > >> > "Wayne Snyder" wrote: >> > >> >> 1. Try leaving the parameter Prompt blank... This should prevent the >> >> parameter from displaying, (but you must provide a default value...) >> >> >> >> 2. Search for URL Access in Books on line and you will get an entire >> >> list >> >> of all of the things you can do via URL in reporting services. >> >> >> >> Hope this helps.. >> >> -- >> >> Wayne Snyder MCDBA, SQL Server MVP >> >> Mariner, Charlotte, NC >> >> >> >> I support the Professional Association for SQL Server ( PASS) and >> >> it''s >> >> community of SQL Professionals. >> >> >> >> >> >> "Pasquale" wrote: >> >> >> >> > I need to create a report with some parameters for filtering data. >> >> > This report must be called by URL link on an Html page. >> >> > This link must contains the values of these parameters; I don' want >> >> > specify the values when I see the report by clicking on View report >> >> > button. >> >> > Is it possible? How? >> >> > What is the format of link for passing parameters to filter data? >> >> > >> >> > Many thanks >> >> >>
My issue has two aspects: 1. passing a parameter via URL to call my report filtering data by the parameter; 2. hide or protect parameter inside report manager to avoid any user's changes. The first step is solved. The report is called correctly and I see the correct value of parameter (the same written in the URL). I have written correctly the name of parameter. Now, when I set user request for the parameter, inside report manager, to false in order to hide the parameter, this message error occurs: "sReadOnlyReportParameter" and I cannot the value of parameter by the value in the URL. This strange behaviour represents a limit of RS! Moreover, I have specified a default value of parameter with a particular value. Now, is it really possible to solve completely this issue? Do I have a particular SP (SP1, SP2, ...)? Many thanks [quoted text, click to view] "Bruce L-C [MVP]" wrote: > Two different things. First is getting the parameters to work. Then making > them hidden. Do you have them working properly so you know your URL is > correct. Be sure that your parameter is with the correct case since RS is > case sensitive with parameters. Once you know your URL is correct because > your report works properly then you can deal with hidding the parameters. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > "Pasquale" <Pasquale@discussions.microsoft.com> wrote in message > news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@microsoft.com... > >I have executed several tries modifying the parameter settings. > > I have followed your suggests, but the solution isn't complete: > > or I see the parameter or I cannot modify the parameter > > that I pass via URL (an error occurs!!!)! > > > > Many thanks > > > > > > "Bruce L-C [MVP]" wrote: > > > >> Read the rest of Wayne's post. He is telling you how to hide a parameter > >> so > >> the user doesn't see it. > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Pasquale" <Pasquale@discussions.microsoft.com> wrote in message > >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@microsoft.com... > >> >I tried passing parameters in URL address successfully, > >> > but I see some parameters that the user hasn't change! > >> > Moreover, if I change the parameter property "User request" > >> > by setting to false value, the call of report dumps! > >> > > >> > The issue is partially solved! I need to pass a parameter by Url > >> > and these parameters cannot change by a user. > >> > > >> > Can I solve this problem URGENTLY? > >> > > >> > Many thanks > >> > > >> > > >> > "Wayne Snyder" wrote: > >> > > >> >> 1. Try leaving the parameter Prompt blank... This should prevent the > >> >> parameter from displaying, (but you must provide a default value...) > >> >> > >> >> 2. Search for URL Access in Books on line and you will get an entire > >> >> list > >> >> of all of the things you can do via URL in reporting services. > >> >> > >> >> Hope this helps.. > >> >> -- > >> >> Wayne Snyder MCDBA, SQL Server MVP > >> >> Mariner, Charlotte, NC > >> >> > >> >> I support the Professional Association for SQL Server ( PASS) and > >> >> it''s > >> >> community of SQL Professionals. > >> >> > >> >> > >> >> "Pasquale" wrote: > >> >> > >> >> > I need to create a report with some parameters for filtering data. > >> >> > This report must be called by URL link on an Html page. > >> >> > This link must contains the values of these parameters; I don' want > >> >> > specify the values when I see the report by clicking on View report > >> >> > button. > >> >> > Is it possible? How? > >> >> > What is the format of link for passing parameters to filter data? > >> >> > > >> >> > Many thanks > >> > >> > >> > >
I have controlled all settings of the report; then I try to set to blank the user request string inside report manager (maintaning a default value for the parameter): so, I can modify the parameter by passing it via URL and simultaneously hide it in order to avoid any user's changes. Finally, the issue is solved!!! Many thanks [quoted text, click to view] "Bruce L-C [MVP]" wrote: > Two different things. First is getting the parameters to work. Then making > them hidden. Do you have them working properly so you know your URL is > correct. Be sure that your parameter is with the correct case since RS is > case sensitive with parameters. Once you know your URL is correct because > your report works properly then you can deal with hidding the parameters. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > "Pasquale" <Pasquale@discussions.microsoft.com> wrote in message > news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@microsoft.com... > >I have executed several tries modifying the parameter settings. > > I have followed your suggests, but the solution isn't complete: > > or I see the parameter or I cannot modify the parameter > > that I pass via URL (an error occurs!!!)! > > > > Many thanks > > > > > > "Bruce L-C [MVP]" wrote: > > > >> Read the rest of Wayne's post. He is telling you how to hide a parameter > >> so > >> the user doesn't see it. > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "Pasquale" <Pasquale@discussions.microsoft.com> wrote in message > >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@microsoft.com... > >> >I tried passing parameters in URL address successfully, > >> > but I see some parameters that the user hasn't change! > >> > Moreover, if I change the parameter property "User request" > >> > by setting to false value, the call of report dumps! > >> > > >> > The issue is partially solved! I need to pass a parameter by Url > >> > and these parameters cannot change by a user. > >> > > >> > Can I solve this problem URGENTLY? > >> > > >> > Many thanks > >> > > >> > > >> > "Wayne Snyder" wrote: > >> > > >> >> 1. Try leaving the parameter Prompt blank... This should prevent the > >> >> parameter from displaying, (but you must provide a default value...) > >> >> > >> >> 2. Search for URL Access in Books on line and you will get an entire > >> >> list > >> >> of all of the things you can do via URL in reporting services. > >> >> > >> >> Hope this helps.. > >> >> -- > >> >> Wayne Snyder MCDBA, SQL Server MVP > >> >> Mariner, Charlotte, NC > >> >> > >> >> I support the Professional Association for SQL Server ( PASS) and > >> >> it''s > >> >> community of SQL Professionals. > >> >> > >> >> > >> >> "Pasquale" wrote: > >> >> > >> >> > I need to create a report with some parameters for filtering data. > >> >> > This report must be called by URL link on an Html page. > >> >> > This link must contains the values of these parameters; I don' want > >> >> > specify the values when I see the report by clicking on View report > >> >> > button. > >> >> > Is it possible? How? > >> >> > What is the format of link for passing parameters to filter data? > >> >> > > >> >> > Many thanks > >> > >> > >> > >
Making parameters hidden is much more straight forward in RS 2005. I don't hide parameters so I have not had that issue. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Pasquale" <Pasquale@discussions.microsoft.com> wrote in message news:8DE20C29-CBB1-4020-93BD-6D8C71361AD2@microsoft.com... >I have controlled all settings of the report; then I try to set to blank > the user request string inside report manager (maintaning a default > value for the parameter): so, I can modify the parameter by passing it > via URL and simultaneously hide it in order to avoid any user's changes. > Finally, the issue is solved!!! > > Many thanks > > > > "Bruce L-C [MVP]" wrote: > >> Two different things. First is getting the parameters to work. Then >> making >> them hidden. Do you have them working properly so you know your URL is >> correct. Be sure that your parameter is with the correct case since RS is >> case sensitive with parameters. Once you know your URL is correct because >> your report works properly then you can deal with hidding the parameters. >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> >> "Pasquale" <Pasquale@discussions.microsoft.com> wrote in message >> news:E50B32E5-DCC3-448C-A679-75233BBA3F8D@microsoft.com... >> >I have executed several tries modifying the parameter settings. >> > I have followed your suggests, but the solution isn't complete: >> > or I see the parameter or I cannot modify the parameter >> > that I pass via URL (an error occurs!!!)! >> > >> > Many thanks >> > >> > >> > "Bruce L-C [MVP]" wrote: >> > >> >> Read the rest of Wayne's post. He is telling you how to hide a >> >> parameter >> >> so >> >> the user doesn't see it. >> >> >> >> >> >> -- >> >> Bruce Loehle-Conger >> >> MVP SQL Server Reporting Services >> >> >> >> "Pasquale" <Pasquale@discussions.microsoft.com> wrote in message >> >> news:471AB25B-E6A6-4E1A-9756-CA42FB10DB66@microsoft.com... >> >> >I tried passing parameters in URL address successfully, >> >> > but I see some parameters that the user hasn't change! >> >> > Moreover, if I change the parameter property "User request" >> >> > by setting to false value, the call of report dumps! >> >> > >> >> > The issue is partially solved! I need to pass a parameter by Url >> >> > and these parameters cannot change by a user. >> >> > >> >> > Can I solve this problem URGENTLY? >> >> > >> >> > Many thanks >> >> > >> >> > >> >> > "Wayne Snyder" wrote: >> >> > >> >> >> 1. Try leaving the parameter Prompt blank... This should prevent >> >> >> the >> >> >> parameter from displaying, (but you must provide a default >> >> >> value...) >> >> >> >> >> >> 2. Search for URL Access in Books on line and you will get an >> >> >> entire >> >> >> list >> >> >> of all of the things you can do via URL in reporting services. >> >> >> >> >> >> Hope this helps.. >> >> >> -- >> >> >> Wayne Snyder MCDBA, SQL Server MVP >> >> >> Mariner, Charlotte, NC >> >> >> >> >> >> I support the Professional Association for SQL Server ( PASS) and >> >> >> it''s >> >> >> community of SQL Professionals. >> >> >> >> >> >> >> >> >> "Pasquale" wrote: >> >> >> >> >> >> > I need to create a report with some parameters for filtering >> >> >> > data. >> >> >> > This report must be called by URL link on an Html page. >> >> >> > This link must contains the values of these parameters; I don' >> >> >> > want >> >> >> > specify the values when I see the report by clicking on View >> >> >> > report >> >> >> > button. >> >> >> > Is it possible? How? >> >> >> > What is the format of link for passing parameters to filter data? >> >> >> > >> >> >> > Many thanks >> >> >> >> >> >> >> >> >>
Don't see what you're looking for? Try a search.
|
|
|