Passing mdx parameters to RS through URL (SharePoint Integrated Mode)

Hi there,

I'm running MOSS 2007 in Integrated Mode, and I have a number of reports that are deployed to the Reports Library, and are working just fine when you go there and run them interactively.

Now however, I need to address the report via a URL, and pass it a parameter. Just to add a bit more pain, the report is in mdx, and expects an mdx parameter.

Here is the parameter "prm_cost_centre":

[DIM LEARNER AIM].[COST CENTRE DESC].&[Business]

Here is the URL of the report:

http://vmmoss:88/ReportsLibrary/Report1.rdl

(If you hit that URL as is, it runs fine, using the default parameter)

Now, I know that we have to escape the ampersand, so I'm thinking that this URL should do it.

http://vmmoss:88/ReportsLibrary/Report1.rdl&rs:Command=Render&prm_cost_centre=[DIM LEARNER AIM].[COST CENTRE DESC].%26[Business]

But it doesn't - It throws a 400 Bad Request error.

I know I must be very close, but I just can't work out what URL I need to pass in order to get the damn thing to run.

Any ideas?

I don't have very much experience with MDX params, but I might recommend escaping the periods or possibly the [brackets] too. Sorry I can't offer much more advice than that, but as in any debug scenario, try truncating the param string until you get something that works, then go from there!

|||

It's not possible - you can't pass parameters through the URL when running Reporting Services in Integrated Mode.

http://technet.microsoft.com/en-us/library/bb326290.aspx

How lame is that? All of a sudden, Integrated Mode becomes...worthless to most people, surely.

Passing mdx parameters to RS through URL (SharePoint Integrated Mode)

Hi there,

I'm running MOSS 2007 in Integrated Mode, and I have a number of reports that are deployed to the Reports Library, and are working just fine when you go there and run them interactively.

Now however, I need to address the report via a URL, and pass it a parameter. Just to add a bit more pain, the report is in mdx, and expects an mdx parameter.

Here is the parameter "prm_cost_centre":

[DIM LEARNER AIM].[COST CENTRE DESC].&[Business]

Here is the URL of the report:

http://vmmoss:88/ReportsLibrary/Report1.rdl

(If you hit that URL as is, it runs fine, using the default parameter)

Now, I know that we have to escape the ampersand, so I'm thinking that this URL should do it.

http://vmmoss:88/ReportsLibrary/Report1.rdl&rs:Command=Render&prm_cost_centre=[DIM LEARNER AIM].[COST CENTRE DESC].%26[Business]

But it doesn't - It throws a 400 Bad Request error.

I know I must be very close, but I just can't work out what URL I need to pass in order to get the damn thing to run.

Any ideas?

I don't have very much experience with MDX params, but I might recommend escaping the periods or possibly the [brackets] too. Sorry I can't offer much more advice than that, but as in any debug scenario, try truncating the param string until you get something that works, then go from there!

|||

It's not possible - you can't pass parameters through the URL when running Reporting Services in Integrated Mode.

http://technet.microsoft.com/en-us/library/bb326290.aspx

How lame is that? All of a sudden, Integrated Mode becomes...worthless to most people, surely.

sql

Passing a date report parameter on the URL

I'm trying to call a report I created (and deployed to our dev server -
running reporting services 2005), while passing the parameters on the URL.
I think I'm very close, but it doesn't seem to like the format that the date
is in. However, I've tried everything I can think of (surrounding the date
with quotes, double quotes, pound symbols, and every combination of those I
could think of), and yet I'm still getting the error "The value provided for
the report parameter 'StartDate' is not valid for its type.
(rsReportParameterTypeMismatch) "
The URL I'm using is:
http://ssrsdev/ReportServer/Pages/ReportViewer.aspx?/CSR.Reports/UserLogReport&rs:Command=Render&PersonID='12345'&StartDate='06/11/2007'&EndDate='06/15/2007'
The two "date" parameters are obviously set up as date types (especially as
when I browse to the report without passing parameters, it allows me to pick
the dates for each parameter, rather than just allowing text entry).
Any ideas/suggestions?Scott,
Try to not use the ' " or # and just the value like
Start_Date=06/17/2007&End_Date=06/20/2007
Reeves
"Scott Lyon" wrote:
> I'm trying to call a report I created (and deployed to our dev server -
> running reporting services 2005), while passing the parameters on the URL.
> I think I'm very close, but it doesn't seem to like the format that the date
> is in. However, I've tried everything I can think of (surrounding the date
> with quotes, double quotes, pound symbols, and every combination of those I
> could think of), and yet I'm still getting the error "The value provided for
> the report parameter 'StartDate' is not valid for its type.
> (rsReportParameterTypeMismatch) "
>
> The URL I'm using is:
> http://ssrsdev/ReportServer/Pages/ReportViewer.aspx?/CSR.Reports/UserLogReport&rs:Command=Render&PersonID='12345'&StartDate='06/11/2007'&EndDate='06/15/2007'
>
> The two "date" parameters are obviously set up as date types (especially as
> when I browse to the report without passing parameters, it allows me to pick
> the dates for each parameter, rather than just allowing text entry).
>
> Any ideas/suggestions?

