August 24, 2015 at 11:53 am
Good Morning Guys,
I would like to ask if it is possible to have my Grand total for hours(Including Decimal e.g. 24,456.70) and Currency(e.g. 24,456.70) not wrap if the grand total accumulates more than 6 digits? how do i format it or make it wrap after i exceed my limit of 6 digits for both the hours and currency. any help you could extend is very much appreciated
Best Regards,
Noel Isip
August 25, 2015 at 3:00 pm
Hello Stylez
You can try to set expression on the text box:
=Switch(Fields!GrandTotal.Value < 1000,Format(Fields!GrandTotal.Value, "Yor first Format"),Fields!GrandTotal.Value > 1000,Format(Fields!GrandTotal.Value, "Your second Format"))
Best regards
Mike
August 26, 2015 at 7:58 am
In Design View, right click on the cell you want to format, then right click "Text Box Properties". Click on "Number" tab and select the correct formatting.
Quick tip, if you need to format multiple cell with the same format, then format one cell first as described above, left click on the formatted cell again and look at properties window, and then "Format" value. It would have a string, for example, currency would be like '$'#,0.00;('$'#,0.00). Copy the string/value. Highlight other cells you need to format by holding "Ctrl" and then go in properties again and paste the string/value into "Format" property again. Done, quick. Took me couple of year to figure this trick out.
------------
🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply