How to do the report ?

pele

I have data in dateset in that format:

person1 | data1 | value
person1 | data2 | value
person1 | data3 | value
person2 | data1 | value
person2 | data2 | value
person3 | data2 | value
person3 | data3 | value

And I want to print the data in that format:

person | data1 | data2 | data3  | sum
person1| value | value | value  | sum(values person1)
person2| value | value | value  | sum(values person2)
person3| value | value | value  | sum(values person3)

How can I make the report in simples way ?

gpi

Try to use TfrxDBCrossView object

r01mustofa

pele wrote: »

I have data in dateset in that format:

person1 | data1 | value
person1 | data2 | value
person1 | data3 | value
person2 | data1 | value
person2 | data2 | value
person3 | data2 | value
person3 | data3 | value

And I want to print the data in that format:

person | data1 | data2 | data3  | sum
person1| value | value | value  | sum(values person1)
person2| value | value | value  | sum(values person2)
person3| value | value | value  | sum(values person3)

How can I make the report in simples way ?

hi..
Please Read FR4 User Manual - Croos-Tab chapter and read/execute Demo/Example of FastReport ....It's very simple using fastreport...or you can generate it completely from query... usually using stored procedure and it is full complexity...

boky

If you are looking for better xml reporting software, please take a look at Windward's Xml Reports. With Windward you design reports in Microsoft Word, Excel, or PowerPoint so report design is a lot faster and easier - and non-programmers can design reports.

gpi

boky
Does Windward's Xml Reports support Delphi?