List all reports in Db

  • Thread starter Thread starter Swarfmaker
  • Start date Start date
S

Swarfmaker

I would like users to be able to pick report to print from a list/combo box
on a form.
Anyone got the code for this please?

Iain
 
I prefer to just create a small table of report names, their friendly name,
and a couple other attributes. My actual report names aren't for human
consumption. They are like rptEmployeeJobHours or srptLaborHrs.

Querying the msysobjects table may work for your application but I wouldn't
expect users to see the subreports and the actual object names. My
ztblReports contains status, author, create date, title, reportname, and
description fields.
 
I prefer to just create a small table of report names, their friendly name,
and a couple other attributes. My actual report names aren't for human
consumption. They are like rptEmployeeJobHours or srptLaborHrs.

Querying the msysobjects table may work for your application but I wouldn't
expect users to see the subreports and the actual object names. My
ztblReports contains status, author, create date, title, reportname, and
description fields.
 
Back
Top