Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Preview vs print - Grids

6 posts in DataWindow Last posting was on 2010-02-05 15:24:22.0Z
Thomas Waldorff Posted on 2010-01-11 10:08:53.0Z
From: "Thomas Waldorff" <NULLSPAM_twaldorff@ofir.dk>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Preview vs print - Grids
Lines: 3361
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b4af8b5@forums-1-dub>
Date: 11 Jan 2010 02:08:53 -0800
X-Trace: forums-1-dub 1263204533 10.22.241.152 (11 Jan 2010 02:08:53 -0800)
X-Original-Trace: 11 Jan 2010 02:08:53 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90565
Article PK: 410171

I will reraise my problem again this time with examples.

I'm using PB 10.2.1 build 9948 and 11.2 build 8920

I'm using the same printer driver for both the preview as well as for the
preview part.
I have tried different printer drivers (HP, Canon and Bluebeam PDF), always
comparing preview and printed output using the same printer driver. But
using a different driver does not change a thing.

In the attached preview.pdf you can see how the cross-column foreground
labels align to the grid as well as right margin.

In printed.pdf you can see the actual printed output, where cross-column
labels keep position, but the grid is "narrowed".

In printednogrid.pdf you can see the printed output from the very same
datawindow and printer driver. The only difference is processing is changed
from 1 to 0 for the grid. Alignment is OK, but naturally no grid lines.

Does anyone have any ideas to fix this?

Yours sincerely
Thomas Waldorff


Thomas Waldorff Posted on 2010-01-18 10:24:29.0Z
Sender: 7e91.4b543609.1804289383@sybase.com
From: Thomas Waldorff
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Preview vs print - Grids
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b5436dd.7ebc.1681692777@sybase.com>
References: <4b4af8b5@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 18 Jan 2010 02:24:29 -0800
X-Trace: forums-1-dub 1263810269 10.22.241.41 (18 Jan 2010 02:24:29 -0800)
X-Original-Trace: 18 Jan 2010 02:24:29 -0800, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90592
Article PK: 410196

Hi

I had hoped someone would have come up with a suggestion.
Since this is not the case, I might lower the bar and ask:

Is the described behaviour of the printed grid a PB
"feature" or am I the only one to entcounter this?

regards
Thomas


Ivaylo Ivanov Posted on 2010-01-18 15:21:48.0Z
From: "Ivaylo Ivanov" <n0_S_p_a_m_i.ivanov@isy-dc.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b4af8b5@forums-1-dub> <4b5436dd.7ebc.1681692777@sybase.com>
Subject: Re: Preview vs print - Grids
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b547c8c@forums-1-dub>
Date: 18 Jan 2010 07:21:48 -0800
X-Trace: forums-1-dub 1263828108 10.22.241.152 (18 Jan 2010 07:21:48 -0800)
X-Original-Trace: 18 Jan 2010 07:21:48 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90594
Article PK: 410197

Any experiments with the grid's Display property (on/off/display only/print
only)?
Any change of the dw's unit to "1/1000 cm" or "1/1000 inch" - not to lay
upon the PB units metric when print?

Best,
Ivaylo

<Thomas Waldorff> wrote in message
news:4b5436dd.7ebc.1681692777@sybase.com...
> Hi
>
> I had hoped someone would have come up with a suggestion.
> Since this is not the case, I might lower the bar and ask:
>
> Is the described behaviour of the printed grid a PB
> "feature" or am I the only one to entcounter this?
>
> regards
> Thomas


Thomas Waldorff Posted on 2010-02-05 11:27:06.0Z
Sender: 6840.4b6bfd7e.1804289383@sybase.com
From: Thomas Waldorff
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Preview vs print - Grids
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b6c0089.688d.1681692777@sybase.com>
References: <4b547c8c@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Feb 2010 03:27:06 -0800
X-Trace: forums-1-dub 1265369226 10.22.241.41 (5 Feb 2010 03:27:06 -0800)
X-Original-Trace: 5 Feb 2010 03:27:06 -0800, 10.22.241.41
Lines: 14
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90731
Article PK: 410336

Thanks Paul and Ivaylo for suggestions.

This week I got some spare time to plat around with the
settings of the DWs, but unfortunately none of them
individually or combined made any change to the output.

Preview is OK while printed grid is squeezed horizontally.

So I have eventually given up and made the grid as a fake
grid in free form.

But I still wonder why this happens.

Thomas


