Report Parameters

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
PeteYou 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
>|||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
"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 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
"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
> >> >
> >>
> >>
> >>
>
>|||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
>|||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
>>
>|||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.
"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
"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
"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
>> >
>>sql