View Full Version : Way to "tag" a report?


BradWare
01-20-2010, 08:37 PM
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?

Galaxiom
01-20-2010, 09:40 PM
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.

HiTechCoach
01-21-2010, 12:59 AM
Expanding on Galaxiom's suggestion, here is an example of what I like to use:

Report Dialog (http://www.hitechcoach.com/index.php?option=com_docman&task=doc_details&gid=9&Itemid=28)

BradWare
01-21-2010, 06:36 AM
Thanks for the tips.

gemma-the-husky
01-21-2010, 07:07 AM
have a reports table

have a reporttitle, and actual report name

then you can get very flexible

boblarson
01-21-2010, 07:26 AM
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 (http://downloads.btabdevelopment.com/Samples/listbox/SampleSelectReportFromForm.zip).