Ivaylo Ivanov Posted on 2010-02-05 15:24:22.0Z
From: "Ivaylo Ivanov" <n0_S_p_a_m_i.ivanov@isy-dc.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b547c8c@forums-1-dub> <4b6c0089.688d.1681692777@sybase.com>
Subject: Re: Preview vs print - Grids
Lines: 66
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b6c3826$1@forums-1-dub>
Date: 5 Feb 2010 07:24:22 -0800
X-Trace: forums-1-dub 1265383462 10.22.241.152 (5 Feb 2010 07:24:22 -0800)
X-Original-Trace: 5 Feb 2010 07:24:22 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90733
Article PK: 410338

Seems like the grid decreases the width of each individual column by 1 (or
2?) pixels.

I've experienced similar thing a few months ago in a webform appl when tried
to dynamically create a bitmap object in a grid or crosstab DW (processing =
1 or 4) - sort indicator picture in the header band. The original gif-files
had a size of 9x9 pixels. In the Modify("CREATE bitmap(...")) statements I
had to pass the PB units equivalent of 10 pixels for the bitmap "width" and
"height" properties, otherwise it was displayed cropped.

So probably another dirty workaround (instead of the annoying remaking of
the DW with another presentation style) would be to loop through the DW
objects and issue Modify to increase the Width of each detail band object,
if your DW is not so much complex:

string ls_objects_list, ls_objects[]
string ls_property
long i

ls_objects_list = dw_rep.Describe("Datawindow.Objects")

// Parse the <Tab> separated list returned by the Describe
// into individual string elements
f_string_parse_into_array(ls_objects_list, ls_objects)

for i = 1 to UpperBound(ls_objects)
if Lower(Left(dw_rep.Describe(ls_objects[i] + ".Band"), len("detail")))
<> "detail" then continue
if Pos("column,compute,text", dw_rep.Describe(ls_objects[i] + ".Type"))
<= 0 then continue
ls_property = dw_rep.Describe(ls_objects[i] + ".Width")
if Lef(ls_property, 1) = '"' then
// The property has an expression -> inject 1 pixel into it
dw_rep.Modify(ls_objects[i]+ ".Width=" + Left(ls_property,
Len(ls_property) - 1) + " + " + string(PixelsToUnits(1, XPixelsToUnits!)) +
Right(ls_property, 1))
else
// The property has a simple numeric value
dw_rep.Modify(ls_objects[i] + ".Width=" + string(long(ls_property) +
PixelsToUnits(1, XPixelsToUnits!)))
end if
next

... or something like this :-)

Good luck!
Ivaylo

<Thomas Waldorff> wrote in message
news:4b6c0089.688d.1681692777@sybase.com...
> Thanks Paul and Ivaylo for suggestions.
>
> This week I got some spare time to plat around with the
> settings of the DWs, but unfortunately none of them
> individually or combined made any change to the output.
>
> Preview is OK while printed grid is squeezed horizontally.
>
> So I have eventually given up and made the grid as a fake
> grid in free form.
>
> But I still wonder why this happens.
>
> Thomas


"Paul Horan[Sybase]" <phoran_remove Posted on 2010-01-18 14:33:55.0Z
From: "Paul Horan[Sybase]" <phoran_remove@remove_sybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <4b4af8b5@forums-1-dub>
Subject: Re: Preview vs print - Grids
Lines: 40
Organization: Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b547153$1@forums-1-dub>
Date: 18 Jan 2010 06:33:55 -0800
X-Trace: forums-1-dub 1263825235 10.22.241.152 (18 Jan 2010 06:33:55 -0800)
X-Original-Trace: 18 Jan 2010 06:33:55 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:90593
Article PK: 410199

Not sure why you're using foreground objects? I've found those to be
troublesome with grid style dws...
I guess one option would be to use no gridlines, and set each column/label
to be borderstyle "box"?

--
Paul Horan[Sybase]
http://blogs.sybase.com/phoran/

"Thomas Waldorff" <NULLSPAM_twaldorff@ofir.dk> wrote in message
news:4b4af8b5@forums-1-dub...
>I will reraise my problem again this time with examples.
>
> I'm using PB 10.2.1 build 9948 and 11.2 build 8920
>
> I'm using the same printer driver for both the preview as well as for the
> preview part.
> I have tried different printer drivers (HP, Canon and Bluebeam PDF),
> always comparing preview and printed output using the same printer driver.
> But using a different driver does not change a thing.
>
> In the attached preview.pdf you can see how the cross-column foreground
> labels align to the grid as well as right margin.
>
> In printed.pdf you can see the actual printed output, where cross-column
> labels keep position, but the grid is "narrowed".
>
> In printednogrid.pdf you can see the printed output from the very same
> datawindow and printer driver. The only difference is processing is
> changed from 1 to 0 for the grid. Alignment is OK, but naturally no grid
> lines.
>
> Does anyone have any ideas to fix this?
>
> Yours sincerely
> Thomas Waldorff
>
>