I need to develop a reporting application.

I need to develop a reporting application. In the past I have worked with Crystal Reports and then QuickReports. Since upgrading to RadStudio 10, neither of these options work any longer. I was just wondering what anyone would suggest to accomplish a task like this (in grossly simplified terms):

I have sales data which contains Date,IDnumber, SalesAmount.

Sample data:
2017/01/01,001.$100.00
2017/01/01,002,$50.00
2017/01/01,003,$120.00
2017/01/02,001.$110.00
2017/01/02,002,$51.00
2017/01/02,003,$125.00


I need to generate a report that shows Sales for Monday-Friday (one column per day), A weekly total (calculated) and a total of the same date range the previous year.

Basically:
ID Mon Tue Wed Thu Fri Sat Sun WeeklyTotal LastYearTotal
001 $100 $110 $0 $0 $0 $0 $0 $210 $200
002 $110 $51 $0 $0 $0 $0 $0 $161 $157
...


This sort of thing could have been done using a crosstab in Crystal, but Crystal and Delphi no longer talk to one another... I was just wondering what other people are using for reporting and how they would go about accomplishing this task? My apologies if my brevity makes this more confusing than it needs to be.

Comments