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.

Welcome to Infomaker Newsgroup

2 posts in PB Infomaker Report Writer Last posting was on 2001-06-12 22:28:08.0Z
Terry Dykstra Posted on 1997-06-12 21:18:02.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Welcome to Infomaker Newsgroup
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Thu, 12 Jun 1997 17:18:02 -0400
Lines: 113
Message-ID: <348_01bc777e$aa610180$8366e4cf@terrywork.cfol.ab.ca>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7525
Article PK: 244580

Welcome to the Powersoft Infomaker forum! We hope that
you find the forum a useful place to exchange information concerning
the use of Infomaker that will enable you to use it to greater
potential. To ensure that we all receive the greatest benefit from
the forum, we have a few guidelines concerning its use:

Forum Purpose
--------------------

This forum was established by Powersoft as a means of providing a
vehicle for its customers and prospects to openly and freely exchange
information and ideas. It is neither an alternative to, nor a
replacement for a Customer Support Contract.

1. This is NOT a PS technical support forum and it is not the purpose
of this forum to allow customers to get free technical support from
PS. It is a place for users to help each other and exchange problems
solutions, information, ideas, etc.

2. PS has no obligation to provide questions, problems, or provide
anything other than a moderator to monitor the forum and insure its
operation and availability, exchange problems solutions, information,
ideas, etc. They do strive, however, to do much more than that as
resources permit.

3. PS executives do monitor the forum to observe customer reaction to
the product, keep up with users thoughts for new features, or offer
executive opinions and viewpoints. Powersoft Technical Advisors
(TAs) also assist on the forum when they have time available. They
will offer help but may not be available on a regular basis based on
their workload.

4. Powersoft has selected a technically astute group of users to
offer assistance to other PowerBuilder users. The name of this group
is Team Powersoft (TeamPS). The moderator of this group, Terry
Dykstra, is a member of that group. Neither he nor the other
members of TeamPS are Powersoft employees, nor are they paid for their
services in maintaining the forum. And, while they may answer
questions in the forum from time to time, they are not responsible for
ensuring that all questions receive answers.

Guidelines
--------------

Please bear in mind that this is a moderated forum. As a result, it
operates somewhat differently than a typical unmoderated newsgroup.

1. If youre using a company id, please post your name at the end of
the message so that others may know who to address when sending an
response. We would appreciate you using your full (real) name.

2. Please post the same question once in the forum that appears most
appropriate and allow 36-72 hours for a response.

3. Advertising of any kind should be limited to the forums dedicated
to that purpose (i.e., news.3rd_party_products, news.job_postings,
etc.). Spamming of the forum will not be tolerated.

4. Profanity, obscenities, and abuse of forum members will not be
tolerated.

5. Please refrain from sending "thanks" in the forum. Anyone
desiring to thank the person assisting them should feel free to do so,
but we would ask that this be done via e-mail to minimize traffic and
allow members to review both problems and solutions.

6. Please refrain from sending personal messages in the forum. These
conversations are more properly carried on in e-mail.

7. This forum is not particularly designed for the transfer of files.
Therefore, if you need to make files accessable to other people,
please handle it through private email or by making the file available
on an ftp site. Extremely large messages, particularly those
containing embedded files, will be deleted without notice.

8. Please put specifics on the message header(not "Help", "Bug", or
vague subject headers). People often only review headers for messages
they are interested in. This is in your best interest in getting the
most out of your message posting.

9. Please do not ask more than one question per message. If you have
five questions, please post five messages. That way, duplication of
answers for one problem and overlooked questions will be minimized.

10. When replying, ALWAYS include part of the message in your reply.
Some of us CAN'T remember what happened five minutes ago, let alone
yesterday.

11. The forum is primarily intended to assist Infomaker end-users
in obtaining the maximum benefit from the product. It is not intended
for more general discussions, such as features of various products,
product comparisions, etc. Please post messages of that type in more
appropriate arenas, such as an public, unmoderated newsgroup.


brent.peterson Posted on 2001-06-12 22:28:08.0Z
Newsgroups: sybase.public.infomaker.general
From: brent.peterson@state.mn.us
Date: Tue, 12 Jun 2001 18:28:08 -0400
Subject: Help with sorting a column in a crosstab report
Lines: 45
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <348_F6B712FE93D56119007B6CDA85256A69.005C210185256863@webforums>
References: <348_01bc777e$aa610180$8366e4cf@terrywork.cfol.ab.ca>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.infomaker.general:3338
Article PK: 238850

We have created a fairly complicated crosstab report,
and have run into a major problem.

The crosstab report has one column in the "column" setup (and
several rows and one "value"), called u_name_report.
This column contains say 10-15 different values
on any given report.

The problem is that the columns must appear in a specified order.

Knowing that InfoMaker sorts crosstab columns alphabetically,
we put a sorting "code" into the first 3 characters of the field,
for example: A10Total Solids, A20%Fat, A30Solids Not Fat, etc.

(these columns should appear as Total Solids, %Fat, Solids Not Fat, etc.)

Then, in the crosstab column definition, we set it up as the following:
computed field:

right(u_name_report, len(u_name_report)-3)


This seemed like the perfect solution, until we realised that
infomaker then sorts this column in alphabetical order, after having
already truncated off the 1st 3 characters, giving us back the original
order we started with.

Do you know of any possible way to be able to sort the "previewed"
columns of a single crosstab column in a specified way???

Static crosstab reports are not a viable option, as there could be
say 200-300 possible column arrangements (and having a separate report
for each one is not practical).

Are we missing something? Is there a way to get infomaker to
do what we need?

All comments and advice would be greatly appreciated.

Thanks in advance,

Kimberly Weldon (Thermo LabSystems)
Brent Peterson (Minnesota Dept. of Agriculture)