Update published report

[Sandra456]

I have CE 9 standard installed and call reports through a URL on our Web portal. I did some format changes on the rpt file. How do I get the published report to pick up the changes? I know I can republish the report and it will pick up the changes, but then it will give it a new id so I will have to change the URL. Is there a way to get the report to pick up the new changes without generating a new id number?

 

[TedLiu]

You can use report name to get id, that's what I'm using now.

Set cReports = oIStore.Query("Select * From CI_INFOOBJECTS Where SI_NAME='" & ReportName & "' AND SI_PROGID='CrystalEnterprise.Report' AND SI_PARENT_FOLDER='" & FolderID & "'&quot


Hope it helps.

Ted

 

[SurfingGecko]

If you woudl prefer a nice simple approach, why not simply open the report directly from the Enterprise fodler structure using CR itself.

If you choose File > Open you should notice an icon for Enteprise folders. If you are running the version of CR that shipped with CE, then you should be able to log into the APS, browse for the report and open it.

When you save this report, it will maintian the ID and be updated. No more work needed.

The other approach, would be to open the version of the report being stored in teh Input FileStore, then resave without renaming it. Then in the CMC Report properties, choose to refresh the report. This will pull in any related changes (db, parameters etc.) and restore them in the system database. This can be a bit more of a hassle than the first option I pose above.



Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease

 

[Sandra456]

Thanks - I got both approaches to work.

 

[SurfingGecko]

Thanks for letting us know

Cheers,

SurfingGecko

http://www.surfinggeckosoftware.com

Home of Crystal Ease