Hello to all,
I am unable to view my PDF report via a web browser. The report is created from two joined tables.
The report works when viewed from the control panel side.
I am able to view a PDF report when using just one table.
I've tried two scenarios :
1. creating a set (two joined tables) then created the report from this set.
Chose blurb as my control type and in "properties ->after validate" I clicked insert button and chose genie->print report. I chose the report that I created, added a variable (session.userID) and in filter placed "user_ref= session.userid"
verified from the web browser and got an error message:
Errors in: event.AfterValidate code:
Amyuni Low Level Print:
Layout name: set@[PathAlias.ADB_Path]\<setname>.set
Layout type: report
Unable to connect to backend database while opening local cache <drive>:\<path>\<directory>\ from <filename>.dbf for table <table> from <database>.
Invalid syntax for connection string. Must be formatted in one of the following ways:
name1 + chr(9) + value1 + crlf() + name2 + chr(9) + value2 + crlf() ... or
{name1='value1',name2='value2'...nameN='valueN'}
2. (Instructions from the message board posts)
From the control panel->New-> <SQL Data Set> chose "Connection string name -> (radio button) Custom SQL select statement or stored procedure. From there I clicked on the query builder and selected the two tables and chose the required fields.
Errors in: event.AfterValidate code:
Amyuni Low Level Print:
Layout name: TEST@C:\A5Webroot\<directory>\<filename>.alb
Layout type: report
Error loading C:\A5Webroot\<directory>\cargonex.alb: The system cannot find the file specified.
C:\A5Webroot\<directory>\<filename>.alb
I am using Alpha Five v9
Please help.
Regards
I am unable to view my PDF report via a web browser. The report is created from two joined tables.
The report works when viewed from the control panel side.
I am able to view a PDF report when using just one table.
I've tried two scenarios :
1. creating a set (two joined tables) then created the report from this set.
Chose blurb as my control type and in "properties ->after validate" I clicked insert button and chose genie->print report. I chose the report that I created, added a variable (session.userID) and in filter placed "user_ref= session.userid"
verified from the web browser and got an error message:
Errors in: event.AfterValidate code:
Amyuni Low Level Print:
Layout name: set@[PathAlias.ADB_Path]\<setname>.set
Layout type: report
Unable to connect to backend database while opening local cache <drive>:\<path>\<directory>\ from <filename>.dbf for table <table> from <database>.
Invalid syntax for connection string. Must be formatted in one of the following ways:
name1 + chr(9) + value1 + crlf() + name2 + chr(9) + value2 + crlf() ... or
{name1='value1',name2='value2'...nameN='valueN'}
2. (Instructions from the message board posts)
From the control panel->New-> <SQL Data Set> chose "Connection string name -> (radio button) Custom SQL select statement or stored procedure. From there I clicked on the query builder and selected the two tables and chose the required fields.
Errors in: event.AfterValidate code:
Amyuni Low Level Print:
Layout name: TEST@C:\A5Webroot\<directory>\<filename>.alb
Layout type: report
Error loading C:\A5Webroot\<directory>\cargonex.alb: The system cannot find the file specified.
C:\A5Webroot\<directory>\<filename>.alb
I am using Alpha Five v9
Please help.
Regards
Comment