I finally got to work on this today, and I was able to take your suggestion and run with it. Since I already had the drop lists on the form and the code in place to dynamically alter the SQL created for the query, I just piggy-backed off of that to create the calculated fields. The report is...
Thanks for the info and code. But, I am not having a problem dynamically changing the sorting on the query. For some reason (unknown to me), the sorting on the query does not carry over to the report. In the past, I have had to set the sort/group properties in report design mode to get the...
I have a report that is fed by a query. The SQL for the query is created/modified by the choices made on a form by the user. Some of these choices are for sorting. My problem is that I cannot find a way to instantiate the report in order to access the Order By & Order By On properties of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.