Monthly date ranges 2

[sclark415]

I am using Crystal 10, Enterprise 10 on SQL Server. I have to create a report that produces a total count of claims by month for all of 2003, and 2004. Can you help me please? I am at a loss. I have suppressed my detail, and have come up with 01/04 (I am doing 2004 first) total, but don't know how to proceed.

Thank you in advance for your assistance.

 

[lbass]

The simplest approach would be to insert a crosstab in the report header or footer. Use {table.date} as the column field, and while it is selected in the crosstab expert, go to ->group options and check "Print on change of months". Then for your summary field, insert "count of {table.claim}".

-LB

 

[sclark415]

LBass,

Thank you so much for your assistance. This is what I needed. I appreciate your help!

 

[MRWARNER]

I need help with this too. I have CR9

I have multiple years to report on and when I use Month as the column header (in crosstabs)and Year as a row header the results display months for each year, so I have 2 or 3 sets of months as headers.

I only want the month to display once on top like this
jan feb mar apr
2002
2003
2004

instead of
jan02 feb02 mar02 jan03 feb03 mar03 -- and so on
2002
2003
2004

I can write formula as datepart or just month() but these return only numbers - I need the abbreviated month name to appear instead of numbers. When I convert numbers to names I lose my sort order - it turns into alpha ascending.

Excel and Access can do this - Crystal seems to want to define the year even if its not the chosen format.

If anyone knows how to do this please help.

Thanks
Michele in Reno

 

[lbass]

Use the following formula {@month} for your column field:

month({table.date})

Then highlight the column field->group options->customize group name->use a formula to customize name->x+2 and enter:

monthname({@month})

-LB

 

[MRWARNER]

Once again, Your Brilliant!

Thank you it's perfect and it sorts in the right order too.

I voted for you, again.

Michele