Passing "@" to SQL connection string

Hi,
I'm using c# to connect to a sql database.
My dev work is fine and it connects; when deployed to the live environment,
it needs to have special chacters (@. and !) in it. The ! goes through fine,
but @. is removed. If I hard code the @., it's fine, but my setting is held in
a variable.
Does anybody know how I can pass the @. sign through to a ConnectionString?
I've tried escaping it with a \, but it won't compile (\@. is not a valid
escape sequence).
Thanks,
Sandy
What SQL database? Why do you need a "@."? Is it part of a UserName or
Password?
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Sandy Beach" <SandyBeach@.discussions.microsoft.com> wrote in message
news:4F3897C5-4A0D-4E47-AE35-2B856FB27A33@.microsoft.com...
> Hi,
> I'm using c# to connect to a sql database.
> My dev work is fine and it connects; when deployed to the live
> environment,
> it needs to have special chacters (@. and !) in it. The ! goes through
> fine,
> but @. is removed. If I hard code the @., it's fine, but my setting is held
> in
> a variable.
> Does anybody know how I can pass the @. sign through to a
> ConnectionString?
> I've tried escaping it with a \, but it won't compile (\@. is not a valid
> escape sequence).
> Thanks,
> Sandy
|||Thanks for the response.
I'm trying to connect to a SQL 2000 db and the "@." starts the password. The
DB administrator set it up for the user account I'm allowed to log in as.
Cheers,
Sandy
"William (Bill) Vaughn" wrote:

> What SQL database? Why do you need a "@."? Is it part of a UserName or
> Password?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> "Sandy Beach" <SandyBeach@.discussions.microsoft.com> wrote in message
> news:4F3897C5-4A0D-4E47-AE35-2B856FB27A33@.microsoft.com...
>
>
|||Thanks for helping, but I've managed to track down the problem and it had
nothing to do with the "@." in the password.
I'm encrypting/decrpyting the password, and the decrypt has a list of valid
characters. Guess what? "@." wasn't one of them!
So, again, thanks for you help and time.
Cheers,
Grahame
"Sandy Beach" wrote:
[vbcol=seagreen]
> Thanks for the response.
> I'm trying to connect to a SQL 2000 db and the "@." starts the password. The
> DB administrator set it up for the user account I'm allowed to log in as.
> Cheers,
> Sandy
> "William (Bill) Vaughn" wrote:

Passing "@" to SQL connection string

Hi,
I'm using c# to connect to a sql database.
My dev work is fine and it connects; when deployed to the live environment,
it needs to have special chacters (@. and !) in it. The ! goes through fine,
but @. is removed. If I hard code the @., it's fine, but my setting is held in
a variable.
Does anybody know how I can pass the @. sign through to a ConnectionString?
I've tried escaping it with a \, but it won't compile (\@. is not a valid
escape sequence).
Thanks,
SandyWhat SQL database? Why do you need a "@."? Is it part of a UserName or
Password?
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Sandy Beach" <SandyBeach@.discussions.microsoft.com> wrote in message
news:4F3897C5-4A0D-4E47-AE35-2B856FB27A33@.microsoft.com...
> Hi,
> I'm using c# to connect to a sql database.
> My dev work is fine and it connects; when deployed to the live
> environment,
> it needs to have special chacters (@. and !) in it. The ! goes through
> fine,
> but @. is removed. If I hard code the @., it's fine, but my setting is held
> in
> a variable.
> Does anybody know how I can pass the @. sign through to a
> ConnectionString?
> I've tried escaping it with a \, but it won't compile (\@. is not a valid
> escape sequence).
> Thanks,
> Sandy|||Thanks for the response.
I'm trying to connect to a SQL 2000 db and the "@." starts the password. The
DB administrator set it up for the user account I'm allowed to log in as.
Cheers,
Sandy
"William (Bill) Vaughn" wrote:

> What SQL database? Why do you need a "@."? Is it part of a UserName or
> Password?
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> __________________________________
> "Sandy Beach" <SandyBeach@.discussions.microsoft.com> wrote in message
> news:4F3897C5-4A0D-4E47-AE35-2B856FB27A33@.microsoft.com...
>
>|||Thanks for helping, but I've managed to track down the problem and it had
nothing to do with the "@." in the password.
I'm encrypting/decrpyting the password, and the decrypt has a list of valid
characters. Guess what? "@." wasn't one of them!
So, again, thanks for you help and time.
Cheers,
Grahame
"Sandy Beach" wrote:
[vbcol=seagreen]
> Thanks for the response.
> I'm trying to connect to a SQL 2000 db and the "@." starts the password. Th
e
> DB administrator set it up for the user account I'm allowed to log in as.
> Cheers,
> Sandy
> "William (Bill) Vaughn" wrote:
>