Dynamic Report

[Alain]

Hi to all ,

I need to build a report that the content will changed based on criteria
from the end user, There can be up to 7 different criteria (combo box and
checkbox).
I would like to know which is the best way and most efficient way to assign
the criteria to the report.
Would it be by modifying the report RecordSource at the open event of the
report with a new or modified query or use the WhereCondition of the
OpenReport command to add or modify the main query used for the report

Thanks for your input

Alain

 

[Guest]

The way you are describing it, the most efficient would be send the
whereCondition clause in the openreport based on the fields selected by your
user, I'm thinking the user can select one or more of your 7 text/combo
boxes, before openning the report identify which ones were selected and build
the whereCondition clause,