My goal is to pass a dynamic filter variable to a report via a URL.
One solution that is presented uses the ZOHO_CRITERIA parameter. Apparently, this solution will work but will not provide real time results - delays of at least one hour are documented in the linked thread. Unfortunately, delayed results will not work for my application.
The other solution that is documented describes how to set the criteria for the view that the report uses. This works for me when the criteria is "hard-coded" into the view definition (script). Of course this doesn't solve my problem. I also know how to pass criteria to a view via a URL but can't see how to do this and then run a report embedded in an HTML view that reads the filtered view in one script. Is this possible?
If there is no way to filter a report dynamically and in real-time, are there any plans to implement such functionality in the future? It seems to me that this would be a useful and important capability for Creator.
As always, thanks in advance for your help.
John