Showing Dates in Order 2

[smil3y]

I am using a cross tab with date formula (ToText({Injuries.Date},"MMM yyyy&quot) to get date in correct format. This works but when presented in the report the dates start at A then etc.

Can someone help me with getting dates in correct order ie start at Jan etc.

 

[dgillz]

Create a formula that will sort properly:

tetext(month({Injuries.Date})"00&quot&Totext(Year({Injuries.Date}),0,"&quot

Group by this fieldm rather than the formula field you have now. Then on group options, for group name, click the "user a formula" radio button and insert the formula you are using now:

ToText({Injuries.Date},"MMM yyyy&quot


Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[lbass]

Try using the date field itself for your group and set it for monthly, and then choose "customize group name"->use a formula and then use your formula:

ToText({Injuries.Date},"MMM yyyy&quot

Note that you will need to refresh the report before you can see the new group labels in the crosstab.

-LB

 

[dgillz]

very nice LB, much simpler.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com