Reading the variable works very simply with the query on the secondary table. And I was able to define the variable by concatenating a hyperlink. However, I was not able to succeed using the column setting fields at all...I just created a link via the query. See below to tell me if my way is flawed, and if I should work out the column settings way that you are trying to explain to me.

Is there a way to hide the variables in the browser? I don't like the user being able to see that info and "guess" at other document numbers.

Here's how I"m linking to the secondary table:
SELECT OrderDate AS 'Ordered On', `Document` AS 'Document', CONCAT( '<a href="index.php?option=com_content&view=article&id=138&currentPo=',`Document`,'">', `PONum`, '</a>' ) AS 'PO #', Shipto as 'Ship To', Shipdate as 'Ship Date', cancel as 'Cancel Date', CONCAT( '$', `total` ) AS 'Total Amount'
FROM `openorders`
WHERE UserID = {$UserLogin}

Your way is correct too. It is not possible to hide GET request variables from an URL because they can send only in URL.

Regards,
ARI Soft

i followed these steps in order to connect to the other report.


i got this result- 202.65.131.44/CMS/
if you see under the field 'customercode' you will see the path to the link but i need that link to be clickable

Please help me out here

Set "Columns settings -> ID" parameter to CustomerCode value and the following value for "Columns settings -> Format" parameter:

<a href="{$value}">Customer code</a>

Regards,
ARI Soft

After what you mentioned i see customer code in hyperlink but i want the values of Customer code there with hyperlink. And also where do i have to paste the article id where my secondary table is embedded?

Use {$columns:CustomerCode} variable to add code to link.

Regards,
ARI Soft