As most users of Datadynamic's Activereports .NET 2.0 product will know, it simply doesnt support crosstabs. ([url removed, login to view])
The only way to get crosstabs onto a form is by dynamically adding the appropriate fields to the report, and generating the SQL queries by hand.
So here is what I need :-
1) A winform (in [url removed, login to view]) that allows the user to specify one(1) column field , and one (1) row field. Then it should allow the user to specify the field for the contents of the crosstab (together with summation/count/etc functionality). This winform is quite easy to do : just a few dropdown lists for the user to select the desired fields for crosstab col,row and content.
2) Now, based on the user's selections, we have to now dynamically create the crosstab table in Activereports. This is possible through the use of Activereport's object. Its something like :
[url removed, login to view] (fieldtype,name,caption, location, width,height)
For this crosstab, you must manually write code to arrange it in a tabular fashion (layout of fields).
3) Then we have to manually add code to the report to set the appropriate SQL queries (based on the user's selections)
That's it. Then when I run this report , I should be able to see my crosstab with data arranged appropriately.
The project delivery date : 7 april 2006. (delivery date is fixed and non-extendable). We'll have certain miletones along the way
If you are sure you can do this, please submit your bid asap! Thanks!