Can anyone figure my error with this URL

[jupiter8]

OK here is my URL, Now this loads the report if I do not include the parameters, which proves that the login details for the main report and sub report are ok and thereafter I can refresh and supply values and everything works.

However when I start including the paramters it fails, why? I have another report working OK and I really can't see the difference in the way I'm constructing the URL.

It bound to be really stupid, so please someone put me out of my misery.

myreport.rpt?init=actx:connect
&user0=xxx&password0=yyy
&user0@asif_loss_ratios=xxx
&password0@asif_loss_ratios=yyy
&promptex-@i_QuoteID="28337"
&promptex-@i_UserID="2"
&promptex-@i_Rate="3"
&promptOnRefresh=0

 

[Naith]

School me here.

When you say the report runs when you don't supply the parameters, the report obviously has default parameter values, right?

Also, when you say "it fails" - fails how? Like the URL returns a Page Not Found, or parameter values get ignored, or what?

If you replace your promptex syntaxes with:

...
&promptex0="28337"
&promptex1="2"
&promptex2="3"
&promptOnRefresh=0

what happens?

As a side note, I tend to find that babying parameter passing seems to work more reliably, but that depends on your personal settings.

i.e.

...
&promptex0=" + '"' + "28337" + '"' +
&promptex1=" + '"' + "2" + '"' +
...

Naith

 

[jupiter8]

Yes I do have default values for the report, and I've also tried the passing the paramteres as promptex0 rather than the named parameters, but then I've been caught out the ordering of the parameters before.

As far as the error, I get 'cannot open SQL server.[on Page Server:MyServer.pageserver]

Does that mean I've got a database access problem, I am using the same DSN as my other report which works fine.

 

[jupiter8]

There was no problem with the URL, I just unchecked save report with data and it now works.

Thanks for your help.