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

Report parameter 'x' was not found.

I created a simple report to display the default value of a report parameter.
But when I run in VS it works, but when I run it under the "Custom Report"
in SQL Server Managment Studio the report parameter is not found. Below is
the code what am I doing wrong. Thanks in advance for your help.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataSource1">
<DataSourceReference>DataSource1</DataSourceReference>
<rd:DataSourceID>b64e9e97-e752-4d30-8e40-ad77c2582190</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<ReportParameters>
<ReportParameter Name="x">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>5</Value>
</Values>
</DefaultValue>
<Prompt>x</Prompt>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<Textbox Name="textbox1">
<Left>2in</Left>
<Top>0.375in</Top>
<rd:DefaultName>textbox1</rd:DefaultName>
<Width>1.125in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.375in</Height>
<Value>=First(Fields!x.Value, "DataSet1")</Value>
</Textbox>
</ReportItems>
<Height>2in</Height>
</Body>
<rd:ReportID>397ab84d-5c20-454f-9ec1-a1548611ba69</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<DataSets>
<DataSet Name="DataSet1">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select @.x x</CommandText>
<QueryParameters>
<QueryParameter Name="@.x">
<Value>=Parameters!x.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataSource1</DataSourceName>
</Query>
<Fields>
<Field Name="x">
<rd:TypeName>System.Object</rd:TypeName>
<DataField>x</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>6.5in</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>1in</TopMargin>
</Report>Did you find a solution to this?
--
-sam
"Greg Larsen" wrote:
> I created a simple report to display the default value of a report parameter.
> But when I run in VS it works, but when I run it under the "Custom Report"
> in SQL Server Managment Studio the report parameter is not found. Below is
> the code what am I doing wrong. Thanks in advance for your help.
> <?xml version="1.0" encoding="utf-8"?>
> <Report
> xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition"
> xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
> <DataSources>
> <DataSource Name="DataSource1">
> <DataSourceReference>DataSource1</DataSourceReference>
> <rd:DataSourceID>b64e9e97-e752-4d30-8e40-ad77c2582190</rd:DataSourceID>
> </DataSource>
> </DataSources>
> <BottomMargin>1in</BottomMargin>
> <RightMargin>1in</RightMargin>
> <ReportParameters>
> <ReportParameter Name="x">
> <DataType>String</DataType>
> <DefaultValue>
> <Values>
> <Value>5</Value>
> </Values>
> </DefaultValue>
> <Prompt>x</Prompt>
> </ReportParameter>
> </ReportParameters>
> <rd:DrawGrid>true</rd:DrawGrid>
> <InteractiveWidth>8.5in</InteractiveWidth>
> <rd:SnapToGrid>true</rd:SnapToGrid>
> <Body>
> <ReportItems>
> <Textbox Name="textbox1">
> <Left>2in</Left>
> <Top>0.375in</Top>
> <rd:DefaultName>textbox1</rd:DefaultName>
> <Width>1.125in</Width>
> <Style>
> <PaddingLeft>2pt</PaddingLeft>
> <PaddingBottom>2pt</PaddingBottom>
> <PaddingRight>2pt</PaddingRight>
> <PaddingTop>2pt</PaddingTop>
> </Style>
> <CanGrow>true</CanGrow>
> <Height>0.375in</Height>
> <Value>=First(Fields!x.Value, "DataSet1")</Value>
> </Textbox>
> </ReportItems>
> <Height>2in</Height>
> </Body>
> <rd:ReportID>397ab84d-5c20-454f-9ec1-a1548611ba69</rd:ReportID>
> <LeftMargin>1in</LeftMargin>
> <DataSets>
> <DataSet Name="DataSet1">
> <Query>
> <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
> <CommandText>select @.x x</CommandText>
> <QueryParameters>
> <QueryParameter Name="@.x">
> <Value>=Parameters!x.Value</Value>
> </QueryParameter>
> </QueryParameters>
> <DataSourceName>DataSource1</DataSourceName>
> </Query>
> <Fields>
> <Field Name="x">
> <rd:TypeName>System.Object</rd:TypeName>
> <DataField>x</DataField>
> </Field>
> </Fields>
> </DataSet>
> </DataSets>
> <Width>6.5in</Width>
> <InteractiveHeight>11in</InteractiveHeight>
> <Language>en-US</Language>
> <TopMargin>1in</TopMargin>
> </Report>

