Monday, 20 April 2009
Crosstab Report Builder
For anything other than our standard, predefined sales reports, our users have relied on pivot tables in Excel from granular data outputs. This is fine, if a bit slow, for users that are familiar with them. Pivot tables can take a while master if you don't use them regularly so I wanted to make things easier for those who don't.
There are plenty of how-tos out there for a stored procedure in SQL server that will dynamically create a cross-tab report. I decided to replicate the basic approach in an ASP page for a custom sales report. I allow the users to select to column and row heading fields and fields to filter one. The next page asks for a date range, has drop down boxes with the possible values for the filters selected and the choice of web page or Excel output. The value field defaults to value but I will give the option of quantity as well as increasing the field options down the track.
There are plenty of how-tos out there for a stored procedure in SQL server that will dynamically create a cross-tab report. I decided to replicate the basic approach in an ASP page for a custom sales report. I allow the users to select to column and row heading fields and fields to filter one. The next page asks for a date range, has drop down boxes with the possible values for the filters selected and the choice of web page or Excel output. The value field defaults to value but I will give the option of quantity as well as increasing the field options down the track.
Labels: Work
# posted by Gareth Bezett @ 6:51 PM 
