OpenReport method and Group & Sorting

[stoka]

I have a form to input date range, detail or summary report wanted, one person or entire list with combo box to select the person, sort by name or date, and whether to show sub-totals or not for the major sort. I have a command button that when clicked launches the report. In the VB code is use an IF statement to decide whether to use the Detail or Summary report. I will try to use an entry in the OpenReport method to send the SQL Wherecondition statment ( without the Where), and have had help on how to set up a grouping using the Me.Grouplevel(0).ControlSource= xxxx where i think xxxx is either "Name" or "Date" based on the selection used by the user. However i am not sure how or if i can use code to tell this report whether or not to print the sub-totals on the group break...I guess i would have the report set to print the sub-totals and use some property of that section to tell it whether to print or not ?

 

[pbaldy]

You can set sections and/or controls to visible or not, as required. I do this with summary vs detail reports. Rather than have 2 different reports, I set the detail section's visible property to false if the user has selected summary.