2. PHPRunner General questions
  3. [SOLVED] Report page: Before SQL query
This topic is locked
[SOLVED]

Report page: Before SQL query

 		12/5/2023 09:03:28
PHPRunner General questions
P
 PK author

Hello,
It seems report page has no Before SQL query event.

img alt

So how can I filter the report data using user selected variable?

Regards
Percy
Sergey Kornilov admin 12/7/2023

Here is the recommended way to filter data from your code:
https://xlinesoft.com/phprunner/docs/dynamic_sql_query.htm
P
 		PK author 12/7/2023

Thank you but the solution recommends using After Table Initialized. But Report has not got this event.
Thanks
Percy
Sergey Kornilov admin 12/7/2023

This event is right on your screenshot.