2. PHPRunner General questions
  3. custom link in report page
This topic is locked

custom link in report page

 		10/5/2011 8:47:06 AM
PHPRunner General questions
G
 giorgiots author

Hi all,
I was wondering if it is possible to show the details page link (popup view) in my masters Report. For example:
Master table tbl_master
id

subject

...
Detail Table

id_det

id_mast (foreign key from master table

...
I have created the relationship between the master table and the detail table so that the latter is showing in the list page of the master.

Can i do that somehow in the report of the master table as well? ( i guess i have to get the id value from the report...)
Thanks in advance
Giorgio
C
 		cgphp 10/5/2011

You can't create a link relation between a report and a detail table.
G
 		giorgiots author 10/8/2011

Well I didn't get to show the popup view but I managed to create a link to the details page. This is how:
Insert a PHP snippet in the report and use the following code :
global $conn;

$_REQUEST["value11"];
$keys=$_REQUEST["value11"];

$url="tbl_detail_list.php?mastertable=tbl_master_out&masterkey1=";

$url2="link to detail";

$url3=$url. $keys;

Echo "<a href=$url3>$url2</a>"