View Full Version : Print Preview Reports/Graphs based on combo box selection


artb
07-03-2008, 12:59 AM
Hi,

I have a form with combo boxes, various option groups and one print button. The option groups I don't have a problem with, it is in the combo box.

I want to print the proper report/graph based on a selection via combo box. any help would be greatly appreciated.

art

boblarson
07-03-2008, 01:15 AM
Perhaps this sample will help:
http://downloads.btabdevelopment.com/Samples/combos/FormSampleFromMultipleCriteria.zip

artb
07-03-2008, 01:25 AM
Thanks Bob for the quick help. My issue is that I have many (about 7 different reports) reports. And depending on what the user chooses on the combo box will determined what type of report is previewed. I hope this sorta clarifies my dilema. Thanks.

Ab

boblarson
07-03-2008, 02:07 AM
What determines which report it is that you want? In other words, what selection in the combo makes it so this particular report should be opened? We need to have that type of information to give you a more fitting answer for your situation.

artb
07-03-2008, 06:46 AM
Sorry for my ignorance Bob but yes, that is exactly what i am looking for. So if Report1 was selected from the comb box, then Report1 with its data on graph is generated. If Report2 was selected from the combo box then Report2 with its data on graph is generated. Thanks again.

art

boblarson
07-03-2008, 09:26 AM
Sorry for my ignorance Bob but yes, that is exactly what i am looking for. So if Report1 was selected from the comb box, then Report1 with its data on graph is generated. If Report2 was selected from the combo box then Report2 with its data on graph is generated. Thanks again.

art
Here's another sample of mine that might help:
http://downloads.btabdevelopment.com/Samples/listbox/SampleSelectReportFromForm.zip

This allows you to dynamically list all reports in your database (provided you prefix the name with rpt_. I do it that way so if I have reports I'm testing or ones that aren't a full report (used as subreports) they don't show up in the list. But, I never have to add a new report to the list as it shows up automatically if I name it right.

artb
07-03-2008, 09:36 AM
Bob I think this is the ticket - "where do I send in the royalties". Thank you very much. I will post the outcome.

art