Creating monthly values in columns 1

[Flybridge]

It's been a long time since I used Crystal. I think this is possible to do, but if it is, I can't remember how to do it.

I can't use an OLAP report or a cross tab because of the way the data needs to be presented.

I have a few descriptive columns, then I need columns for January to December across the page, reporting a total value for each month.

I know I have to drag the value into the report 12 times and re-label the columns as the months.

What are the steps to restrict the value reported in each column to only show the total for the relevant month?

I'm using Crystal Reports 2008.

Thanks in advance.

'The world isn't round - it's bent!' Spike Milligan

 

[lbass]

Create conditional formulas like this:

//{@Jan}:
if month({table.date}) = 1 then {table.amount} //or 1 for a count

Place each formula in the detail section and insert sums (not counts) on them at the group level. Drag the groupname into the group footer. Then suppress the detail section and group header.

-LB

 

[Flybridge]

Thanks.

I'm very rusty on this, so thanks for the tip - and speed of response.

'The world isn't round - it's bent!' Spike Milligan