Prompt for parameters, but save password
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.