report data
Hello,
I have a little problem. I want to create a report with following tabledata:
ID name hours date dept floor
1 Marc 5 12.12.2009 NY 2
2 Marc 5 12.12.2009 NY 3
3 Carl 6 13.12.2009 CA 2
4 Carl 6 13.12.2009 CA 3
In the report i want to have the following structure
1 band with the hours of each name
Marc 5 12.12.2009
Carl 6 13.12.2009
and another band with the floor from the name
marc 2
carl 3
How i can handle that in one report? The software using FastReport can only given one result table as source for building a report... thats urgh grml...
The real problem is to combine two tables to build a needed resulttable
I can only iterate all data or a given nummer...
also i want the sum of both hours 5+6 but i get only all hours 5+5+6+6 from all the table.
I have a little problem. I want to create a report with following tabledata:
ID name hours date dept floor
1 Marc 5 12.12.2009 NY 2
2 Marc 5 12.12.2009 NY 3
3 Carl 6 13.12.2009 CA 2
4 Carl 6 13.12.2009 CA 3
In the report i want to have the following structure
1 band with the hours of each name
Marc 5 12.12.2009
Carl 6 13.12.2009
and another band with the floor from the name
marc 2
carl 3
How i can handle that in one report? The software using FastReport can only given one result table as source for building a report... thats urgh grml...
The real problem is to combine two tables to build a needed resulttable
I can only iterate all data or a given nummer...
also i want the sum of both hours 5+6 but i get only all hours 5+5+6+6 from all the table.