Automatic or Manual Crosstab Soultion Needed!!!

[oanion]

I’m trying to create a report that will calculate a percentage for a particular product for a particular month within a particular year. The percentage equates to the total amount paid for a month for a particular product/total balance of a particular product. I attempted this by trying a cross tab, and I’ve been unsuccessful since December. I have not found a way to manipulate a cross tab to calculate numbers without performing a summary. The output should look similar to the following

Product 1 Product 2 Product 3

January % Rate %Rate %Rate

February % Rate %Rate %Rate

March % Rate %Rate %Rate

April % Rate %Rate %Rate


Remeber that the % Rate is calculated from 2 fields in the database called totalpaid/balancepaid
Also keep in mind that there may be 5 products or 500 products just depending on the client we choose to run the report on and the months will display through December. Although it does not show here, I'm also grouping by year, therefore, all of the items from January to December for a 2004 will show, and then all the items from January to December for 2005 will show, etc.

I'm using Crystal Reports 10 and SQL Server 2000. I may have left out something, so please ask questions for clarification.

 

[lbass]

If you are saying that your database fields for total paid and balance paid are specific to a month and a product already, then you should be able to insert a maximum on your formula to get the correct figure.

-LB