Get crystal report file 'Title' 1

[Keyth]

Hi everybody

I want to be able to get the report title from a crystal report file so that I can add the title as a ListBox Item. The user can then pick the report by title and run it.

Does anybody know how to get the title from the rpt document properties/report summary info?

I have posted this thread in this forum because vb.net users will know more about what I am wanting to do, than what Crystal Report users will.

Thanks,

Keyth

 

[pmegan]

All you have to do is load the report and go into the summary info.

Import the crystal reports engine if you haven't already.

[green]
'If your report templates are compiled into your code, create an instance of one:[/green]

Dim strTitle as string
Dim oRpt as new [i]YourReportName[/i]
[green]
'If you're using standalone files, create a report document and load a report:[/green]

Dim oRpt as new ReportDocument
oRpt.Load("[i]ReportPathAndName[/i]")

[green]'Now just go into the summary info[/green]

strTitle = oRpt.SummaryInfo.ReportTitle()

messageBox.Show(strTitle)

 

[Keyth]

Thats great thanks, I will give it a shot.

Seems a long winded way just to get the info required, for each file in a folder load the report, get the summary info and then close/dispose of the report and move onto the next file.

If its the only way then I will have a look at it.

Thanks pmegan

 

[Keyth]

It works but its slow. I think the first time you initiate the engine it takes a while but once you have the engine running, its a lot quicker!

Any ideas on how you can warm up the engine to speed up the process??

Thanks, Keyth

 

[jebenson]

Perhaps you could save the report titles, filenames, sizes and last modified dates in a text file or a database. Then when you need to populate your listbox you can do a quick scan of the folder with the System.IO methods, and if there are any new files or any of the files have changed, process only the new/changed files with the report engine.

Just an idea I thought I'd throw out there, I'm not sure how well it will work.



I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!

 

[Keyth]

Thanks for all your replies.

Keyth