Finding viewrpt.cwr ID within Crystal 1

[beltmanjr]

Does anyone know how to get the ID needed for the viewrpt.cwr command from within Crystal itself? I've read a lot about the SDK, but simply need the report to tell me this ID for further use.

Thanks!

 

[hilfy]

The report can't tell you that. There is no way to access the ID from within the report itself.

I assume you're using Crystal Enterprise (CE) rather than BusinessObjects (BO). I'm not sure how to do this in CE, but in BO I would log in to the Central Management Console, navigate to the report and look at it's properties to get the ID number.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[beltmanjr]

Hi there,
thanks for the reply. Would there be any way of getting this out of a database where BO Enterprise stores information about its objects?

 

[Turkbear]

Hi,
Yes - The QueryBuilder tool from BOE's administrators page can return that ID if given a name or folder



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[hilfy]

I believe this is either the SI_ID value or the SI_CUID value for the report.

You would need to use the SDK to connect to the database to get this. So, you CANNOT connect to it from the report itself. BO stores it's data in a proprietary binary format that can't be read unless you're using the SDK.

From an application you would run something like the following against an InfoStore object:

Select SI_ID, SI_CUID
From CI_INFOOBJECTS
Where SI_NAME = 'My Report'

This returns an array of InfoObjects. You'll take the first one and use either the ID or CUID property to get the data you need.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[beltmanjr]

Hi Hilfy,
great suggestion of using the SDK. I've never done so before, but am using Java anyway in the report so this should be possible to fix!

Cheers
JR