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.

Error while using composite type report object with Tabular DW

3 posts in DataWindow Last posting was on 2008-09-02 17:44:48.0Z
John Smith Posted on 2008-09-02 11:28:50.0Z
Sender: 70e8.48bd216c.1804289383@sybase.com
From: John Smith
Newsgroups: sybase.public.powerbuilder.datawindow
Subject: Error while using composite type report object with Tabular DW
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48bd2372.7135.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub48bd2372"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 2 Sep 2008 04:28:50 -0700
X-Trace: forums-1-dub 1220354930 10.22.241.41 (2 Sep 2008 04:28:50 -0700)
X-Original-Trace: 2 Sep 2008 04:28:50 -0700, 10.22.241.41
Lines: 329
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87683
Article PK: 416937

Hi All,

I am using PB 10.5 Build 4523, I have created two datawindow
one with Tabular DW style and another one datawindow with
composite type. In Tabular DW will retrieve all the
department titles, based on the department code I am
retrieving composite datawindow report object. But while
doing that I am getting the following Error "Crosstab nested
report ---- has retrieval arguments and can be used only in
composites".

Can anyone help on this?

Thanks in advance for any help,

With Prayers & Regards,

John Smith T

pb_error.jpg

"John Olson [Team Sybase]" <john.olson Posted on 2008-09-02 17:44:48.0Z
From: "John Olson [Team Sybase]" <john.olson@nospam_teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48bd2372.7135.1681692777@sybase.com>
Subject: Re: Error while using composite type report object with Tabular DW
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48bd7b90@forums-1-dub>
Date: 2 Sep 2008 10:44:48 -0700
X-Trace: forums-1-dub 1220377488 10.22.241.152 (2 Sep 2008 10:44:48 -0700)
X-Original-Trace: 2 Sep 2008 10:44:48 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87685
Article PK: 416940

For more info on nesting crosstabs take a look at this thread:

http://groups.google.com/group/powersoft.public.powerbuilder.datawindow/browse_thread/thread/d4983f7246b9b03c/4f25bfdfa2522d5f?lnk=st&q=powerbuilder+%22can+be+used+only+in+composites%22#4f25bfdfa2522d5f

Regards,
John

<John Smith> wrote in message news:48bd2372.7135.1681692777@sybase.com...
> Hi All,
>
> I am using PB 10.5 Build 4523, I have created two datawindow
> one with Tabular DW style and another one datawindow with
> composite type. In Tabular DW will retrieve all the
> department titles, based on the department code I am
> retrieving composite datawindow report object. But while
> doing that I am getting the following Error "Crosstab nested
> report ---- has retrieval arguments and can be used only in
> composites".
>
> Can anyone help on this?
>
> Thanks in advance for any help,
>
> With Prayers & Regards,
>
> John Smith T
>


"John Olson [Team Sybase]" <john.olson Posted on 2008-09-02 17:27:20.0Z
From: "John Olson [Team Sybase]" <john.olson@nospam_teamsybase.com>
Newsgroups: sybase.public.powerbuilder.datawindow
References: <48bd2372.7135.1681692777@sybase.com>
Subject: Re: Error while using composite type report object with Tabular DW
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48bd7778@forums-1-dub>
Date: 2 Sep 2008 10:27:20 -0700
X-Trace: forums-1-dub 1220376440 10.22.241.152 (2 Sep 2008 10:27:20 -0700)
X-Original-Trace: 2 Sep 2008 10:27:20 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerbuilder.datawindow:87684
Article PK: 416941

Crosstabular DWs which take arguments can only be nested on composite DWs.
It seems to think you have a nested crosstab DW.

Regards,
John

<John Smith> wrote in message news:48bd2372.7135.1681692777@sybase.com...
> Hi All,
>
> I am using PB 10.5 Build 4523, I have created two datawindow
> one with Tabular DW style and another one datawindow with
> composite type. In Tabular DW will retrieve all the
> department titles, based on the department code I am
> retrieving composite datawindow report object. But while
> doing that I am getting the following Error "Crosstab nested
> report ---- has retrieval arguments and can be used only in
> composites".
>
> Can anyone help on this?
>
> Thanks in advance for any help,
>
> With Prayers & Regards,
>
> John Smith T
>