Extra spaces in RTC report where table visibily is hidden

rhardoyal

Hi,

I have a report in RTC and it has 3 tables. Depending on certain conditions i have set the visibility of the tables (use expression). However when i run the report i can find extra empty spaces where the tables that are hidden was suppose to be. Is there any way to remove these extra spaces. Please find attched screen shot.

Thanks,
Rizwana

mohana_cse06

Can share the rdlc report data also? (visual studio)
and expression in hidden field..

rhardoyal

The hidden expression for all 3 tables below;

table 1
=iif(Fields!CustLedgerEntryPrevious_Customer_No_.Value = "", true, false)
table 2
=iif(sum(Fields!Cust__Ledger_Entry__Debit_Amount_.Value) > 0 Or sum(Fields!Cust__Ledger_Entry__Credit_Amount_.Value) > 0, false, true)
table 3
=iif(code.customformat(Last(Fields!colAmount_4_.Value)) = 0 AND code.customformat(Last(Fields!colAmount_3_.Value)) = 0 AND code.customformat(Last(Fields!colAmount_2_.Value)) = 0 AND code.customformat(Last(Fields!colAmount_1_.Value)) = 0, true, false)

mohana_cse06

And where is rdlc screenshot?

You can check these posts also
http://dynamicsuser.net/forums/p/36771/190535.aspx
http://www.mibuso.com/forum/viewtopic.php?f=32&t=40527

rhardoyal

rdlc screnshot attached

mohana_cse06

I think the space you are getting is from page header not from body tables..

to check this, set back ground colour of record rows and try..

try by removing the space from page header also..