report data

edited 11:42PM in FastReport 4.0
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.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.