Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data Format in Cross Tab and Parameter window about numeric and date


I got a problem to show Year 2008 as 2,008.00, it's rediculous...

My PC and Notebook both show "2008", but my three co-workers' PCs all show "2,008.00"

the group field is: CStr(Year({SJ_Inv;1.TaxDate}))+ ' Sales Analysis'

How to convert such a numeric into text without decimal? CStr looks not workable.


the numeric var in parameter window, sometimes I don't want it to show up comma and decimal, how to format it?

And, the datetime var in parameter window from store procedure, can it be a "Date" without Time for user to entry only?

I will be very appreciate for your helping.


Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question