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.

Crosstab export XLS

6 posts in DataWindow Last posting was on 2009-01-22 21:44:16.0Z
ednego Posted on 2009-01-17 21:29:58.0Z
Sender: 59cb.49724bd3.1804289383@sybase.com
From: ednego
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Crosstab export XLS
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49724dd6.5a21.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub49724dd6"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Jan 2009 13:29:58 -0800
X-Trace: forums-1-dub 1232227798 10.22.241.41 (17 Jan 2009 13:29:58 -0800)
X-Original-Trace: 17 Jan 2009 13:29:58 -0800, 10.22.241.41
Lines: 1032
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88633
Article PK: 417890

Hello,

I used PB 10.5 and i would like to export a crosstab
datawindow in XLS fomat with function "saveas".

The crosstab is ( see Attach )

Designation paiement
Quantity somme
identity ( Lastname+ username)


In the file XLS, i dont' have the designation ??

Why ??

Thanks

crosstab.JPG

Bruce Armstrong [TeamSybase] Posted on 2009-01-18 05:44:27.0Z
From: "Bruce Armstrong [TeamSybase]" <NOCANSPAM_bruce.armstrong@teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Re: Crosstab export XLS
Organization: TeamSybase
Reply-To: NOCANSPAM_bruce.armstrong@teamsybase.com
Message-ID: <mcg5n45a9vqjg2h54r1a6d15a0kqa64on4@4ax.com>
References: <49724dd6.5a21.1681692777@sybase.com>
X-Newsreader: Forte Agent 5.00/32.1171
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 17 Jan 2009 21:44:27 -0800
X-Trace: forums-1-dub 1232257467 10.22.241.152 (17 Jan 2009 21:44:27 -0800)
X-Original-Trace: 17 Jan 2009 21:44:27 -0800, vip152.sybase.com
Lines: 33
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88635
Article PK: 417892

The SaveAs Excel, regardless of the DataWindow presentation style,
exports the underlying result set, not what is presented to the user.

On 17 Jan 2009 13:29:58 -0800, ednego wrote:

>Hello,
>
>I used PB 10.5 and i would like to export a crosstab
>datawindow in XLS fomat with function "saveas".
>
>The crosstab is ( see Attach )
>
> Designation paiement
> Quantity somme
>identity ( Lastname+ username)
>
>
>In the file XLS, i dont' have the designation ??
>
>Why ??
>
>Thanks

-----------------------------------

My Web 2.0 Stuff

Blog: http://bruce.pbdjmagazine.com/
Facebook: http://www.facebook.com/people/Bruce-Armstrong/1600223798
Fotki: http://public.fotki.com/brucearmstrong/
LinkedIn: http://www.linkedin.com/in/bruceaarmstrong
Twitter: http://twitter.com/bruce_armstrong
YouTube: http://www.youtube.com/user/brucearmstrong


"Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel Posted on 2009-01-18 21:01:50.0Z
From: "Jerry Siegel [TeamSybase]" <jNOsSPAMsiegel@yahoo!.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <mcg5n45a9vqjg2h54r1a6d15a0kqa64on4@4ax.com> <4973867f.2286.1681692777@sybase.com>
Subject: Re: Crosstab export XLS
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
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: <497398be$1@forums-1-dub>
Date: 18 Jan 2009 13:01:50 -0800
X-Trace: forums-1-dub 1232312510 10.22.241.152 (18 Jan 2009 13:01:50 -0800)
X-Original-Trace: 18 Jan 2009 13:01:50 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:88637
Article PK: 417895

If they just need to see it, PDF and PSR work well. For PSR you would need
to provide a viewer- a very small PB application. Several free ones are
available or you could write your own in a couple of hours.
You might also try exporting as HTML and importing that in Excel.

<ednego> wrote in message news:4973867f.2286.1681692777@sybase.com...
> Ok, but how to export the crosstab presented to the user
> exactly ??
>
> Thanks
>
>> The SaveAs Excel, regardless of the DataWindow
>> presentation style, exports the underlying result set, not
>> what is presented to the user.
>>
>> On 17 Jan 2009 13:29:58 -0800, ednego wrote:
>>
>> >Hello,
>> >
>> >I used PB 10.5 and i would like to export a crosstab
>> >datawindow in XLS fomat with function "saveas".
>> >
>> >The crosstab is ( see Attach )
>> >
>> > Designation paiement
>> > Quantity somme
>> >identity ( Lastname+ username)
>> >
>> >
>> >In the file XLS, i dont' have the designation ??
>> >
>> >Why ??
>> >
>> >Thanks
>> -----------------------------------
>>
>> My Web 2.0 Stuff
>>
>> Blog: http://bruce.pbdjmagazine.com/
>> Facebook:
>> http://www.facebook.com/people/Bruce-Armstrong/1600223798
>> Fotki: http://public.fotki.com/brucearmstrong/
>> LinkedIn: http://www.linkedin.com/in/bruceaarmstrong
>> Twitter: http://twitter.com/bruce_armstrong YouTube:
>> http://www.youtube.com/user/brucearmstrong