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

Report Summary Info

Status
Not open for further replies.

scriptscroll

IS-IT--Management
Feb 26, 2002
5
CA
My Web form displays a listing of reports to select from, with the associated image I wish to display the Report File Info, such as Comments, Author, ect. I can achieve this by opening each report and getting the properties, but this is really slow. There must be a 'better' way to "preview" the Report Summary Info from the Report Object?

For Example:

Set clientDoc = objectFactory.CreateObject "CrystalClientDoc.ReportClientDocument")
clientDoc.open theReportName

If clientDoc.summaryinfo.title = "" Then
EncapComment = "There is no Summary Information for this Report."
Else
EncapComment = "TITLE :" & vbTab & clientDoc.summaryinfo.title & vbCrLf &
"AUTHOR :" & vbTab & clientDoc.summaryinfo.author &
vbCrLf & _
"KEYWORDS :" & vbTab & clientDoc.summaryinfo.keywords & vbCRLf & "COMMENTS :" & vbTab & clientDoc.summaryinfo.comments

End if
 
If speed is an issue, have you thought of running a routine to compile this information into a database table. If your report list is not very dynamic (i.e., you're not adding or dropping reports frequently), you could create a table that stores all the report summary info, and then query the database table rather than open each report via the RDC at runtime. Just a thought..
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top