Sorry, I should have clarified early. For the SQL view above, let’s called this qry #2 and within the process qry #2 uses qry #1. Qry #2 is based over qry #1 and a second table. The report uses qry #2 to produce the final output. The grouping is performed in qry#2 only.
Hi All,
I have a user which is complaining about the above error inconsistently when trying to key in start and end date parameters to generate a report. The date range can be for a month, three months or a 6 month span. Sometimes the report will run successfully and sometimes not. Here...
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.