2. PHPRunner General questions
  3. Report with Several areas
This topic is locked

Report with Several areas

 		11/13/2007 05:55:52
PHPRunner General questions
W
 webdino author

How can I create a report with PHP Runner where several areas where Displayed?
For example:
area1 (select from table1)

1 text1 Quantity

2 text1 Quantity
area2 (select from table2)

1 text2 Quantity

2 text2 Quantity
area3 (select from table3)

1 text3 Quantity

2 text3 Quantity
and so on.....
Alexey admin 11/13/2007

Hi,
try to combine data from multiple tables in a single SQL in a single query using UNION ALL clause.
I.e.

select text,quantity from

(

select text,quantity from area1

union all

select text,quantity from area2

union all

select text,quantity from area3

)
W
 		webdino author 11/13/2007

Hi,

try to combine data from multiple tables in a single SQL in a single query using UNION ALL clause.
I.e.


that ist a good idea but how can i put the headlines on the Report?
Alexey admin 11/13/2007

What are the headlines you talking about ?
W
 		webdino author 11/13/2007

What are the headlines you talking about ?


I want to show a report with several Divisions

for example:
Revenue Kategory Book1

Data1 01.01.2007 +20 €

Data2 02.01.2007 +30 €

.........
Revenue Kategory Book2

Data1 01.01.2007 +20 €

Data2 02.01.2007 +30 €

.........
Editions Kategory Book1

Data1 01.01.2007 -20 €

Data2 31.01.2007 -20 €

......
Editions Kategory Book2

Data1 01.01.2007 -10 €

Data2 31.01.2007 - 5 €

......
------------------------------------------------

summary +45 €