Empty Space issue in RTC reports

ajaybabuCh · 2010-03-12

Hi

In the Report Number 406 Purchase - Invoice , I have done the following

-Added a global variable TotalAmtInclVATTest
-In "Purch. Inv. Line" data item OnAfter get record added TotalAmtInclVATTest += "Amount Including VAT"
-Added Integer data item with DataItemIndent level 3 and Name it as ShowAmt. I have added this after all the existing dataitems.
-In the ShowAmt data item body section , I have added text variable and given the source expression as TotalAmtInclVATTest
-Then I click on View -> Layout
-At the end of RTC layout , I have added a table
-Removed the header and footer rows
-In the Detail row , I have assigned one of the column with =Fields!TotalAmtInclVATTest.Value
-Saved the layout and save and compile the report.

When I run RTC report
Standard report without the above modification is printing in One page.
With the above modification , Same report displaying my new added value in the next page bottom. The top of the next page it is displaying header information. and it is generating the empty space , at the end of that page it is displaying the new amount added.

How to elemenate this empty space and print on the same page. ( I have also tried given "KeepTogether" property to True but no use)

Thanks and Regards

kpsri · 2010-10-20

This is exactly the issue I have.

I am adding a signature block to an existing report (50000 series), at the end of it.

I can get all of the PO (including the signature block) to print in one page.

In RTC, it prints the data that was there before my change in the first page and then prints the signature block at the bottom of the next page.

Header is printed properly in both pages.

I have a list to which tables have been added ( some of them have conditional visibility and some dont).

Thanks,

Srikrishnan.K.P.

kpsri · 2010-10-21

I was able to resolve the issue with the empty space in RTC reports.

Turns out the empty space was actually small dots, one per a block of 4 empty lines.

I checked the dataset values that were coming into RTC using ctrl + alt + F1

Based on that, RTC was trying to print the new signature block for each row of the dataset even though the Signature values were present only in the last row.

Added last () functionality to the signature block and the dots went away.

johanna · 2011-03-17

Dear Srikrishnan,

Added last () functionality to the signature block and the dots went away.

How to do that? Is it just add "()" after the Value ? Is it like :

=Fields!Document_No.Value()

? I have tried it, but empty space is not removed

I have looked into my dataset using ctrl + alt + f1 and the result show me the correct dataset..

My structures in section are :
GroupHeader1 of Dataitem1
>GroupHeader2 of Dataitem2
>>Body1 of Dataitem3
>>Body2 of Dataitem3
>>Header of Dataitem4
>>Body of Dataitem4
>>Footer of Dataitem4
>Header of Dataitem5
>Body of Dataitem5
GroupFooter of Dataitem1

My structures in RDLC are :
GroupHeader1
>GroupHeader2
>>Body1
>>Body2
>GroupFooter2 (inside of this row, I add table to looping for my record variable)
GroupFooter1(inside of this row, I add table to looping for my record variable)

The result is :
Record1 of GroupHeader1
>Record1 of GroupHeader2
>>Record1 of Body1
>>Record1 of Body2
>>Record1 of Body1
>>Record1 of Body2
<space>
<space>
>Record1 of GroupFooter2
>Record2 of GroupHeader2
>>Record1 of Body1
>>Record1 of Body2
>>Record2 of Body2
<space>
<space>
<space>
>Record1 of GroupFooter2
>Record2 of GroupFooter2
<space>
<space>
<space>
<space>
<space>
<space>
<space>
<space>
<space>
<space>
Record1 of GroupFooter1
Record2 of GroupFooter1

Please help to remove all this space .. Thank you

johanna · 2011-05-20

Dear all,

Someone can help me to remove the spaces as my post above ?? Thank you..

mohana_cse06 · 2011-05-20

Can you us your report layout and report preview.

Troubles_In_Paradise · 2011-05-20

johanna wrote:
Dear Srikrishnan,

Added last () functionality to the signature block and the dots went away.

How to do that? Is it just add "()" after the Value ? Is it like :
=Fields!Document_No.Value()
? I have tried it, but empty space is not removed

I think that Johanna means =Last(Fields!MyField.value).
Anyway you could try to color rows of your report to find which lines are printed many times.
Located rows printed many times (that cause empty spaces) you could try to hide them with visibility property.

Belias · 2011-05-20

@johanna: this is usually the reason of the problem:

I checked the dataset values that were coming into RTC using ctrl + alt + F1

Based on that, RTC was trying to print the new signature block for each row of the dataset even though the Signature values were present only in the last row.

a table body section actually prints EVERY SINGLE ROW of the dataset. Thus, if you print a value which is only evaluated in the 99th line of the dataset (check it through "about this report" function), there will be 98 empty lines before it.
You have to manage the visibility property according to what you want to achieve.
you can try with "Isnothing(thevalueiwanttoshow)" or similar...
EDIT: this is my 2424 post, which is 24-24: my years repeated twice... \:D/

johanna · 2011-05-25

@mohana : thanks for your reply. Here I attach the report layout result & design..

@Troubles In Paradise : thanks for your suggestion. I have colored my rows in report and it help so much.
@Belias : thanks for your suggestion. The empty spaces are dissappeared when I add code 'IsNothing' for Hidden property of the row. This issue has been solved. Thanks so much!

Troubles_In_Paradise · 2011-05-25

congratulations!

himanshu · 2013-10-08

U just simply add a code on the row in which u r showing the value, go to the row visiblity property and add folowing code
=IIF(IsNothing(Fields!ABC.Value),FALSE,TRUE)

Empty Space issue in RTC reports

Comments

Categories