Way to "tag" a report?

BradWare

New member
Local time
Today, 11:08
Joined
May 4, 2007
Messages
9
I'm curious to know if there is a way a report can be given a tag. What I'd like to do is isolate a group of report names and put them in a combo box...but I'd rather not individually type each name. If there is a way to give the reports I want a common tag then I could scoop them up more easily. Any suggestions?
 
Every object has a Tag property but you will have to use a VBA loop to test for it and build the record source query for the combo using the Name property of the reports whose tag propery matches.

Personally I would enter the report names in a table with a field value to group them. Multiple groupings are possible with multiple fields or you can have an unlimited number of groupings with a join table.

This way the appropriately enabled users can select the reports they want without pestering you to change the Tags or the VBA.
 
Last edited:
Expanding on Galaxiom's suggestion, here is an example of what I like to use:

Report Dialog
 
have a reports table

have a reporttitle, and actual report name

then you can get very flexible
 
And I use a method (sometimes) which I can pull every report into a combo to use if the name has a certain prefix. Then, I never have to modify a table or anything, I just have to name it the way I need when I want it to show up in the list.

See here for a sample.
 

Users who are viewing this thread

Back
Top Bottom