• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Why empty lines for autosize height field in preview mode

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Why empty lines for autosize height field in preview mode

  1. Issue
0
Votes
Undo
  1. Sivaprakash BKR
    Sivaprakash BKR
  2. PowerBuilder
  3. Monday, 11 September 2023 13:49 PM UTC

Hello,

PB 2022 R2 B 2819

In a report, I've a computed column with autosize height property set.  When the report is shown in normal mode, there is no blank space. but when we show (or print) in preview mode, a blank space appears for that row.  Why?

Output in normal mode

Output in preview mode

Second column is a computed column which sets value from another column with

Trim(column1)

Second column alone is set with autosize height property along with detail band.

We have seen this issue in PB 10.5, PB 11.5 also.
we tried changing the font from Arial to Palatino Linotype to Roboto.  All with the same issue.   If the content of the second column is changed then this empty line goes.

Anything that we could do to avoid this blank line.  

Happiness Always
BKR Sivaprakash

 

  1. PowerBuilder (Appeon)
Deploying/Creating .Exe Slowdown
PB 2019 R3 64 Bit app - Can't connect DB - ORA-121...
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 12 September 2023 18:27 PM UTC
  2. PowerBuilder
  3. # 1

Hi BKR ;

  FYI: In Print Preview mode the preview will take into account your margin settings. That could affect the final output to the printer that you now see. Food for thought.

Regards ... Chris

Comment
There are no comments made yet.
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Wednesday, 13 September 2023 05:40 AM UTC
  2. PowerBuilder
  3. # 2

Thanks Chris,
In that case, it should appear for all lines, as margin settings affects the whole page, not for individual lines.

Here is the snapshot with boxes drawn, which shows that all columns are within the paper size / margin [ Preview mode ]

See the second column contents [ It's set with autosize height property ]. 

Tried:

Tried adding a character, the empty rows gets filled with that character.

Increased width of the second column, still the issue is there

Again increased the width of the second column, the issue gone.  No empty rows.

Any idea to overcome this issue, without increasing the width to this extent.

Happiness Always
BKR Sivaprakash

 

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Thursday, 14 September 2023 07:03 AM UTC
So what was the solution?

regards
  1. Helpful
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Friday, 15 September 2023 05:07 AM UTC
Till now, no solution Miguel.... IMO, some calculation errors for Autositze height fields, that could be solved by Appeon only. It appears only for those rows, whose contents matches the width of the column.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Friday, 15 September 2023 09:20 AM UTC
Ah okay, Chris' comment got me confused thinking that there was a workaround.

regards.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 13 September 2023 05:51 AM UTC
  2. PowerBuilder
  3. # 3

Hi, have you tried issuing a SetRedraw(true) after going into Preview?

Maybe it will recalculate the heights?

What if you set AutoSize height for all of the columns?

Just guessing,

regards

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 13 September 2023 11:12 AM UTC
Hi Chris,

Yes, you might be right on that one, even a Sort() command might re-arrange things too.

regards
  1. Helpful
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Wednesday, 13 September 2023 14:25 PM UTC
Thanks Chris, Miguel.

1. SetRedraw(True) doesn't work. The same issue

2. Set all columns to Autosize height. No luck. Same issue

3. Issued Groupcalc command. No luck. Same Issue

4. Sort command also didn't help. Same issue.

  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 13 September 2023 18:21 PM UTC
Hmm sounds like a bug to me then ...

regards
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.