Radicore Forum: Transaction Patterns » output2 with parent/child tables

Home » RADICORE development » Transaction Patterns » output2 with parent/child tables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: output2 with parent/child tables [message #4594 is a reply to message #4592]

Tue, 14 October 2014 11:48

htManager
Messages: 439
Registered: May 2014

Senior Member

Sorry, but I didn't succeed.

(1) I looked at your example in option_list(a).php and changed my $sql_select statement as discribed below:

$sql_select = 'CONCAT(vereine_kuerzel, \' \', mannschaften_id) AS mannschaft_name';

In the report I changed the entry in:

$structure['title'][] = array('text' => '%%mannschaft_name', 'width' => 15, 'align' => 'left', 'x' => 25, 'y' => 0);

But there is no output. What did I wrong?

(2) Can I get a field value of the parent table within the above sql_select statement? I want to show a logo image file in the child report title. But the file name is stored in the parent table. I think that this should work with outer/inner join in a way as you showed in option_list(a).php. Did you somewhere describe this problems in one of your documentation? Or can you tell me what SQL-expression I should looking for to get information how to handle it?

Once more, thanks for your patience!

Report message to a moderator

[Message index]

		output2 with parent/child tables By: htManager on Thu, 02 October 2014 06:11
		Re: output2 with parent/child tables By: AJM on Sun, 05 October 2014 05:13
		Re: output2 with parent/child tables By: htManager on Mon, 13 October 2014 11:37
		Re: output2 with parent/child tables By: AJM on Tue, 14 October 2014 06:00
		Re: output2 with parent/child tables By: htManager on Tue, 14 October 2014 08:55
		Re: output2 with parent/child tables By: htManager on Tue, 14 October 2014 11:48
		Re: output2 with parent/child tables By: AJM on Tue, 14 October 2014 18:03
		Re: output2 with parent/child tables By: htManager on Wed, 15 October 2014 11:16

Previous Topic:	Error running output2 pattern
Next Topic:	Different Categories

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Dec 12 16:47:54 EST 2024

Total time taken to generate the page: 0.00981 seconds