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)
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).