Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access Rights for Users

Status
Not open for further replies.

MikeCopeland

Programmer
May 21, 2007
91
US
I am working at an enterprise (using CR XI), preparing reports as needed. However, once a report has been created, I'm the only one here who can change the selection parameters (F5) to run reports with different date ranges.
This is obviously not what they want here, but no one knows how to configure the users' computer desktops to allow them to run their report(s) with different parameters than I last used. We clearly don't want to give users who have Crystal Reports on their machines full Administrator rights, but isn't there some CR configuration that would allow them to run the reports with different parameters and save those reports on their systems/drives? Please advise. TIA
 
Hi,
Why can't you have the parameter prompt the user for the date range desired?

If the users have CR installed on their desktop they can change anything, right? Not sure what Admin rights have to do with it.





[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
I'm not sure what you mean by "parameter prompt", but I've written the reports to have tables of date ranges (defined as business quarters) that are changed by F5 command. CR doesn't allow this on users' systems (and I can't explain what error is given because they are gone for the day...). 8<{{
I don't know a different way to set up reports (promoting?), so if there's another way to allow users to run/print these reports (so long as they have Read access to the database) I'd like to learn it. 8<}}
 
Hi,
Usually a report is designed with the parameters so that new/different values can be selected a runtime.

The parameter, used in a record selection criteria formula, will prompt the user when the report is refreshed ( or run the first time) to supply the needed value(s).

What is the selection criteria in your reports and where are the date ranges specified?

[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top