Crosstab functionality in Datadynamic's activereports product (428821)

Hi, As most users of Datadynamic's Activereports .NET 2.0 product will know, it simply doesnt support crosstabs. ([login to view URL]) 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 VB.NET) 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 : [login to view URL] (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! Regards Ed ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform Windows XP or later