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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Existing Reports in CE 8.5 2

Status
Not open for further replies.

checkai

Programmer
Jan 17, 2003
1,629
US
I have reports uploaded to Crystal Enterprise. I want to just update them when I make changes to them in Reports. I don't want to have to delete the entire report and re-upload it. How can I do this?

Thanks,
Dustin
 
you can't. the only way you can do is update them in your local system and delete the existing one in CMC and promot to CE again.

Ted
 
Actually you can update your published reports in CE 8.5 from CR 8.5.
1. On the CE 8.5 disk, close the auto run dialog box, and navigate to E:\Updates\Crystal Reports\setup.exe.
2. Install the CR 8.5 patch, you may need to reboot after it is done.
3. Open Crystal Reports and go to File --> Open. In the dialog that appears, in the lower left will be "Enterprise Folders". Click on it and log into your CE APS.
4. Once in you can navigate to your report and open it. You can also overwrite exisitng reports and publish to CE by doing the same thing under File -- Save As.

-Brian
 
I have the Enterprise Folders Icon on the Open and Save dialog box, however after "logging on" to the APS it does nothing...not sure if i'm typing the aps server name wrong or using wrong name and password. Any Ideas?
Thanks Again
 
I have ran the update to CR and I'm still not able to log onto the APS...Is there a certain format for logging on to it?

Dustin
 
Since CR 8.5 was released before CE 8.5, the complete functionality could not be released with CR 8.5. If you don't install the update, the dialog box will close when you try and use the Enterprise folders button.

Even if you run the update but don't provide the correct logon credentials, you will get the same reaction as you did before loading the update. Make sure you enter the all the correct CE info.

"Logon using:" - I am using Enterprise security so I use "Enterprise"
"User Name:" - I use the "Administrator" account as I am the administrator. If you are not the administrator, your administrator will need to set you up with an account with appropriate privileges.
"Password:" - the password for your account.
"APS:" - the name of the APS that your CE system using. It defaults to the name of the server that CE was loaded on during the install but can be changes to something else.

Chances are that if you are not the administrator you may not have appropriate access to the system to make changes. I would talk with your CE administrator.

Good Luck

-Brian
 
I do have administrator rights. However, does Reports have to be being used on the server that Enterprise is on? Or can I do this from a regular user CPU?

Dustin
 
You can update it from the server or PC. The key is you have to install CR8.5 and CE8.5 update for CR8.5, like Brian mentioned.

There is one limitation on this route, you only can update the report one by one. I have a script(VB form)which can let you export / import bunch of reports templates from development environment to user testing, then to production. After refine it, I will share it out for free.

Ben
 
Sorry, Seems my answer is too brief. like above said, the way to update is have CR in CE server too, but I don't recommand to do that if you have your CE server is running for Production uses. It's not hard to update in your local test or development machine and then publish to CE system.

Ted
 
It is sort of cheating.. but I can't have the report number change because they have used it too many places in URL's for me to go mucking with it.

I do my updates in regular design mode, then save over the report on the server and use the refresh option to update the server. You have to reset the DB passwords and parameters (if you set them) but you don't have to redo security etc.

Lisa
 
Ben:

Have used the Crystal Publishing Wizard that comes on the CE cd? You can upload multiple reports at the same time and also change and set certain properties as well.

-Brian
 
Brian,

I havn't tried with the Crystal Publishing Wizard. Does it update the report templates as well as keep all the old instances?

I will have a look into it.

Thanks,
Ben
 
Ben:

The Publishing Wizard works well for adding multiple reports to CE for the first time. I have never used it to try and update existing reports. I have always updated the report template one at a time using CR to Save to CE. If your tool will allow multiple reports to be updated at the same time, I think it would be a time saver for me.

-Brian
 
lyanch !!

where on the server do you save your reports so that the report ID does not change???

THANKS

dustin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top