User defined Queries/Reports

[Stoffman]

I am trying to set up a form which allows the user to create there own report by choosing the field name they require to see and to add in there own criteria. I have managed to run the query and display the report using the users criteria, however does anyone know a way to show the results minus the field names that the user does not require to see.

I have used the [Reports]![Report.name]![Field].[Visible]=0 in an IIf statement. However it just leaves gaps in the report everywhere. I need something that redesigns the report dependent on the fields that the user has choosen. Is this Possible? Is there a better way of doing this?

Thanks in advance

 

[Crowley16]

you can't redesign a report dynamically, well you can but it's not easy...

you can try to use the canShrink property to get your controls to minimise when there's no data, or you can use vba code to set the width of a control, and move the other conrols based on the value of whatever...

--------------------
Procrastinate Now!

 

[Stoffman]

OK, Cheers, I think I will have to revisit the requirements then.