sql reporting services formats ( datetime, numbers ...

Question

i put the format of a textbox using expression like Format(Fields!name.Value, "dd/MM/yyyy")

can i somehow set a global format for datetime and currency/floats without having the need to set it for each textbox in part

Answer 1

i don't know perfectly as per my knowledge i think it's not possible. if you know the answer then post here OK.

Answer 2

Perhaps.

You can specify a report language/culture to use which affects all controls.

However, I don't think you can specify a certain format "dd/MM/yyyy" which is not linked to language.

Answer 3

i didn't found how to do that but i do use know a macro recorder, so i created some macros for formatting stuff in my report like for datetime and cash, so i format a cell with a hotkey now, that's my workaround

well you could also format it in DB and send it as string, but it's kind off the same