Obtaining a report's ReportFileName

[bluecjh]

Ent V10.

I am trying to get a reports file path
something along the lines of:

set rReports = ceInfoStore.Query("SELECT si_files FROM CI_INFOOBJECTS WHERE SI_PROGID ='CrystalEnterprise.Report'")

NoOfReports = rReports.count
For i = 1 to NoOfReports
response.write rReports.item(i).ReportFileName
Next

but this property doesn't exist
can someone help? Thanks


Chris

 

[mdwyer]

rReports.item(i).Title will give you the filename (unless you changed it in the CMC).

To get the path:

Include SI_FILES in your query, e.g.,

SELECT [b]SI_FILES[/b], SI_ID, SI_DESCRIPTION, SI_PARENT_FOLDER FROM CI_INFOOBJECTS

(You did that. But someone else may read this later.)

Write rReports.item(i).Files(1).Name

Your result will look like frs://Input/a_116/001/000/372/~ceee433e4eee3932e.rpt
which is "The full path and filename of the report, where it is stored in the File Repository Server."

Also: "Some InfoObjects have one or more associated files; for example, a Report object always has a corresponding .rpt file. It may also have an associated .jpeg or .gif file." These would be an higher-numbered index in the Files container, e.g., .Files(2).Name.

 

[bluecjh]

Well the ce_sdk help is rather ambiguous, but thanks for
that.

I was trying to see what was in this property
which you have answered too, the repository path.

Is there a way too get the original report path?

thanks mdwyer.

Chris

 

[KingfisherINC]

In versions prior to v9 there was a property SI_LOCAL_FILEPATH. It was removed in v9 and v10, but is back in XI - Don't ask me why.

AFAIK there is no way to get that info in v10.

Kingfisher [CECP]

 

[bluecjh]

Thanks KingfisherINC,
we are in the process of installing
xi I will check this out.

Chris

 

[bluecjh]

KingfisherINC,
against xi i tried

set rReports = ceInfoStore.Query("SELECT SI_LOCAL_FILEPATH FROM CI_INFOOBJECTS WHERE SI_PROGID ='CrystalEnterprise.Report'") -this worked

what would the syntax be to return this value?

response.write rReports.item(i).????

many thanks

Chris

 

[bluecjh]

Got there
cheers

Chris