Session or global vars in reports

[fra81]

Hi, is possible in some way to use session or global var in report? Example inserting the user id currently logged in a query (when embedding in a third application).

Thank you

[davidmichaelakers]

I created something that will do this. #230

[fra81]

Ok, thanks it works!
I notice that if the DYNAMIC is set before the first VARIABLE (in fact as first item after the title etc) in the .sql report, I get this error

PHP Fatal error: Uncaught exception 'Exception' with message 'Unknown header 'VARIABLE' - xx/xyz.sql' in lib\PhpReports\Report.php:232
Stack trace:
#0 classes\headers\DynamicHeader.php(36): Report->parseHeader('VARIABLE', Array)
#1 lib\PhpReports\HeaderBase.php(31): DynamicHeader::init(Array, Object(Report))
#2 lib\PhpReports\Report.php(228): HeaderBase::parse('Dynamic', '{\nfile: "tg_glo...', Object(Report))
#3 lib\PhpReports\Report.php(190): Report->parseHeader('Dynamic', '{\nfile: "tg_glo...')
#4 lib\PhpReports\Report.php(47): Report->parseHeaders()
#5 lib\PhpReports\PhpReports.php(389): Report->__construct('xxx/xyz...')
#6 lib\PhpRepor in lib\PhpReports\Report.php on line 232