| Groups | Blog | Home |
sql server reporting services : Report Parameters
a default value and a prompt of 'Enter a Starting Date'. When I preview it in the report writer or run it from the Report Manager after deployment, the report runs using the default value, displays the correct data, and the prompt is displayed with the default value in the input box. All is well and I am a happy guy. I have second report with a textbox that navigates to the first report using the 'Jump to Report' method. When jumping from the second report to the first from the DESIGNER, the report runs using the default value, displays the correct data, and the prompt is displayed with the default value in the input box. Again, all is well. When doing the same from the Report Manager I get the same results EXCEPT the prompt is NOT displayed at all. How can I make the prompt allways show when jumping from one report to another ? I notice that when you hover over the textbox/link that the URL to the target report is diplayed in the status bar of the browser with the value rs:Parameters=False there. What needs to be done to make it "True" Thanks in Advance Pete
Thanks for your response.
I don't see how that will ensure that the parameters will be displayed with their prompt on the target report. I understand that you are manually building the URL to the target. Are you doing that in the 'Jump to Report' drop-down of the Navigation tab in the textbox's properties ? Pete [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> You need to use Jump to URL: > > The below example specifies the directory starting from the root. I have > this because this particular report can reside in a different directory than > the report I am jumping to. If it is in the same directory you can just not > worry about specifying the directory. A couple of others things to note, I > use the globals variable so this will work regardless of where I deploy it. > Also, note that parameter values are case sensitive so you must match it > exactly or you will end up without values in your parameter fields. Also > note that you can add to this URL a command to tell it to hide the parameter > toolbar. Anyway, this should get you started. > =Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" & > Fields!manifstdocno.Value & "&WasteIDNum=" & Fields!wasteidnum.Value > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "PeteMitchell" <PeteMitchell@discussions.microsoft.com> wrote in message > news:99C82369-630F-434E-A882-2D0D23A156A4@microsoft.com... > >I have a report that takes one parameter called StartDate and I have given > >it > > a default value and a prompt of 'Enter a Starting Date'. When I preview it > > in > > the report writer or run it from the Report Manager after deployment, the > > report runs using the default value, displays the correct data, and the > > prompt is displayed with the default value in the input box. All is well > > and > > I am a happy guy. > > > > I have second report with a textbox that navigates to the first report > > using > > the 'Jump to Report' method. > > > > When jumping from the second report to the first from the DESIGNER, the > > report runs using the default value, displays the correct data, and the > > prompt is displayed with the default value in the input box. Again, all is > > well. > > > > When doing the same from the Report Manager I get the same results EXCEPT > > the prompt is NOT displayed at all. How can I make the prompt allways show > > when jumping from one report to another ? > > > > I notice that when you hover over the textbox/link that the URL to the > > target report is diplayed in the status bar of the browser with the value > > rs:Parameters=False there. What needs to be done to make it "True" > > > > Thanks in Advance > > Pete > > > >
You need to use Jump to URL:
The below example specifies the directory starting from the root. I have this because this particular report can reside in a different directory than the report I am jumping to. If it is in the same directory you can just not worry about specifying the directory. A couple of others things to note, I use the globals variable so this will work regardless of where I deploy it. Also, note that parameter values are case sensitive so you must match it exactly or you will end up without values in your parameter fields. Also note that you can add to this URL a command to tell it to hide the parameter toolbar. Anyway, this should get you started. =Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" & Fields!manifstdocno.Value & "&WasteIDNum=" & Fields!wasteidnum.Value -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "PeteMitchell" <PeteMitchell@discussions.microsoft.com> wrote in message news:99C82369-630F-434E-A882-2D0D23A156A4@microsoft.com... >I have a report that takes one parameter called StartDate and I have given >it > a default value and a prompt of 'Enter a Starting Date'. When I preview it > in > the report writer or run it from the Report Manager after deployment, the > report runs using the default value, displays the correct data, and the > prompt is displayed with the default value in the input box. All is well > and > I am a happy guy. > > I have second report with a textbox that navigates to the first report > using > the 'Jump to Report' method. > > When jumping from the second report to the first from the DESIGNER, the > report runs using the default value, displays the correct data, and the > prompt is displayed with the default value in the input box. Again, all is > well. > > When doing the same from the Report Manager I get the same results EXCEPT > the prompt is NOT displayed at all. How can I make the prompt allways show > when jumping from one report to another ? > > I notice that when you hover over the textbox/link that the URL to the > target report is diplayed in the status bar of the browser with the value > rs:Parameters=False there. What needs to be done to make it "True" > > Thanks in Advance > Pete >
I guess I should brush up on my reading skills ! Haha (You did say Jump to
URL and not Jump to Report.) :) That works like a charm. Thanks very much. You're right about URL being more flexible. I've copied your samples into my evil book or reporting trickery. Pete [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> No, in the Jump to URL (look below the Jump to Report). You can jump to any > URL but that URL can be a report which is how I use it. You have much more > control with the Jump to URL. You can show or not show the toolbar, you can > choose to render in a different format (like PDF or CSV). You can cause > another window to open up. For instance this one opens up a report in CSV > ASCII format (from report manager you get Unicode format which Excel doesn't > handle well). > > Here is an example of a Jump to URL link I use. This causes Excel to come up > with the data in a separate window: > > ="javascript:void(window.open('" & Globals!ReportServerUrl & > "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value & > "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))" > > If you don't want to have it appear in a new window then do this in jump to > URL: > > =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" & > Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII" > > To open up in a new window you must have SP1 or SP2 installed. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > > > "PeteMitchell" <PeteMitchell@discussions.microsoft.com> wrote in message > news:DA7C3AC8-B470-435F-A497-962ACB0AE880@microsoft.com... > > Thanks for your response. > > I don't see how that will ensure that the parameters will be displayed > > with > > their prompt on the target report. > > > > I understand that you are manually building the URL to the target. Are you > > doing that in the 'Jump to Report' drop-down of the Navigation tab in the > > textbox's properties ? > > > > Pete > > > > "Bruce L-C [MVP]" wrote: > > > >> You need to use Jump to URL: > >> > >> The below example specifies the directory starting from the root. I have > >> this because this particular report can reside in a different directory > >> than > >> the report I am jumping to. If it is in the same directory you can just > >> not > >> worry about specifying the directory. A couple of others things to note, > >> I > >> use the globals variable so this will work regardless of where I deploy > >> it. > >> Also, note that parameter values are case sensitive so you must match it > >> exactly or you will end up without values in your parameter fields. Also > >> note that you can add to this URL a command to tell it to hide the > >> parameter > >> toolbar. Anyway, this should get you started. > >> =Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" & > >> Fields!manifstdocno.Value & "&WasteIDNum=" & Fields!wasteidnum.Value > >> > >> > >> -- > >> Bruce Loehle-Conger > >> MVP SQL Server Reporting Services > >> > >> "PeteMitchell" <PeteMitchell@discussions.microsoft.com> wrote in message > >> news:99C82369-630F-434E-A882-2D0D23A156A4@microsoft.com... > >> >I have a report that takes one parameter called StartDate and I have > >> >given > >> >it > >> > a default value and a prompt of 'Enter a Starting Date'. When I preview > >> > it > >> > in > >> > the report writer or run it from the Report Manager after deployment, > >> > the > >> > report runs using the default value, displays the correct data, and the > >> > prompt is displayed with the default value in the input box. All is > >> > well > >> > and > >> > I am a happy guy. > >> > > >> > I have second report with a textbox that navigates to the first report > >> > using > >> > the 'Jump to Report' method. > >> > > >> > When jumping from the second report to the first from the DESIGNER, the > >> > report runs using the default value, displays the correct data, and the > >> > prompt is displayed with the default value in the input box. Again, all > >> > is > >> > well. > >> > > >> > When doing the same from the Report Manager I get the same results > >> > EXCEPT > >> > the prompt is NOT displayed at all. How can I make the prompt allways > >> > show > >> > when jumping from one report to another ? > >> > > >> > I notice that when you hover over the textbox/link that the URL to the > >> > target report is diplayed in the status bar of the browser with the > >> > value > >> > rs:Parameters=False there. What needs to be done to make it "True" > >> > > >> > Thanks in Advance > >> > Pete > >> > > >> > >> > >> > >
No, in the Jump to URL (look below the Jump to Report). You can jump to any
URL but that URL can be a report which is how I use it. You have much more control with the Jump to URL. You can show or not show the toolbar, you can choose to render in a different format (like PDF or CSV). You can cause another window to open up. For instance this one opens up a report in CSV ASCII format (from report manager you get Unicode format which Excel doesn't handle well). Here is an example of a Jump to URL link I use. This causes Excel to come up with the data in a separate window: ="javascript:void(window.open('" & Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))" If you don't want to have it appear in a new window then do this in jump to URL: =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII" To open up in a new window you must have SP1 or SP2 installed. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "PeteMitchell" <PeteMitchell@discussions.microsoft.com> wrote in message news:DA7C3AC8-B470-435F-A497-962ACB0AE880@microsoft.com... > Thanks for your response. > I don't see how that will ensure that the parameters will be displayed > with > their prompt on the target report. > > I understand that you are manually building the URL to the target. Are you > doing that in the 'Jump to Report' drop-down of the Navigation tab in the > textbox's properties ? > > Pete > > "Bruce L-C [MVP]" wrote: > >> You need to use Jump to URL: >> >> The below example specifies the directory starting from the root. I have >> this because this particular report can reside in a different directory >> than >> the report I am jumping to. If it is in the same directory you can just >> not >> worry about specifying the directory. A couple of others things to note, >> I >> use the globals variable so this will work regardless of where I deploy >> it. >> Also, note that parameter values are case sensitive so you must match it >> exactly or you will end up without values in your parameter fields. Also >> note that you can add to this URL a command to tell it to hide the >> parameter >> toolbar. Anyway, this should get you started. >> =Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" & >> Fields!manifstdocno.Value & "&WasteIDNum=" & Fields!wasteidnum.Value >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "PeteMitchell" <PeteMitchell@discussions.microsoft.com> wrote in message >> news:99C82369-630F-434E-A882-2D0D23A156A4@microsoft.com... >> >I have a report that takes one parameter called StartDate and I have >> >given >> >it >> > a default value and a prompt of 'Enter a Starting Date'. When I preview >> > it >> > in >> > the report writer or run it from the Report Manager after deployment, >> > the >> > report runs using the default value, displays the correct data, and the >> > prompt is displayed with the default value in the input box. All is >> > well >> > and >> > I am a happy guy. >> > >> > I have second report with a textbox that navigates to the first report >> > using >> > the 'Jump to Report' method. >> > >> > When jumping from the second report to the first from the DESIGNER, the >> > report runs using the default value, displays the correct data, and the >> > prompt is displayed with the default value in the input box. Again, all >> > is >> > well. >> > >> > When doing the same from the Report Manager I get the same results >> > EXCEPT >> > the prompt is NOT displayed at all. How can I make the prompt allways >> > show >> > when jumping from one report to another ? >> > >> > I notice that when you hover over the textbox/link that the URL to the >> > target report is diplayed in the status bar of the browser with the >> > value >> > rs:Parameters=False there. What needs to be done to make it "True" >> > >> > Thanks in Advance >> > Pete >> > >> >> >>
I set a link up using your advice. my link looks like this:
=Globals!ReportServerUrl & "?/sales reports/customer sales" &"& customer1="& Fields!customer.Value & "& date1=" & Parameters!date1.Value & "& date2=" & Parameters!date2.Value When I use the report, I get a specified server url does not link to the report server for this report or is not in the correct format. It looks like the & symbols are not being displayed in the url so that if I look at my browser address bar after following the link I see something like: Sales%2520Reports%2fCustomer%2520Salescustomer1%3dVALENTINE%2520ENTERPRISES%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520date1%3d20050901date2%3d20050930%26 The parameters look like they follow immediately after the report name with no ampersand between them. Thanks in advance for you assistance. [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:eSthLfWtFHA.616@TK2MSFTNGP11.phx.gbl... > You need to use Jump to URL: > > The below example specifies the directory starting from the root. I have > this because this particular report can reside in a different directory > than the report I am jumping to. If it is in the same directory you can > just not worry about specifying the directory. A couple of others things > to note, I use the globals variable so this will work regardless of where > I deploy it. Also, note that parameter values are case sensitive so you > must match it exactly or you will end up without values in your parameter > fields. Also note that you can add to this URL a command to tell it to > hide the parameter toolbar. Anyway, this should get you started. > =Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" & > Fields!manifstdocno.Value & "&WasteIDNum=" & Fields!wasteidnum.Value > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "PeteMitchell" <PeteMitchell@discussions.microsoft.com> wrote in message > news:99C82369-630F-434E-A882-2D0D23A156A4@microsoft.com... >>I have a report that takes one parameter called StartDate and I have given >>it >> a default value and a prompt of 'Enter a Starting Date'. When I preview >> it in >> the report writer or run it from the Report Manager after deployment, the >> report runs using the default value, displays the correct data, and the >> prompt is displayed with the default value in the input box. All is well >> and >> I am a happy guy. >> >> I have second report with a textbox that navigates to the first report >> using >> the 'Jump to Report' method. >> >> When jumping from the second report to the first from the DESIGNER, the >> report runs using the default value, displays the correct data, and the >> prompt is displayed with the default value in the input box. Again, all >> is >> well. >> >> When doing the same from the Report Manager I get the same results EXCEPT >> the prompt is NOT displayed at all. How can I make the prompt allways >> show >> when jumping from one report to another ? >> >> I notice that when you hover over the textbox/link that the URL to the >> target report is diplayed in the status bar of the browser with the value >> rs:Parameters=False there. What needs to be done to make it "True" >> >> Thanks in Advance >> Pete >> > >
Try taking the space out between the ampersand and the parameter. Change
"& customer1=" to "&customer1=" I don't know if that will make a difference but I don't have the space in there that you do. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Fredrick A. Zilz" <fzilz@NOSPAM.interhealthusa.com> wrote in message news:uEafkkYtFHA.3000@TK2MSFTNGP12.phx.gbl... >I set a link up using your advice. my link looks like this: > =Globals!ReportServerUrl & "?/sales reports/customer sales" &"& > customer1="& Fields!customer.Value & "& date1=" & Parameters!date1.Value & > "& date2=" & Parameters!date2.Value > > When I use the report, I get a specified server url does not link to the > report server for this report or is not in the correct format. It looks > like the & symbols are not being displayed in the url so that if I look at > my browser address bar after following the link I see something like: > Sales%2520Reports%2fCustomer%2520Salescustomer1%3dVALENTINE%2520ENTERPRISES%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520date1%3d20050901date2%3d20050930%26 > > The parameters look like they follow immediately after the report name > with no ampersand between them. > > Thanks in advance for you assistance. > > > "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message > news:eSthLfWtFHA.616@TK2MSFTNGP11.phx.gbl... >> You need to use Jump to URL: >> >> The below example specifies the directory starting from the root. I have >> this because this particular report can reside in a different directory >> than the report I am jumping to. If it is in the same directory you can >> just not worry about specifying the directory. A couple of others things >> to note, I use the globals variable so this will work regardless of where >> I deploy it. Also, note that parameter values are case sensitive so you >> must match it exactly or you will end up without values in your parameter >> fields. Also note that you can add to this URL a command to tell it to >> hide the parameter toolbar. Anyway, this should get you started. >> =Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" & >> Fields!manifstdocno.Value & "&WasteIDNum=" & Fields!wasteidnum.Value >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "PeteMitchell" <PeteMitchell@discussions.microsoft.com> wrote in message >> news:99C82369-630F-434E-A882-2D0D23A156A4@microsoft.com... >>>I have a report that takes one parameter called StartDate and I have >>>given it >>> a default value and a prompt of 'Enter a Starting Date'. When I preview >>> it in >>> the report writer or run it from the Report Manager after deployment, >>> the >>> report runs using the default value, displays the correct data, and the >>> prompt is displayed with the default value in the input box. All is well >>> and >>> I am a happy guy. >>> >>> I have second report with a textbox that navigates to the first report >>> using >>> the 'Jump to Report' method. >>> >>> When jumping from the second report to the first from the DESIGNER, the >>> report runs using the default value, displays the correct data, and the >>> prompt is displayed with the default value in the input box. Again, all >>> is >>> well. >>> >>> When doing the same from the Report Manager I get the same results >>> EXCEPT >>> the prompt is NOT displayed at all. How can I make the prompt allways >>> show >>> when jumping from one report to another ? >>> >>> I notice that when you hover over the textbox/link that the URL to the >>> target report is diplayed in the status bar of the browser with the >>> value >>> rs:Parameters=False there. What needs to be done to make it "True" >>> >>> Thanks in Advance >>> Pete >>> >> >> > >
I found that this format works for me:
=Globals!ReportServerUrl + "?/Sales Reports/Customer Sales" + "&customer1=" + Fields!customer.Value + "&date1=" + Parameters!date1.Value + "&date2=" + Parameters!date2.Value Thank you for your assistance. [quoted text, click to view] "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message news:%23bp$2EctFHA.3452@TK2MSFTNGP14.phx.gbl... > Try taking the space out between the ampersand and the parameter. Change > "& customer1=" to "&customer1=" > > I don't know if that will make a difference but I don't have the space in > there that you do. > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "Fredrick A. Zilz" <fzilz@NOSPAM.interhealthusa.com> wrote in message > news:uEafkkYtFHA.3000@TK2MSFTNGP12.phx.gbl... >>I set a link up using your advice. my link looks like this: >> =Globals!ReportServerUrl & "?/sales reports/customer sales" &"& >> customer1="& Fields!customer.Value & "& date1=" & Parameters!date1.Value >> & "& date2=" & Parameters!date2.Value >> >> When I use the report, I get a specified server url does not link to the >> report server for this report or is not in the correct format. It looks >> like the & symbols are not being displayed in the url so that if I look >> at my browser address bar after following the link I see something like: >> Sales%2520Reports%2fCustomer%2520Salescustomer1%3dVALENTINE%2520ENTERPRISES%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520%2520date1%3d20050901date2%3d20050930%26 >> >> The parameters look like they follow immediately after the report name >> with no ampersand between them. >> >> Thanks in advance for you assistance. >> >> >> "Bruce L-C [MVP]" <bruce_lcNOSPAM@hotmail.com> wrote in message >> news:eSthLfWtFHA.616@TK2MSFTNGP11.phx.gbl... >>> You need to use Jump to URL: >>> >>> The below example specifies the directory starting from the root. I have >>> this because this particular report can reside in a different directory >>> than the report I am jumping to. If it is in the same directory you can >>> just not worry about specifying the directory. A couple of others things >>> to note, I use the globals variable so this will work regardless of >>> where I deploy it. Also, note that parameter values are case sensitive >>> so you must match it exactly or you will end up without values in your >>> parameter fields. Also note that you can add to this URL a command to >>> tell it to hide the parameter toolbar. Anyway, this should get you >>> started. >>> =Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" & >>> Fields!manifstdocno.Value & "&WasteIDNum=" & Fields!wasteidnum.Value >>> >>> >>> -- >>> Bruce Loehle-Conger >>> MVP SQL Server Reporting Services >>> >>> "PeteMitchell" <PeteMitchell@discussions.microsoft.com> wrote in message >>> news:99C82369-630F-434E-A882-2D0D23A156A4@microsoft.com... >>>>I have a report that takes one parameter called StartDate and I have >>>>given it >>>> a default value and a prompt of 'Enter a Starting Date'. When I preview >>>> it in >>>> the report writer or run it from the Report Manager after deployment, >>>> the >>>> report runs using the default value, displays the correct data, and the >>>> prompt is displayed with the default value in the input box. All is >>>> well and >>>> I am a happy guy. >>>> >>>> I have second report with a textbox that navigates to the first report >>>> using >>>> the 'Jump to Report' method. >>>> >>>> When jumping from the second report to the first from the DESIGNER, the >>>> report runs using the default value, displays the correct data, and the >>>> prompt is displayed with the default value in the input box. Again, all >>>> is >>>> well. >>>> >>>> When doing the same from the Report Manager I get the same results >>>> EXCEPT >>>> the prompt is NOT displayed at all. How can I make the prompt allways >>>> show >>>> when jumping from one report to another ? >>>> >>>> I notice that when you hover over the textbox/link that the URL to the >>>> target report is diplayed in the status bar of the browser with the >>>> value >>>> rs:Parameters=False there. What needs to be done to make it "True" >>>> >>>> Thanks in Advance >>>> Pete >>>> >>> >>> >> >> > >
Hi,
I've the same issue with my reports when using "Jump to Report", even with the new version of RS ... > Will this be fixed in the next version ? How can we use Jump to URL with parameters set as "null" (i.e. for picklists, to have "all values") ? Thanks a lot for your answer ! Laetic [quoted text, click to view] "Bruce L-C [MVP]" wrote:
> You need to use Jump to URL: > > The below example specifies the directory starting from the root. I have > this because this particular report can reside in a different directory than > the report I am jumping to. If it is in the same directory you can just not > worry about specifying the directory. A couple of others things to note, I > use the globals variable so this will work regardless of where I deploy it. > Also, note that parameter values are case sensitive so you must match it > exactly or you will end up without values in your parameter fields. Also > note that you can add to this URL a command to tell it to hide the parameter > toolbar. Anyway, this should get you started. > =Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" & > Fields!manifstdocno.Value & "&WasteIDNum=" & Fields!wasteidnum.Value > > > -- > Bruce Loehle-Conger > MVP SQL Server Reporting Services > > "PeteMitchell" <PeteMitchell@discussions.microsoft.com> wrote in message > news:99C82369-630F-434E-A882-2D0D23A156A4@microsoft.com... > >I have a report that takes one parameter called StartDate and I have given > >it > > a default value and a prompt of 'Enter a Starting Date'. When I preview it > > in > > the report writer or run it from the Report Manager after deployment, the > > report runs using the default value, displays the correct data, and the > > prompt is displayed with the default value in the input box. All is well > > and > > I am a happy guy. > > > > I have second report with a textbox that navigates to the first report > > using > > the 'Jump to Report' method. > > > > When jumping from the second report to the first from the DESIGNER, the > > report runs using the default value, displays the correct data, and the > > prompt is displayed with the default value in the input box. Again, all is > > well. > > > > When doing the same from the Report Manager I get the same results EXCEPT > > the prompt is NOT displayed at all. How can I make the prompt allways show > > when jumping from one report to another ? > > > > I notice that when you hover over the textbox/link that the URL to the > > target report is diplayed in the status bar of the browser with the value > > rs:Parameters=False there. What needs to be done to make it "True" > > > > Thanks in Advance > > Pete > > > >
Sorry, I don't use Null. What I do for pick lists is add and All option and
then in the query I do this: select * from sometable where (somefield = @someparamter or @someparameter = 'All') I use a union query to add All to my pick lists. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Laetic" <Laetic@discussions.microsoft.com> wrote in message news:8DF314B2-0F0C-4587-874B-FB4FF225B78E@microsoft.com... > Hi, > > I've the same issue with my reports when using "Jump to Report", even with > the new version of RS ... > Will this be fixed in the next version ? > > How can we use Jump to URL with parameters set as "null" (i.e. for > picklists, to have "all values") ? > > Thanks a lot for your answer ! > > Laetic > > "Bruce L-C [MVP]" wrote: > >> You need to use Jump to URL: >> >> The below example specifies the directory starting from the root. I have >> this because this particular report can reside in a different directory >> than >> the report I am jumping to. If it is in the same directory you can just >> not >> worry about specifying the directory. A couple of others things to note, >> I >> use the globals variable so this will work regardless of where I deploy >> it. >> Also, note that parameter values are case sensitive so you must match it >> exactly or you will end up without values in your parameter fields. Also >> note that you can add to this URL a command to tell it to hide the >> parameter >> toolbar. Anyway, this should get you started. >> =Globals!ReportServerUrl & "?/Inventory/Similar Loads&Manifest=" & >> Fields!manifstdocno.Value & "&WasteIDNum=" & Fields!wasteidnum.Value >> >> >> -- >> Bruce Loehle-Conger >> MVP SQL Server Reporting Services >> >> "PeteMitchell" <PeteMitchell@discussions.microsoft.com> wrote in message >> news:99C82369-630F-434E-A882-2D0D23A156A4@microsoft.com... >> >I have a report that takes one parameter called StartDate and I have >> >given >> >it >> > a default value and a prompt of 'Enter a Starting Date'. When I preview >> > it >> > in >> > the report writer or run it from the Report Manager after deployment, >> > the >> > report runs using the default value, displays the correct data, and the >> > prompt is displayed with the default value in the input box. All is >> > well >> > and >> > I am a happy guy. >> > >> > I have second report with a textbox that navigates to the first report >> > using >> > the 'Jump to Report' method. >> > >> > When jumping from the second report to the first from the DESIGNER, the >> > report runs using the default value, displays the correct data, and the >> > prompt is displayed with the default value in the input box. Again, all >> > is >> > well. >> > >> > When doing the same from the Report Manager I get the same results >> > EXCEPT >> > the prompt is NOT displayed at all. How can I make the prompt allways >> > show >> > when jumping from one report to another ? >> > >> > I notice that when you hover over the textbox/link that the URL to the >> > target report is diplayed in the status bar of the browser with the >> > value >> > rs:Parameters=False there. What needs to be done to make it "True" >> > >> > Thanks in Advance >> > Pete >> > >> >> >>
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 |