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.

IM5 Args and Sub Reports

2 posts in PB Infomaker Report Writer Last posting was on 1998-07-09 18:21:54.0Z
Richard Carde Posted on 1998-07-09 09:27:10.0Z
Newsgroups: sybase.public.infomaker.general
From: "Richard Carde" <richard.carde@newham.gov.uk>
Subject: IM5 Args and Sub Reports
Date: Thu, 9 Jul 1998 10:27:10 +0100
Lines: 39
X-Newsreader: Microsoft Outlook Express 4.72.3007.0
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3007.0
Message-ID: <348_5tglvLxq9GA.189@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7010
Article PK: 243041

I have just started using IM5.04 and producing reports.

I have an MS Access background when it comes to creating DB reports. I am
used to being able to provide a custom form to prompt users for search
criteria. After reading through various news articles here, I have pretty
much come to the conclusion that this is not possible in IM5 and am using
Retrieval Arguments.

I have some reports that I want to print based on a start_date, end_date and
Location(s). I have used specified the first two as datetime with no
problems and the Locations as a String Array. I can pickup the locations in
the WHERE clause using (:Locations) without a problem.

But when it comes to using these Arrays anywhere else, I get stuck. The
locations are three-character codes each. The problems:

1. I would like to print the Locations in the Report Header ??

2. I am using Oracle 7.3 DB and it's case sensitive in it's searches - the
codes are stored in Uppercase. I cannot seem to use Upper( (:Locations) )
in the where clause??

3. I have a statistics report which prints various Averages across the DB.
I use a main report with a number of sub reports in the header (no detail).
These subreports all take the above 3 arguments (start, end, location) and
are set as Retrieval Args. I can place the Start and End date as Arguments
for the retrieval (Arguments property of the SubReport), but it's not
letting me place the Locations argument. (Expression is not valid) - even
though it appears in the drop down????

Anyone help?


Terry Dykstra [TeamPS] Posted on 1998-07-09 18:21:54.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: IM5 Args and Sub Reports
Date: Thu, 9 Jul 1998 12:21:54 -0600
Lines: 60
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_f#2sqz1q9GA.151@forums.powersoft.com>
References: <348_5tglvLxq9GA.189@forums.powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7004
Article PK: 243031

Oracle's upper function doesn't handle arrays very well:
In SQL/Plus:
SELECT TARIFF_ID,CREATED_BY
FROM BASE_TARIFF
WHERE TARIFF_ID in upper( 'border int','border frm' )
fails with ORA-00909: invalid number of arguments

IM won't allow you to create a computed field using the string array
retrieval argument. I don't know why.
Not being able to pass string arrays to a nested report is a long standing
issue. In IM6 they cleaned it up so the argument doesn't even show up as a
valid option, as it doesn in IM5.

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

Richard Carde wrote in message <5tglvLxq9GA.189@forums.powersoft.com>...
>I have just started using IM5.04 and producing reports.
>
>I have an MS Access background when it comes to creating DB reports. I am
>used to being able to provide a custom form to prompt users for search
>criteria. After reading through various news articles here, I have pretty
>much come to the conclusion that this is not possible in IM5 and am using
>Retrieval Arguments.
>
>I have some reports that I want to print based on a start_date, end_date
and
>Location(s). I have used specified the first two as datetime with no
>problems and the Locations as a String Array. I can pickup the locations
in
>the WHERE clause using (:Locations) without a problem.
>
>But when it comes to using these Arrays anywhere else, I get stuck. The
>locations are three-character codes each. The problems:
>
>1. I would like to print the Locations in the Report Header ??
>
>2. I am using Oracle 7.3 DB and it's case sensitive in it's searches - the
>codes are stored in Uppercase. I cannot seem to use Upper( (:Locations) )
>in the where clause??
>
>3. I have a statistics report which prints various Averages across the DB.
>I use a main report with a number of sub reports in the header (no detail).
>These subreports all take the above 3 arguments (start, end, location) and
>are set as Retrieval Args. I can place the Start and End date as Arguments
>for the retrieval (Arguments property of the SubReport), but it's not
>letting me place the Locations argument. (Expression is not valid) - even
>though it appears in the drop down????
>
>Anyone help?
>
>
>
>
>
>
>
>