Cross-tab wizard

[sproket]

Hello all!____I^d like to see a cross-tab wizard like in Crystal. But NOT the way Crystal does it!____Crystal creates a cross-tab "object" which has limited usefulness.____You should simply create a normal report and create all the calc fields required. Then the user could add whatever else they needed.____In both Crystal and R&R cross-tabs are somewhat difficult to do.

[Michael_Hoffmann_(Guest)]

Hi Sproket,____I^ve written some functions to linearize cross-tabs. You can choose the fields you want to be linearized (e.g. a, b c) and the number of columns you intend to print (e.g. 3). These functions then create an intermediate file containing all the requested fields in an indexed way, e.g. a1, b1, c1, a2, b2, c2, a3, b3, c3. And an extra DBF file is created for the column headings.____These functions work with Clipper 5.x and Xbase++ 1.3 and up.____Interested?____Michael____m.hoffmann@compar.cc____

[taylorjm]

I agree with the need for R&R to easily create crosstabs. Currently I export to Excel or use Reporter, an old Clipper-based program that creates excellent two-way tabs. Its still available from Joe Booth consulting and does a particularly nice job with dates.

[Fastest Payday Loan]

We^ve started work on a cross-tab wizard. It^ll be a separate program that can be substituted for the general wizard. As requested, it will be designed to build the report within the normal R&R methodology: calcs, totals, groups, etc. No release date as of yet, but expect by end of year.