Information générale
Catégorie:
Gestionnaire de rapports & Rapports
>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement