This topic is locked
[SOLVED]

 parameter to call a report from list page

8/7/2012 8:06:52 AM
PHPRunner General questions
A
alserrao author

Hi.
I want to put a button or link in each line from a list page and direct the page to a report passing the necessary id (id_prj = project id).
As I have the ID in the line of the record I dont' need to call the "search dialog" to select the record to be used in the report and I can jump this selection phase.
My questions:

  1. What program do I need to call: table_report_report, table_report_search, table_report_print ?
  2. What is the parameter's name I need to pass to the report program (editid1,...) ?
    Regards.

A
alserrao author 8/8/2012

My PHPR is 6.1 !
I've tested some events and programs and now I kown the program I need to call is table_report.php. It's ok.
The next step is how to change the $gsqlWhereExpr in the event After Table Init. All my tests failled!
It seems all my changes doesn't take effect at the original table query and the result set has all records instead the one I want.

A
alserrao author 8/8/2012

The problem was solved using "BEFORE SQL" event instead "after table init" !