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

2 posts in PB Infomaker Report Writer Last posting was on 1999-02-05 03:34:43.0Z
Sat Pal Posted on 1999-02-03 13:47:06.0Z
Newsgroups: sybase.public.infomaker.general
From: "Sat Pal" <pal@pilot.msu.edu>
Subject: Crosstab
Date: Wed, 3 Feb 1999 08:47:06 -0500
Lines: 15
Organization: Michigan State University
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <348_7viF6v3T#GA.224@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:6586
Article PK: 241575

I will appreciate help with the following:

1. I have a composite report that contains only a report title header and a
couple of reports included in it. The composite report has a couple of
retrieval arguments defined which are passed to the embedded reports. Is
there a way to display the retrieval arguments in the container report
(along with the title) ?

2. Is there a system function/variable that gives the userid/username of the
user signed on to the system.

Thanks.
SP


Terry Dykstra (TeamPS) Posted on 1999-02-05 03:34:43.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra (TeamPS)" <dont_spam_me_tdykstra@cfol.ab.ca>
Subject: Re: Crosstab
Date: Thu, 4 Feb 1999 20:34:43 -0700
Lines: 35
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <348_Pfg6pmLU#GA.209@forums.powersoft.com>
References: <348_7viF6v3T#GA.224@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:6582
Article PK: 241568

You cannot directly place computed fields on a composite report, but there
is a workaround:
use the 'todays date' button and place that on the report. This is really
a computed field. Just edit this field and replace it with your argument
(:my_arg or whatever it is called).

If you're looking for the database userid, you are dependent on the
functions of the database. For instance, in Oracle you would use the 'user'
function in your select.
If you want to have the Operating System userid, there is no direct way.
Using Powerbuilder you can create a global function that will get the logon
id. Let me know which version of IM you are using, and I can build this
function for you.
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.

Sat Pal wrote in message <7viF6v3T#GA.224@forums.powersoft.com>...
>I will appreciate help with the following:
>
>1. I have a composite report that contains only a report title header and a
>couple of reports included in it. The composite report has a couple of
>retrieval arguments defined which are passed to the embedded reports. Is
>there a way to display the retrieval arguments in the container report
>(along with the title) ?
>
>2. Is there a system function/variable that gives the userid/username of
the
>user signed on to the system.
>
>Thanks.
>SP
>
>