Custom formatting in Report

[amthekkel]

Hi,

I have a report(.rdlc) file which displays information from a dataset. I am able to drag the fields from the datasource and place them on the report and the report is displaying the data.

One of the fields is a string e.g. 1011000. This is a representation of the days of week, with each bit representing a day of the week. 1 means a day is set and 0 that the day is unset, so the above e.g equates to Mon, Wed and Thursday

In my report i have the above field but would like to convert it to the day of the week equivalent. Is there a way i can call a function from within the report and pass it this vale and obtain the day of week info as the result. I had a look at expressions and formatting for the field but couldn't find a way to specify custom functions .

thanks..

abhi

 

[amthekkel]

Solved

There is a Code Section when you choose Report -> properties.

Here you can specify your functions.

To access the function for the field, use the Code.<function_name>(Field) syntax.

read more on my blog : Programming Articles: .NET - Custom Formatting Report Fields

hope this helps anyone else who is struggling with the above.

cheers
abhi