Unmanaged Reports Passing Database Logon Info 1

[ganjass]

CR8
Sql Server2000

Hi ALL,

I have a very annoying problem with prompts for a database logon for a subreport that i have in a main report, through URL Commands through WCS I am using the following syntax

?USER0=XX&PASSWORD0=XX&USER1@Login=XX&PASSWORD1@Login=XX

and yet i'm still being prompted for the login subreport. Once I have entered the login information in the login prompt, the report will then open every time without a prompt using the same information. I'm not passing any paramaters, only the database login.

The sub report has the same DSN as the main, but ther prompts are still happening. This happens with a lot of reports when adding subreports

I've found articles on issues with passing paramaters, but none with database information

any ideas?

Thanks in advance

 

[marina9]

Hi ganjass,

You may want to take a look at this article:

http://support.businessobjects.com/library/kbase/articles/c2008617.asp

Hope it helps!

 

[ganjass]

Hi Marina,

Thanks for the post, i worked out that by passing the subreport paramaters first it worked. I have the Group header with the subreport in it above the group header that i'm passing the shared varibles. Quirky but true

I used the syntax

USER0@Login.rpt=XX&PASSWORD0@Login.rpt=XX&USER1=XX&Password1=XX

and it worked!