Formatting in a Crosstab Query

[michaelak117]

I have an issue with my numbers in a crosstab query. I have my numbers formatted as currency with 0 decimal places but when the crosstab is created the formatting is lost. When I use the property sheet to change it back it is ineffective. I have written different expressions Such as a CCur. This works, but doesnt includes decimals. I've used a FormatCurrency Expression, This works but doesn't make the numbers Currency, with commas and parenthesis (negative numbers).

Please help with this issue, seems minor but driving me crazy.

Much appreciated

Mike

 

[HiTechCoach]

Welcome to AWF!

I normally do not do any formatting in a query. I do it with the a control on a report/form.

For an example report see:
Details for Dynamic Report based on a Crosstab query

 

[michaelak117]

Thanks for the reply. Thats a good suggestion and where I have been going with it. I created a report and it looks good. I had trouble opening your link to look at your suggested example.

When I build my reports I really want it to be appealing. So I colored it in changed some formattig and added a logo. This is for a daily business process. Do you know how to save those changes so I can easily use it everyday. What I mean is create some kind of a template for this report?

Thanks

Mike

 

[HiTechCoach]

I am not sure why you couldn't get the the previous link to downalod the example. I have attached the example for you.