Prompt for parameters, but save password

[Former Member]

I have a report that prompts the user to select a date range for query results.  I am using a 3rd party program to view the report.  Under Report Options, I have disabled "save data with report" so that it prompts for the dates each time the report is opened.  The problem is that is also prompts for the password to the database.  Is there a way to set up the report to ask for a date range, but not ask for the password each time?  The third party program does not prompt for the password, so when trying to view the report, it just errors out.  I am new to CR, so I've only being doing this for a couple of day.  Thanks.

[former_member205840]

Hi Dustin,

You said you are using 3rd party program ?  What is this program ? Is it developed using .net or Java ?  If this is java based of .net based then you can pass user login information through coding.

Otherwise it is not possible to stop asking user credentials when you refresh crystal reports.

Thanks,

Sastry

[abhilash_kumar]

Hi Dustin,

CR Designer does not save the database password, unfortunately.

-Abhilash