Pass database login so user not prompted

[Luvsql]

I have tried to include the user-servername.database=myuser&password-servername.database=mypassword after the report URL ie

http://webserver/folder/report.rpt?,

but it still opens the crystal report viewer prompting for a user ID and password, as this report has a parameter.

Is it not possible to only get a parameter prompt? I have asp pages which uses the ?init=actx, so it's a wizard, but that also always prompts for a database login.

 

[Turkbear]

Hi,
What version of CR are youy using?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Luvsql]

Version 9. I've added this after the .rpt:

?init=actx&user0=myusername&password0=mypassword

This works great for reports that do not have parameters, however, if it has a parameter, it still prompts for the user ID, then the parameters.

Even if I use the default DHTML viewer (ie removing the init=actx), it still opens the page to enter login ID and parameters.

Is there anyway to skip the first window with the User ID prompt and just go right to the parameter prompts?

I'm using CE 9 Standard with CR 9 Advanced, using unmanaged reports on an asp page.

 

[Turkbear]

Hi,
If you do not provide the parameters in the URL, the need for CR to prompt for them causes CR to 'forget' the user/pass info it got from the URL..If a report needs parameters you must send them in the URL along with the user/pass info for it to work as expected.

init=actx&user0=myusername&password0=mypassword&prompt0=23&prompt1=value2

( Or use the &promptex-ParamName= version)






To Paraphrase:"The Help you get is proportional to the Help you give.."