List all reports in Db

[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

 

[Allen Browne]

See:
List Box of Available Reports
at:
http://allenbrowne.com/ser-19.html

The first approach is easier.

 

[Swarfmaker]

Many thanks Allen

Iain

See:
List Box of Available Reports
at:
http://allenbrowne.com/ser-19.html

The first approach is easier.

 

[Duane Hookom]

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.