View Single Post
Old March 26th, 2008, 10:16 PM
hajjara hajjara is offline
Registered User
Join Date: Mar 2008
Location: , , USA.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Report from Query

Summary: the user is able to control (include or exclude in the output) 35 checkbox / fields in the query. Currently output is going to an excel sheet. Goal create a dynamic changing report.

Dear All,
This is a bit complicated but I hope that you would be able to help me out.
I have created a query off a linked table (from AS/400). This query has several fields that are controlled from a form using checkboxs, where if the check box is checked then the field will show up in the sql statement if not then then sql will run without that field. Currently I'm having the spreadsheet output to an excel sheet.
But what I'm looking (which is my optimum goal) to have a report based on that query that would dynamically include whatever fields are checked and remove whatever not checked.
Now I thought about this and I'm thinking of creating a report based on the query that would include ALL the fields then I insert some code that should be run- when the report is activated or being populated - that would go and check all the check boxes then what ever is not checked then the code will make the attribute of that field in the report of Visible as false thus removing it from the report...
Is my solution possible? is there such a code that would be created? I would appreciate if you can help me out with this...

Any idea/opinion is greatly appreciated...
Thank you,