General information
Category:
Reports & Report designer
>>Is there any report driver or format to print out a crosstab with a variable number of columns and variable number of rows? I also need to be able to print two columns of data (count and amount) for each column. I can generate the data for the report using a couple of views, but can't figure out how to print it. I am using VFP 6. I tried the Pivot Table, but that was too flaky (crashed repeatedly at different points and locked my Win98 system). Any suggestions???
>
>You can always transform the final cursor to some uniformed way using ALTER TABLE command to ADD/DROP/RENAME columns so report form will handle any number/name of fields.
Unfortunately, I have no idea of what you are speaking. Could you please give me an example? My table looks like this:
Group
Category
A A B B C C D D E E ... Totals % %
1 amt count amt count amt count amt count amt count amt count a c
2 amt count amt count amt count amt count amt count amt count a c
3 amt count amt count amt count amt count amt count amt count a c
4 amt count amt count amt count amt count amt count amt count a c
5 amt count amt count amt count amt count amt count amt count a c
.
.
.
Total amt count amt count amt count amt count amt count amt count
There are 1 to 30 categories and A to ZZ Groups. Each "cell" contains an amount and a count of the records adding up to the amount. Of course, I need to total the columns and the rows. I also need to add the % each row contributes to the total. I hope this helps you to understand my problem a little more.
Scott
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only