Month

[chomzky]

Hello,

I am creating a crosstab report that will show values based on month of the year. I want to use a formula in a column that will capture the inforamtion based on each month. I want to view the inforamtion by year(2005 - 2007) for each row. I thought of using this formula but I keep getting a date range error? Can anyone please help. The forumula I have tried is below.

select MonthName({Blotter.Occured})
case "1": "January"
case "2": "February"
...........

 

[lbass]

Is {Blotter.occurred} a date field?

If so, the formula should be:

Select month({Blotter.occurred})
case 1 : "January"
case 2 : "February"


-LB

 

[CoSpringsGuy]

im not sure I understand what you are trying to do nor what version of Crystal you are using but try this instead of what you are using:

monthname(month({Blotter.Occured}))

that should return the month name for you without using the select.

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[lbass]

Wow, I really wasn't paying attention. If you are doing a crosstab with month as the column and year as the row, then I would use the formula {@month} as the column field so that it sorts correctly:

month({blotter.occured})

Then while this column is highlighted within the crosstab expert->group options->options->customize group name->use a formula:

monthname(month({blotter.occured}))

This will give you the display you want in the right order.

-LB

 

[chomzky]

thank-you very much for your help. I am able to get everything reporting correctly. It may have been th 3equoted as well as teh MOnthname instead of month.

Thanks again,

C