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
PHIL SawyerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
For reports stored locally I don't believe you can get around it.  Crystal does NOT save the username/password with the report.

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
0
PHIL SawyerAuthor Commented:
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
0
mlmccCommented:
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
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

PHIL SawyerAuthor Commented:
Not sure what you mean "What happens if you don't save it first to your desktop"
Where should I save it to?
Regards
0
PHIL SawyerAuthor Commented:
I've found out what is happening - the parameters have gone to static and when I reset to Dynamic then all is fine - HMM!
0
mlmccCommented:
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
0
PHIL SawyerAuthor Commented:
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
0
mlmccCommented:
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
0
PHIL SawyerAuthor Commented:
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
0
mlmccCommented:
When you save a report the logon information is erased.  You could logon the MC and set the database credentials.

Is that a database logon prompt or enterprise logon?

You will have to logon the enterprise once.  From there any report that doesn't have the database logon information stored with it will require a database logon.


What database are you using?
Does it support Windows AD logons?
If so you could give all report developers logons to the database so they don't have to logon when they are working on reports.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PHIL SawyerAuthor Commented:
Its a database logon prompt and we are using Oracle 11g.
Your answers have been helpful and thankls for your time.
Regards
0
PHIL SawyerAuthor Commented:
Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.