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:
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
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
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.
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
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
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.
From: "Terry Dykstra" <firstname.lastname@example.org>
Subject: Welcome to Infomaker Newsgroup
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Thu, 12 Jun 1997 17:18:02 -0400
Xref: forums-1-dub sybase.public.infomaker.general:7525
Article PK: 244580
Welcome to the Powersoft Infomaker forum! We hope that
Date: Tue, 12 Jun 2001 18:28:08 -0400
Subject: Help with sorting a column in a crosstab report
Content-Type: text/plain; charset="us-ascii"
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:
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)