Report parameter using Member_Key

I am trying to create a parameter driven SSRS report agains my cube but I want the parameter to contain only the Key value of the member I am trying to select. When I use the query designer, I get something like this:

SELECT ( STRTOSET(@.PlantStructureDepartment, CONSTRAINED)

Where @.PlantStructureDepartment is my paramter and contains the Unique Name of the member like this "[Plant Structure].[Department].&[39952]" where "39952" is the Key value.

What I want is to be able to pass the paramter in as "39952" and build the rest of the string. I tried this:

SELECT ( STRTOSET('[Plant Structure].[Department].&[' + @.PlantStructureDepartment + ']', CONSTRAINED)

but that didn't work.

The reason I'm trying to do this is that we are using SharePoint integrated filtering and we have a number of basic relational reports using the same filters as the reports against the cubes. We would like to keep them all using the integer values.

For sake of completeness, here is the full query as it sits right now:

SELECT NON EMPTY { [Measures].[FTT Percent] } ON COLUMNS, NON EMPTY { ([Plant Structure].[Prod Line].[Prod Line].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOSET(@.PlantStructureDepartment, CONSTRAINED) ) ON COLUMNS FROM [FTT]) WHERE ( IIF( STRTOSET(@.PlantStructureDepartment, CONSTRAINED).Count = 1, STRTOSET(@.PlantStructureDepartment, CONSTRAINED), [Plant Structure].[Department].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

I am fairly new to MDX and would appreciate any help or suggestions.

Here is a copy of the query modified to use Adventure Works but illustrating what you requested. Where I've used '1', you would use your report parameter value.

Hope that helps,
Bryan

Code Snippet

SELECT

NON EMPTY { [Measures].[Reseller Sales Amount] } ON COLUMNS,

NON EMPTY { ([Product].[SubCategory].[SubCategory].ALLMEMBERS ) }

DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

FROM (

SELECT ( STRTOSET('[Product].[Category].&['+'1'+']', CONSTRAINED) ) ON COLUMNS

FROM [Adventure Works])

WHERE (

IIF( STRTOSET('[Product].[Category].&['+'1'+']', CONSTRAINED).Count = 1,

STRTOSET('[Product].[Category].&['+'1'+']', CONSTRAINED),

[Product].[Category].currentmember

)

)

CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS

|||

Bryan,

Thanks for the reply. I think you are stating the same thing that I tried already. When I hardcode the value as you suggest, the query works. However, when I set up the parameter, I get this message:

Parser: The query contains the Department parameter, which is not declared. (msmgdsrv)

This is because the paramter isn't declared in the data tab of the report. When I declare the parameter, I get this error:

Query (6, 23) The restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated. (Microsoft SQL Server 2005 Analysis Services)

The parameters page of the Data tab only allows you to tie a parameter to a dimension of the cube. I think I need a way around that.

Thanks again for the idea. If you have another, I'd appreciate it.

Chris

|||

The CONSTRAINED keyword is there to prevent an injection of a function call into the statement. While I think this is a good idea, I get the same error as you do when no injection is occuring. While I would recommend digging into the MDX statement a little deeper to understand the issue, I have in the past simply removed the CONSTRAINED keyword.

Not sure this is the best of ideas, but .....

Bryan

|||

That's what it was.

Thanks!

|||

You have CONSTRAINED in several areas, do you need to remove them all. Can you post your modified code?

Thanks,

Shari

|||I don't have access to my query right at the moment (I'm at a different location) but suffice it to say, I removed all of the CONSTRAINED flags and it worked. To the point made earlier, I'm not sure if it was a good idea, but it got me around the issue I was having.|||

I tried that, removing all the CONSTRAINED but got another error about STRTOSET function expects a tuple set, string was supplied .... . I am anxious to see your query if you could share (when you have access).

Thanks,

Shari

Report Parameter to return a "NULL" value

All
I am writing a report by salesperson and have the salespersons name as
a report Parameter however in the database it can return a NULL value
is the sale was genereated by someone other than the sales team. In
order for me to get the correct totals i need to include the NULL
value but if i select NULL it returns a blank report?
Any ideas?
cheersOn Jun 18, 3:38 am, blueboy <matt_me...@.hotmail.com> wrote:
> All
> I am writing a report by salesperson and have the salespersons name as
> a report Parameter however in the database it can return a NULL value
> is the sale was genereated by someone other than the sales team. In
> order for me to get the correct totals i need to include the NULL
> value but if i select NULL it returns a blank report?
> Any ideas?
> cheers
If I understand you correctly, have you tried using a value similar to
"Non Applicable" or some other descriptor that represents the null
value in the report parameter. That way, in the stored procedure/query
that is sourcing the report you can check for "...if @.SalesPerson ='Non Applicable' begin select * from table_x where salesperson is
null... end..." Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Report Parameter Default Value from Column

DataSet2:
select MyCol1 from MySecondTable
In the Report Parameters dialog box, I add MyCol1 as a multi-value
parameter. When I run the report, I can select one or more values from the
MyCol1 drop-down. This works great.
The problem is I want the first value in MyCol1 to be the default value in
the drop-down. In the Default Values box, I select Non-queried, and use the
expression =Parameters!MyCol1.Value(0) This seems exactly right to me.
With the default value set as above, the report fails to run with the
following error: Error during processing of 'MyCol1' report parameter.
Any suggestions on how to fix this?
Thanks,
--
RandyYou can create a hidden parameter but not multi-valued. Set its default
value as coming from a query and select MyCol1 in DataSet2, it should pull
the first value from the dataset. Then you can set the default value of the
multi-valued parameter to the value of the hidden parameter.
"randy1200" wrote:
> DataSet2:
> select MyCol1 from MySecondTable
> In the Report Parameters dialog box, I add MyCol1 as a multi-value
> parameter. When I run the report, I can select one or more values from the
> MyCol1 drop-down. This works great.
> The problem is I want the first value in MyCol1 to be the default value in
> the drop-down. In the Default Values box, I select Non-queried, and use the
> expression =Parameters!MyCol1.Value(0) This seems exactly right to me.
> With the default value set as above, the report fails to run with the
> following error: Error during processing of 'MyCol1' report parameter.
> Any suggestions on how to fix this?
> Thanks,
> --
> Randy|||I have done this by creating another dataset called someting like
MyCol1Default defined as:
SELECT TOP1 MyCol1 FROM MySecondTable
or
SELECT MIN(MyCol1) FROM MySecondTable
Then in the report parameter definition specify that the default comes from
dataset MyCol1Default and that the value is MyCol1.
HTH,
Magendo_man
"randy1200" wrote:
> DataSet2:
> select MyCol1 from MySecondTable
> In the Report Parameters dialog box, I add MyCol1 as a multi-value
> parameter. When I run the report, I can select one or more values from the
> MyCol1 drop-down. This works great.
> The problem is I want the first value in MyCol1 to be the default value in
> the drop-down. In the Default Values box, I select Non-queried, and use the
> expression =Parameters!MyCol1.Value(0) This seems exactly right to me.
> With the default value set as above, the report fails to run with the
> following error: Error during processing of 'MyCol1' report parameter.
> Any suggestions on how to fix this?
> Thanks,
> --
> Randy

report not showing information in rows

Hello,
I have several reports that work fine other then when the values for a
column is the same as the one below it the the value dose not show up? Is
this something I can turn off?
For example I have a column that might have several rows of 0 but only one 0
will there and then blank rows till the next value.Hi John,
It sounds like the rows have the property "Hide Duplicates" assigned to the
column or field that is repeating the value. You can toggle this attribute
in the property dialogue of the field in question.
Rodney Landrum
Author - Pro SQL Reporting Services (Apress)
"John" <John@.discussions.microsoft.com> wrote in message
news:9C51915F-4DA6-4C3F-8106-7ECB8E89C98D@.microsoft.com...
> Hello,
> I have several reports that work fine other then when the values for a
> column is the same as the one below it the the value dose not show up? Is
> this something I can turn off?
> For example I have a column that might have several rows of 0 but only one
> 0
> will there and then blank rows till the next value.
>|||I create the report in code but that sound like it is my problem thanks
"Rodney" wrote:
> Hi John,
> It sounds like the rows have the property "Hide Duplicates" assigned to the
> column or field that is repeating the value. You can toggle this attribute
> in the property dialogue of the field in question.
> Rodney Landrum
> Author - Pro SQL Reporting Services (Apress)
>
> "John" <John@.discussions.microsoft.com> wrote in message
> news:9C51915F-4DA6-4C3F-8106-7ECB8E89C98D@.microsoft.com...
> > Hello,
> > I have several reports that work fine other then when the values for a
> > column is the same as the one below it the the value dose not show up? Is
> > this something I can turn off?
> > For example I have a column that might have several rows of 0 but only one
> > 0
> > will there and then blank rows till the next value.
> >
>
>

Report not refreshed

I have created an asp.net application in which i have a textbox and botton.T

he textbox value is passed as parameter to a report and the corresponding report is generated on button click.The problem is that once i add a report to any application the same report is displayed each time i.e. the report is not updating whenever there is a change in the database values.

Iam refreshing the datasource in the original report and change is reflected there in original report but in the dotnet application always the old report is maintained......

Can anybody help me out......

I had the same problem reportviewer1.reset nd I sovled it by added a line code before refreshing the report:

reportviewer1.reset

|||

I had the same problem and I sovled it by added a line of code before refreshing the report:

reportviewer1.reset

|||

Thanx Frankmeng for your suggestion but it is not working....

It is giving me build error.

Error 1 'Microsoft.Reporting.WebForms.ReportViewer' does not contain a definition for 'Reset'
Can u help me with this?

I would also like to know whether we can set the paging property of the report so that only desired number of records are displayed in a page and the user doesn't have to scroll up and down.

Thanx.

|||

Arun:

It is sovled by added a line of code in the Button click event.

reportviewer1.localreport.refresh()

|||Thanks a lot Arun its working...

Report not Aggregates

Is there anyway to do a simple line chart that compares 5 fields? For
example, X axis shows fieldA, fieldB, fieldC, etc where Y axis is the value.
I'm having such a hard time with this, the report keeps wanting to take the
Sum or Count (aggregate) of fields. The values don't need summed, they're
already contained in the fields. Please help.
Thanks,
RyanHello Ryan,
I would like to know how you use the SQL Statement to get the dataset.
Also, please give me some sample data.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||2 Tables
table_items
item_id (PK)
item_name
table_values
value_id (PK)
year
actual_amount
item_id (FK)
SQL statement used for the dataset (for years 2002-2004 for example)
(the embedded selects are because some items will not have a row for years,
this puts a 0 value in for those years)
SELECT A.item_id, A.item_name, ISNULL
((SELECT actual_amount
FROM dbo.amounts
WHERE (item_id = A.id) AND (year = 2002)),
0) AS [2002 Actual], ISNULL
((SELECT actual_amount
FROM dbo.amounts AS amounts_5
WHERE (item_id = A.id) AND (year = 2003)),
0) AS [2003 Actual], ISNULL
.....
ETC.
The SQL resultset looks like this:
item_id
item_name
2002 Actual
2003 Actual
2004 Actual
Each item (detail row) is displayed on it's own page. I want each item to
have it's own graph. Just a simple line graph in this example would display
on the X-axis 2002 Actual, 2003 Actual, and 2004 Actual.
Probably too much info for a simple problem but there it is!
Thanks!
Ryan
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:HQcIY19CIHA.360@.TK2MSFTNGHUB02.phx.gbl...
> Hello Ryan,
> I would like to know how you use the SQL Statement to get the dataset.
> Also, please give me some sample data.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Ryan,
I suggest you just use another dataset for the chart.
Since the chart is based on the dataset's column and you could not put
multiple columns into the X Axis, you need to use another dataset like this:
item_id, item_name, Actual value, Year.
So that when you put the Year into the X axis, you could get the result you
want.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hmmm, this looks good. The problem though is that the last year in the
chart is a different field. For example:
[2006 Actual], [2007 Actual], [2008 Budget].
The last year draws from a Budget field and not the Actual field.
Looks like this may not be doable. We did have the chart in Microsoft
Access. I may have them use that or see if there's any way to accomplish
this in Crystal Reports (I need something I can build into my VS project).
Thanks,
Ryan
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:7$yFzgvDIHA.5256@.TK2MSFTNGHUB02.phx.gbl...
> Hello Ryan,
> I suggest you just use another dataset for the chart.
> Since the chart is based on the dataset's column and you could not put
> multiple columns into the X Axis, you need to use another dataset like
> this:
> item_id, item_name, Actual value, Year.
> So that when you put the Year into the X axis, you could get the result
> you
> want.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Ryan,
If you are using VS 2005, you could use the ReportViewer Control to
complish this report in the WinForm or Web Form.
Reporting Services and ReportViewer Controls in Visual Studio
http://msdn2.microsoft.com/en-us/library/ms345248.aspx
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Report item not linked to a dataset

I have a need to add a text box to a report. The text box will have an
expression that I need to have that captues the value of a field from a
second data set associated with the report. I add a text box but in the edit
expresssion process I can't access any fields (from any data set) and i get
the message Report item not linked to a dataset. I'm not trying to add a new
table or anything like that. I just want to be able to grab that field value
and disply.
--
Thanks, JimOn Sep 21, 11:38 am, Jim B <J...@.lightning.com> wrote:
> I have a need to add a text box to a report. The text box will have an
> expression that I need to have that captues the value of a field from a
> second data set associated with the report. I add a text box but in the edit
> expresssion process I can't access any fields (from any data set) and i get
> the message Report item not linked to a dataset. I'm not trying to add a new
> table or anything like that. I just want to be able to grab that field value
> and disply.
> --
> Thanks, Jim
If I'm understanding you correctly, you should be able to reference a
dataset via an aggregate expression. Something like this should work.
=Max(Fields!SomeFieldName.Value, "SomeDatasetName")
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||That's exactly what I needed to know. Thanks for your response to my question.
--
Thanks, Jim
"EMartinez" wrote:
> On Sep 21, 11:38 am, Jim B <J...@.lightning.com> wrote:
> > I have a need to add a text box to a report. The text box will have an
> > expression that I need to have that captues the value of a field from a
> > second data set associated with the report. I add a text box but in the edit
> > expresssion process I can't access any fields (from any data set) and i get
> > the message Report item not linked to a dataset. I'm not trying to add a new
> > table or anything like that. I just want to be able to grab that field value
> > and disply.
> > --
> > Thanks, Jim
>
> If I'm understanding you correctly, you should be able to reference a
> dataset via an aggregate expression. Something like this should work.
> =Max(Fields!SomeFieldName.Value, "SomeDatasetName")
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Sep 23, 9:20 am, Jim B <J...@.lightning.com> wrote:
> That's exactly what I needed to know. Thanks for your response to my question.
> --
> Thanks, Jim
> "EMartinez" wrote:
> > On Sep 21, 11:38 am, Jim B <J...@.lightning.com> wrote:
> > > I have a need to add a text box to a report. The text box will have an
> > > expression that I need to have that captues the value of a field from a
> > > second data set associated with the report. I add a text box but in the edit
> > > expresssion process I can't access any fields (from any data set) and i get
> > > the message Report item not linked to a dataset. I'm not trying to add a new
> > > table or anything like that. I just want to be able to grab that field value
> > > and disply.
> > > --
> > > Thanks, Jim
> > If I'm understanding you correctly, you should be able to reference a
> > dataset via an aggregate expression. Something like this should work.
> > =Max(Fields!SomeFieldName.Value, "SomeDatasetName")
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Glad I could help.
Regards,
Enrique Martinez
Sr. Software Consultant

Report is not printing selected parameters

I have a report that a user can select one of five parameters. Lets just say
those parameters are:
ALL
North
South
East
West
The default value is set to ALL and multi-values are not allowed. If the
end-user selects North, the report displays just fine in Preview mode. When
the user prints the report, the entire report is printed instead of just
printing the report for North.
Any suggestions would be appreciated. Thanks!
AmedeoPlease disregard this question. I deployed the reports to the report manager
and everything is working fine from the report manager. If I select East and
then click print, it only prints the report for East.
I'm not sure why is wasn't working from the preview mode tab but I've got
other things to spend my time trying to figure out.
Thanks!
"Amedeo Feroce" <aferoce@.akdhc.com> wrote in message
news:%23ytf7bKwGHA.4968@.TK2MSFTNGP03.phx.gbl...
>I have a report that a user can select one of five parameters. Lets just
>say those parameters are:
> ALL
> North
> South
> East
> West
> The default value is set to ALL and multi-values are not allowed. If the
> end-user selects North, the report displays just fine in Preview mode.
> When the user prints the report, the entire report is printed instead of
> just printing the report for North.
> Any suggestions would be appreciated. Thanks!
> Amedeo
>