Report page summary line insert

Is it possible to add a custom field from another table to the global or any other summary field row of a report page?

if any of the field value added in this area usually fetch a blank record in the place.

I'm not 100% sure on what you're asking but you could try changing the sql query by using a JOIN or use an select statement.
Table1 is the main table and table2 would be like a lookup table which contains the custom field(details), option_id would relate to the id from table2.



SELECT

id,

field_name,

option_id,

IFNULL((SELECT detail FROM table2 WHERE id=option_id),'No Record') AS option_name,

balance

FROM table1


Dear Kujox, thanks for the reply,

In fact I'm looking for adding any of the Available or a separate field through join in the area in which the summary information is appearing. Normally if you are adding any existing field in the place where summary is row is present after building this will not show up.

This is in for the use of making a report specific template with some functionality.

Please se the picture attached

Where I have mentioned the static area I would like to make a field from same table or through join to appear.

On the top static area it is somewhat successful but below it was not. Is there any possibility?
regards

Smith

I'm not 100% sure on what you're asking but you could try changing the sql query by using a JOIN or use an select statement.
Table1 is the main table and table2 would be like a lookup table which contains the custom field(details), option_id would relate to the id from table2.



SELECT

id,

field_name,

option_id,

IFNULL((SELECT detail FROM table2 WHERE id=option_id),'No Record') AS option_name,

balance

FROM table1