Hi,
I have a number of reports that display a variety of numerical data. The data is formated on the fly using DataFormatStrings on the report textbox controls. The format strings are working correctly when viewed in the Viewer / HTML. However when exporting to excel, the Percent format string is not being applied ({0:P}). All other format strings are working correctly when exported, but the percentage seems to not be applied at all. Is there any fix for this or am I missing anything? When I export currency formatted items ({0:C}), they are displaying correctly.
Thanks,
Ahmed
I have a number of reports that display a variety of numerical data. The data is formated on the fly using DataFormatStrings on the report textbox controls. The format strings are working correctly when viewed in the Viewer / HTML. However when exporting to excel, the Percent format string is not being applied ({0:P}). All other format strings are working correctly when exported, but the percentage seems to not be applied at all. Is there any fix for this or am I missing anything? When I export currency formatted items ({0:C}), they are displaying correctly.
Thanks,
Ahmed