crystal report columns

[mattsuppok]

want to take a report, make it look like an excel table like this...
Jan. Feb. March.
meter1 34 35 54
meter2 44 66 77
meter3 55 7 55

and so on... now, the meter field must be grouped, I can also group by date.. A cross tab will display this perfectly, but I then need to perform calculations on the totals of the columns. Several calculations. That, I believe eliminates the crosstab thought.. suggestions are welcome and desired..thanks, matt

"it is what we do with the time we are given that determines our worth

 

[synapsevampire]

Roll your own cross-tab.

You give so little tehnical information that it's difficult to nail it, but basically you'll be building your own formulas or Running Totals, depending upon the version of your software, something you should always include when speaking of software, additionally you might include:

Database/connectivity
Example data
Expected output

Stating that you'll need calculations doesn't mean much, try fleshing out your thoughts, it doesn't take much longer and avoids the BLOG factor.

You don't state how the dates will be filtered either, so I'll provide an example which assumes that you'll have a start and end date parameter:

if {table.date} >= {?MyStartDate}
and
{table.date} < dateserial(year({?MyStartDate}
),month({?MyStartDate})+1,day({?MyStartDate}
) then
{table.value}
else
0

Place the formula in the details, right click it and select insert->Summary->sum

This formula handles month 1.

The total will be available in the group header as well if you intend to use percentages in other formulas.

-k