RTC report Blank Space and Overlapping Problem

postsaurav

Hi all,

i was trying to customize the sales invoice line Report.
what i wanted was to pull details of charges and hide the columns when value are zero in the footer part of the report?

I put the hidden condition for all the rows in footer.
I created a new table for the charges which will display details in the group footer.

Issue -
Values are getting pulled as required, but the issue is either of these -
1) Either i am getting blank lines if the values are empty.
2) If the body have multiple rows the charges details are getting overlapped in the footer section.

Please let me know if someone know how it can be resolved.

Thanks & Regards,
Saurav Dhyani

Belias

1) there's hidden property for the row line: depending on your businness logic, you can manage this property value to true or false. If hidden is true, the line won't be shown and it won't "eat" space in the page
2) try to do the print preview (and actually print the report) and see if the issue is still there. If so, check the top/bottom margins and page size properties: these properties interacts with the header/footer in fancy ways (I mean it's easier for you to try it, than try to understand what i say if explain it to you :whistle: ). If this does not solve the problem, just post some screenshot here to heelp us to understand

postsaurav

Hi Belias,

Thank for the reply.

1) there's hidden property for the row line: depending on your businness logic, you can manage this property value to true or false. If hidden is true, the line won't be shown and it won't "eat" space in the page


There is hidden property for each lines.

2) try to do the print preview (and actually print the report) and see if the issue is still there. If so, check the top/bottom margins and page size properties: these properties interacts with the header/footer in fancy ways (I mean it's easier for you to try it, than try to understand what i say if explain it to you ). If this does not solve the problem, just post some screenshot here to heelp us to understand

There is no changes in print preview and actual print for the report.

Please see attached images for -

1) Where the report display empty spaces.
2) When report overwrites the tables.
3) The layout of the report.

Please find images at https://plus.google.com/photos/11614167 ... 4Nn-2K2Xcw

Let me know if you require any other information.

Thanks & Regards,
Saurav Dhyani

Belias

There is hidden property for each lines. <-- what is the value of the property?

did you try to play with margins and page size and see the effect of your changes?

from your report layout, it seems like there IS some blank space between your tables...anyway it's really hard to understand from the pieces of layout you sent us..

mihail_kolev

are there 3 tables in the report?

postsaurav

Yes there are three tables in the report.

mihail_kolev

Well, the blank spaces and the overlapping are maybe caused by the fact that the report render all tables at the same time. It doesn't care that table2 must be below table1, it just fill the rows (what I'm saying - table2 is rendered 20cm(for ex.) below the page edge - where it is placed in design, doesn't matter that rows from table1 are printed on this position too). I think you really need to redesign the report and use one table and use the Hidden properties of the rows.

Belias

mihail_kolev wrote:

I think you really need to redesign the report and use one table and use the Hidden properties of the rows.

...or wrap everything in a list object, but it really depends on your business needs...multitable reports are possible (http://www.mibuso.com/forum/viewtopic.php?f=16&t=43980&hilit=hugest) but you need to work on it a bit!

postsaurav

Hi all,
Thanks for the Replies.

I figured out the cause of blank spaces and tried to resolve as per my knowledge. But no luck till now.

Here are my findings -

1) That is due to hidden condition that i set for rows in Footer, but the condition is not working.
2) These are on some specific fields Listed Below -
ServiceTaxAmt.
ServiceTaxECessAmt.
ServiceTaxSHECessAmt.
AppliedServiceTaxAmt.
AppliedServiceTaxECessAmt.
AppliedServiceTaxSHECessAmt.

3) I tried to change hidden condition as these condition.
a) IIF(Fields!ServiceTaxAmt.Value = 0, true,false)
b) IIF(Last(Fields!ServiceTaxAmt.Value = 0), true,false)
c) I tried same using a boolean variable to set to true when Report is calculating these values and then change hidden as req.

But nothing worked out. Everything goes will if these fields have values, but if these fields are ZERO, either the fields will appear as zero(no hidden condition) or Fields will not appear but the blank space will appear (hidden condition).

Please let me know if something can be done to resolve this.

Thanks & Regards,
Saurav Dhyani

Sog

Don't set the fields visible, but the entire row!
If you only set the fields invisible, the row will still take some place.

postsaurav

Dear Sog,

Thanks for the reply, but the hidden property is set for the row.
If Possible please, try to replicate the issue. I am also confused because i faced the issue first time.

If Required i can send you the fob of the standard report with these visibility condition which are not working.
Thanks & Regards,
Saurav Dhyani

mihail_kolev

you can't set the hidden condition in the footer, you need to set it in the somewhere in the table rows