Password
Hi
I save my completed report to the server which has parameters where the users have a drop down selection criteria for the parameters.
EG
CpyA
CpyB
etc .etc
This works fine - however, if I then take the report from the server and save to my desktop and then open it locally on my PC I get prompted for the password as if the report is still o n the server. When I put the password in then all works ok and the parameters work as expected with the drop downs. However, here is the bit I do not get - if I open the report locally and decline to put in the password and click cancel on the prompting box I can still run the report but the parameters do not show any drop down values - they have to be entered manually. Why? and how can I get round this.
Regards
I save my completed report to the server which has parameters where the users have a drop down selection criteria for the parameters.
EG
CpyA
CpyB
etc .etc
This works fine - however, if I then take the report from the server and save to my desktop and then open it locally on my PC I get prompted for the password as if the report is still o n the server. When I put the password in then all works ok and the parameters work as expected with the drop downs. However, here is the bit I do not get - if I open the report locally and decline to put in the password and click cancel on the prompting box I can still run the report but the parameters do not show any drop down values - they have to be entered manually. Why? and how can I get round this.
Regards
ASKER
Hi
I develop the reports using Crystal reports developer.
When I initially build/develop the report locally on my PC the drop downs work. I then save to the server where I do my administrative bit - set password etc.
Then say I want to modify the report - I open Crystal Developer then go to "Enterprise"
and put in my adminstrator password and retrieve the report and save back to my desktop.
I then open the report locally and this is where the problems begin - does this help?
Note: the reports are run by the user from a reportal.
Regards
I develop the reports using Crystal reports developer.
When I initially build/develop the report locally on my PC the drop downs work. I then save to the server where I do my administrative bit - set password etc.
Then say I want to modify the report - I open Crystal Developer then go to "Enterprise"
and put in my adminstrator password and retrieve the report and save back to my desktop.
I then open the report locally and this is where the problems begin - does this help?
Note: the reports are run by the user from a reportal.
Regards
Once you retrieve the report from the Enterprise you no longer have a user/password associated with it.
What happens if you don't save it first to your desktop?
mlmcc
What happens if you don't save it first to your desktop?
mlmcc
ASKER
Not sure what you mean "What happens if you don't save it first to your desktop"
Where should I save it to?
Regards
Where should I save it to?
Regards
ASKER
I've found out what is happening - the parameters have gone to static and when I reset to Dynamic then all is fine - HMM!
Interesting. Not sure I would have thought of that.
You said you were retrieving the report through the designer then saving it. Once in the designer you should be able to run it.
mlmcc
You said you were retrieving the report through the designer then saving it. Once in the designer you should be able to run it.
mlmcc
ASKER
I can run it from the designer when I enter the password.
It's just that when I open the report from the server using Crystal Designer then save it to my desktop and then close my designer - reopen Crystal Designer then open the report saved to my PC - hit the refresh button and then get prompted for the server password. If I use the server prompt then all works well - however, if I ignore the password prompt and click on cancel cancel - I can then still run the report without the password prompt and it's at this point that the parameters default to static.
I can reset the parameters to dynamic but just wondered why this happens.
Hope that makes sense.
Regards
It's just that when I open the report from the server using Crystal Designer then save it to my desktop and then close my designer - reopen Crystal Designer then open the report saved to my PC - hit the refresh button and then get prompted for the server password. If I use the server prompt then all works well - however, if I ignore the password prompt and click on cancel cancel - I can then still run the report without the password prompt and it's at this point that the parameters default to static.
I can reset the parameters to dynamic but just wondered why this happens.
Hope that makes sense.
Regards
Once you save the report to your desktop, it loses the connection to the enterprise where the logon information is stored. If you cancel the logon then it can't get to the data for the parameter lists. Apparently it then converts them to static since there is no connection to the DB.
Other than that I don't know. When I am working with Enterprise reports, I generally save to my favorites if I need to make changes rather than the desktop.
As you have noted when you save a report back to the enterprise you have to read the logon information. That is true even if you open the report from the enterprise and immediately save it back to the enterprise.
mlmcc
Other than that I don't know. When I am working with Enterprise reports, I generally save to my favorites if I need to make changes rather than the desktop.
As you have noted when you save a report back to the enterprise you have to read the logon information. That is true even if you open the report from the enterprise and immediately save it back to the enterprise.
mlmcc
ASKER
Last question - when I retrieve a report from the server and save to say favourites - I then open the report from favourites and get prompted as if the report was still on the server where it asks me for the administrator password. Will this always be the case?
Regards
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Its a database logon prompt and we are using Oracle 11g.
Your answers have been helpful and thankls for your time.
Regards
Your answers have been helpful and thankls for your time.
Regards
ASKER
Thanks
The username/password is stored in Crystal Server for the report.
How are you running it locally?
I assume it is through the Crystal designer.
How are reports run from the server?
mlmcc