Help with a formula

[ZENYO]

I have done a report that shows item dollar sales. Then I needed to then I needed to group all the items then summarize by date.... This was no problem (Please keep in mind that I have only been using Crystal Reports for 2 days and we don't have the ODBC link for A4W yet) Anyway... The boss now wants to have the dates in they're own colums with the sales. So the column header would be the respective month i.e. Oct, Nov.... and the column feilds would be the sales total for each item in the rows... Does this make sense??? I need help. I've been working on this all day and I haven't even come close...

Thanks for your time...

 

[IdoMillet]

Either use a CrossTab approach or create
for each month a formula similar to:

If (Month ({MyTable.MyDateField}) = 1)then
{MyValueField} else 0

You can then total these formula fields
to obtain the totals for each monthly
column.

Cheers,
- Ido

 

[ZENYO]

Thanx for the replie. I tried that but I couldn't get it to work. So, I used periods instead of date and I got the If Then Else to work. Mission completed. Thanx for your replie.

Allan