right click on the textbox and select the textbox properties option

Number -> Date -> select the format in which you want to display.

If your column value should be a date type, then use this

Format(column.value, "yyyy-MM-dd") --> Changes the datetime value to YYYY-MM-DD format

Go for customization of the expression, something like this

pseudo code :

Public Function fn_getString(a)

dim b as string

b = Convert a to string

if a is NULL

return "?"

else

return b & "Month"

end if

End...

Use it in a text box of a table, apply Grouping on the entire row. This should work

=IIF(Sum(Fields!PACB.Value)=0, 0,Sum(Fields!RCB.Value) / Sum(Fields!PACB.Value))

or

=IIF(Fields!PACB.Value=0, 0,Sum(Fields!RCB.Value) / Sum(Fields!PACB.Value))

Have you tried this in the expression of the textbox?

=iif(IsNothing(col.Value),"?",col.Value.ToString() & "Months")

Here it is, Divide By Zero Handling.. Apply this code in the expression of the textbox...

=iif(Fields!EmailSold.Value=0,0,(Fields!EmailSold.Value+Fields!EmailNotSold.Value)\Fields!EmailSold.Value)

My problem was to display zero if the value of the denominator is zero, else the division of the two fields.

So what I used is mentioned below,

iff(Field2=0,0,Field1/Field2)

I worked.. Hope it...

From the snapshot what I can guess is, you are using 3 tables to display data for a region. Am I correct?

Then you just need to club the 3 tables...

@Meghna

I also tried the shared variable and Dim variable concept, but each time it returned 1 and 0 respectively, probably the reason behind it may be that the Body is...

Try out the following :

=DateSerial(Year(Now), Month(Now)+1, 0) - last day of the month.

Hi Sandeep,

Is there any way to hold the Page Number from the Page Footer using a shared variable, so that it can be used in the Body of the RDL...