Hi,
I have an application that uses reports. While some of the reports need to show all the data, I want to filter other reports based on various criteria. I have noticed that in the Events area of the application, there is no Before SQL Query event for the report page, only the printer-friendly page. However, event when I use a line of code in the Print page: Before SQL query event, all the report results still appear on both the report page and the printer page.
The security settings will allow me to limit report results that way, but I need to be able to use code like
strWhereClause = whereAdd(strWhereClause,"FiscalYear = 5")
but it doesn't seem to work.
Any help appreciated.
Thanks,
McCree
