Including multivalued parameter in URL

I know how to include a parameter in a URL, by appending it after & sign at
end of report URL - works fine.
I can not figure out the syntax (if it is in fact possible) of passing a
multiple selection for a multivalued parameter. I tried both these formats,
where the ... represents the entire URL of the base report, including the
render command:
1) ...&Comp_Inv_ID=C123, C345
2) ...&Comp_Inv_ID=C123%2c%20C345 (i.e., converting the comma and space to
the %hex format, where hex 2c is comma and hex 20 is space)
Note that ...&Comp_Inv_ID=C123 works, selecting the single item.
Is it possible I have to somehow include each value as its own
&Comp_Inv_ID=<val> pair, connected by some sort of AND condition?I know one way to do it, but it isn't real elegant.
rather than this:
¶m=val1,val2,val3
you do this:
¶m=val1¶m=val2¶m=val3
isaksp00 wrote:
> I know how to include a parameter in a URL, by appending it after & sign at
> end of report URL - works fine.
> I can not figure out the syntax (if it is in fact possible) of passing a
> multiple selection for a multivalued parameter. I tried both these formats,
> where the ... represents the entire URL of the base report, including the
> render command:
> 1) ...&Comp_Inv_ID=C123, C345
> 2) ...&Comp_Inv_ID=C123%2c%20C345 (i.e., converting the comma and space to
> the %hex format, where hex 2c is comma and hex 20 is space)
> Note that ...&Comp_Inv_ID=C123 works, selecting the single item.
> Is it possible I have to somehow include each value as its own
> &Comp_Inv_ID=<val> pair, connected by some sort of AND condition?|||Thanks! I had just figured that one out about an hour ago as well.
Decidedly inelegant.
"Potter" wrote:
> I know one way to do it, but it isn't real elegant.
>
> rather than this:
>
> ¶m=val1,val2,val3
>
> you do this:
>
> ¶m=val1¶m=val2¶m=val3
>
> isaksp00 wrote:
> > I know how to include a parameter in a URL, by appending it after & sign at
> > end of report URL - works fine.
> >
> > I can not figure out the syntax (if it is in fact possible) of passing a
> > multiple selection for a multivalued parameter. I tried both these formats,
> > where the ... represents the entire URL of the base report, including the
> > render command:
> >
> > 1) ...&Comp_Inv_ID=C123, C345
> > 2) ...&Comp_Inv_ID=C123%2c%20C345 (i.e., converting the comma and space to
> > the %hex format, where hex 2c is comma and hex 20 is space)
> > Note that ...&Comp_Inv_ID=C123 works, selecting the single item.
> > Is it possible I have to somehow include each value as its own
> > &Comp_Inv_ID=<val> pair, connected by some sort of AND condition?
>

Include report link in subscription does not render the correct URL

Hi,

I am sure there is a thread about that one but I cannot find it.

I have a server which does not include the correct link with the subsciptions.

I create a subscription and ask to include the link to the reporet, I get the report with the machine name instead of the DNS name.

i.e. i get

The report is accessible at the following address:

http://atlanta/reportserver/...

instead of http://reporting.onsemi.com/reports/....

I tried to edit rswebapplication.config like that

<ReportServerUrl>reporting.onsemi.com</ReportServerUrl>

and rsreportserver.config like that

<DefaultHostName>onsemi.com</DefaultHostName>

but still cannot get the correct URL in the subscription.

Any idea?

Thanks,

Philippe

Find rsreportserver.config.

Look for UrlRoot and update that in the config.

Restart Reporting Services.

Include report link in subscription does not render the correct URL

Hi,

I am sure there is a thread about that one but I cannot find it.

I have a server which does not include the correct link with the subsciptions.

I create a subscription and ask to include the link to the reporet, I get the report with the machine name instead of the DNS name.

i.e. i get

The report is accessible at the following address: http://atlanta/reportserver/...

instead of http://reporting.onsemi.com/reports/....

I tried to edit rswebapplication.config like that

<ReportServerUrl>reporting.onsemi.com</ReportServerUrl>

and rsreportserver.config like that

<DefaultHostName>onsemi.com</DefaultHostName>

but still cannot get the correct URL in the subscription.

Any idea?

Thanks,

Philippe

Find rsreportserver.config.

Look for UrlRoot and update that in the config.

Restart Reporting Services.