LO Version: 4.4.3.2 & MAC OSX 10.10.4
I have designed a form interface to a selection of BASE reports like this:
and with this forum’s help have been able to get the form’s selection options to function.
What I want to be able to do, having generated with a macro a suitable query that replicates the users reporting options,
is to edit and change the query to the basic EXISTING designed report so that when I open it with
DoCmd.OpenReport “myExistingReportName”,2
the users reporting options e.g. Sorted in reverse chronological order, filtered between dates Date1 and Date2 will be executed.
By way of example you can do this with a form and pass a query and filter by way of arguments on the open statement.
I’d like some way of replacing that functionality with a report.
The alternative is to have 36 ( = 2 (sort) x 2 (ordered) x3 (content) x3 (filter options) ) SLIGHTLY DIFFERENT pre-designed reports which seems excessive and wasteful.
BTW
-
I know I can make the existing queries for the pre-designed reports somewhat dynamic by having parameterised queries for the Date filtering.
-
I’d be happy to have 3 reports (one for each of the different contents) so long as I could pass AT RUNTIME
a generated query from the users selection.
What I’m asking for is the get/set macros to the internal PROPERTIES, & CONTROLS (which are hidden unlike a form) of a predesigned report; in particular it’s
- query
- sort order
- heading
- labels
so that my reports can be truly dynamic and responsive to the user demands.