1. Dan Cooperstock
  2. PowerBuilder
  3. Monday, 3 April 2023 12:40 PM UTC

I'm changing the length of some database columns that are on a lot of reports to allow 40 instead of 20 characters. To avoid changing the portrait-mode tabular reports to landscape, I'm leaving the width of the report field the same, and changing both it and the datawindow.detail band to have Autosize Height on.

The problem is that with some data, in some reports, while the contents only wrap onto two lines, it seems like enough space is being left for 3 lines of text, so there's extra blank space before the next report row. The same data in other reports only takes up the space of 2 lines. I can't really see a pattern of when that happens or doesn't happen.

Anybody have any ideas about solutions? We will live with this if necessary but it looks a bit odd and thus makes us look a bit unprofessional.


Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 3 April 2023 15:43 PM UTC
  2. PowerBuilder
  3. # 1

Hi Dan;

  Is the source column VarChar vs Char!

  Have you set your DB connection properties so that the trailing spaces are removed from the data stream?

Regards ... Chris 

  1. Dan Cooperstock
  2. Monday, 3 April 2023 18:16 PM UTC
Definitely not, they are just values that I typed into a single-line edit field in a DW. And again, the exact same values are wrapping nicely into the vertical space of 2 lines in some reports, but in other reports they are taking 3 lines of space (or almost that) but with nothing on the 3rd line! So I can't see how it could be the contents of the data.
  1. Helpful
  1. Chris Pollach @Appeon
  2. Monday, 3 April 2023 18:41 PM UTC
Sounds good there then.

What about the font used on that column?
  1. Helpful
  1. John Fauss
  2. Monday, 3 April 2023 19:22 PM UTC
@Dan - What if you compare the same 40 characters in a DW that works correctly and one that does not? The presence/absence of white space characters can make a difference on how the contents are rendered. Chris' suggestion regarding possible differences in the font/typeface is a good one. Also check the detail band heights in the working/not working DW's for differences.
  1. Helpful 1
There are no comments made yet.
Dan Cooperstock Accepted Answer Pending Moderation
  1. Monday, 3 April 2023 12:42 PM UTC
  2. PowerBuilder
  3. # 2


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.