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 reports

2 posts in PB Infomaker Report Writer Last posting was on 1998-01-16 18:48:29.0Z
Errol Conaghan Posted on 1998-01-16 00:51:40.0Z
Newsgroups: sybase.public.infomaker.general
Date: Fri, 16 Jan 1998 13:51:40 +1300
From: Errol Conaghan <e.conaghan@nzdri.org.nz>
Reply-To: e.conaghan@nzdri.org.nz
Organization: New Zealand Dairy Research Institute
X-Mailer: Mozilla 3.04Gold (WinNT; I)
MIME-Version: 1.0
Subject: Crosstab reports
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 19
Message-ID: <348_34BEAF1C.4620@nzdri.org.nz>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7320
Article PK: 244376

I have developed a dynamic crosstab report where the number of columns
varies from time to time as the report is run. The report is in a
spreadsheet layout with sample numbers in the rows and test reults in
the columns.

At present my report goes off the right hand end of the page and then
just prints as an extra page without any headings.

I would like to define the number of columns across the page and have
the extra columns then report below the initial columns with the
repaeting of data like sample numbers.

Example. Test 1 Test 2 Test 3 Test 4

Sample 1 6.2 12.5 15.2 20.6

Sample 2 4.1 3.2 6.5 9.5

Test 5 Test 6

Sample 1 3.2 6.4

Sample 2 2.6 8.4


Regards


Errol Conaghan


Terry Dykstra [TeamPS] Posted on 1998-01-16 18:48:29.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <tdykstra@cfol.ab.ca>
Subject: Re: Crosstab reports
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Fri, 16 Jan 1998 13:48:29 -0500
Lines: 26
Message-ID: <348_01bd22b8$632a8620$8366e4cf@tdykstra.cfol.ab.ca>
References: <348_34BEAF1C.4620@nzdri.org.nz>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7319
Article PK: 244375

Unfortunately, you cannot do that. It will always print the columns on a
2nd page.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Errol Conaghan <e.conaghan@nzdri.org.nz> wrote in article
<34BEAF1C.4620@nzdri.org.nz>...
> I have developed a dynamic crosstab report where the number of columns
> varies from time to time as the report is run. The report is in a
> spreadsheet layout with sample numbers in the rows and test reults in
> the columns.
>
> At present my report goes off the right hand end of the page and then
> just prints as an extra page without any headings.
>
> I would like to define the number of columns across the page and have
> the extra columns then report below the initial columns with the
> repaeting of data like sample numbers.
>
> Example. Test 1 Test 2 Test 3 Test 4
>
> Sample 1 6.2 12.5 15.2 20.6
>
> Sample 2 4.1 3.2 6.5 9.5
>
> Test 5 Test 6
>
> Sample 1 3.2 6.4
>
> Sample 2 2.6 8.4
>
>
> Regards
>
>
> Errol Conaghan
>