thanks a lot. It was very helpful.

But problem with Group Header is, It does not repeat for group footer or if you have very long sub report which comes across more than one page.

Thats why I...

Thanks for your suggestion Grasshopper.

But just because we are facing some issues in some reports,

we can not change our complte reporting tool and architecture.

How can we display and hide controls...

I am still waiting for reply. Please give some suggestions.

Every Textbox has property Hide Duplicates.

This amount is sum for person A, then you must have Group for person.

Set the Hide Duplicate property to Person's group Name for example "grpPerson"....

Thanks everybody for replying.

I was looking for some function, which solve my proble.

But I didn't find any.

Now I made my own case

CASE WHEN CHARINDEX('.',MYVALUE) = 0 THEN CAST(MYVALUE AS ...

Thanks all for replying. But both answers are not satisfying my requirement.

In Case of currency, this number is simple number, not a currency so I dodn't need any $ sign...

Thanks for replying.

But using this, space taken by page header will not supress.

I have almost 1.5in long page header.

Is there any way to supress space too?

Thanks for replying Hari.

But I think my problem is not that simple.

Using the expression you suggested, i will face following issue

when the rows will spread over more than one pages,...

here is the image attached

Hi Hari,

I think , you misunderstood me. I need the laout as shown in picture. I want border for first textbox which contains value. After tah...