Created Crystal .exe But need to submit Userid and Password

[jsteff]

Crystal 8.5

The report works fine when i execute my report from within my software application.

However, Crystal ALWAYS prompt me to login to Sql Server 7.

Is there a generic way to include a login string in my app when i execute the report?

From inside my app, i have to use something like:
run "Acctng.exe" ......
where Acctng.exe is the report and .... would be the login and password.


Thanks.

 

[crystalreporting]

So you're running a compiled report from with your app?

 

[jsteff]

Yes. That is correct. My app obtains variable data and insert the data into a Sql Server table. Then I need to execute the Crystal Report by issueing the report executable from within the app. At this time, my app says:

RUN "\reports\acctng\MyCrysReport.exe"

The problem is that the next screen they see is a SqlServer login screen. They enter a password and it runs prefectly..... I am trying to find a way to submit the login info when I start the report OR embed the login info in the compiled report.

Any ideas?

 

[herrld]

jsteff,
Did you ever get an answer for this??

Linda