Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Axils formataing

Status
Not open for further replies.

moiseyo

Programmer
Mar 3, 2006
1
US
I ‘d like to make axils horizontal format as

Jan Feb etc

06 06

I used formaula
MonthName(Month({@DateFilter}), True)
& " - "
& Right(ToText(DatePart("yyyy",{@DateFilter}),"####"),2)

But columns come not in chronological order. The order is alphabetical.
How to work with that problem


 
Bit of a language barrier I guess.

When asking about software, post the software used and it's version.

Then state what you have and what you need, you posted what you need, and some formulas that go against other formulas...

If you're building some type of grouping or sortation then so state, Crystal doesn't have axils.

If you want month columns to sort, then base the grouping or sorting on the month number, or just the date itself, then use your formula for display purposes only.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top