Discussion:
sorting computed fields
(too old to reply)
unknown
2008-09-12 17:25:28 UTC
Permalink
Good afternoon,
we are using infomaker 10.5 - we must create an additional
field to our system report - which is the simple summation
of the adjoining two columns.

However, its imperative that we get the column to sort,
please advise on what should be done.

Thank you.
Chris Pollach
2008-09-12 17:41:25 UTC
Permalink
Hi Lisa;

You have two choices ...

1) From the Report Painter .. enter the Data Source (SQL) Painter. In that
painter have a look at the Sort tab in the lower part of that dialog. Drag
the new column from the LHS to the RHS to add it to the sorting action. This
will amend the SQL statement when you close the dialog using the Return icon
on the 2nd toolbar.

- OR -

2) You can have IM sort the data after it comes back from the DBMS by
selecting the "Rows => Sort" menu in the open Report Painter. Then in the
Sort dialog, drag the new column from the LHS to the RHS and check the
Ascending option On/Off as required.

HTH
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by unknown
Good afternoon,
we are using infomaker 10.5 - we must create an additional
field to our system report - which is the simple summation
of the adjoining two columns.
However, its imperative that we get the column to sort,
please advise on what should be done.
Thank you.
Terry Dykstra
2008-09-15 15:51:28 UTC
Permalink
Just to clarify point 2 of Chris' comments:
You can sort on whatever you want to sort on, both regular columns and
computed fields. It does not have to be an existing computed field either.
Simply drag any column to the right, doubleclieck it an d change it's
expression to whatever you need.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by Chris Pollach
Hi Lisa;
You have two choices ...
1) From the Report Painter .. enter the Data Source (SQL) Painter. In that
painter have a look at the Sort tab in the lower part of that dialog. Drag
the new column from the LHS to the RHS to add it to the sorting action.
This will amend the SQL statement when you close the dialog using the
Return icon on the 2nd toolbar.
- OR -
2) You can have IM sort the data after it comes back from the DBMS by
selecting the "Rows => Sort" menu in the open Report Painter. Then in the
Sort dialog, drag the new column from the LHS to the RHS and check the
Ascending option On/Off as required.
HTH
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by unknown
Good afternoon,
we are using infomaker 10.5 - we must create an additional
field to our system report - which is the simple summation
of the adjoining two columns.
However, its imperative that we get the column to sort,
please advise on what should be done.
Thank you.
unknown
2008-09-15 16:02:50 UTC
Permalink
We were able to try your second suggestions - however the
column still did not sort.

In regards to the database painter - How do i get that sort
tab to appear? I had the infomaker file open, i clicked on
Tools -> Database Painter and a new window opened. We then
found the procedure associated with the infomaker file - and
still no sort tab is available? Where do i find it?

Thank you.
-Lisa
Post by Chris Pollach
Hi Lisa;
You have two choices ...
1) From the Report Painter .. enter the Data Source (SQL)
Painter. In that painter have a look at the Sort tab in
the lower part of that dialog. Drag the new column from
the LHS to the RHS to add it to the sorting action. This
will amend the SQL statement when you close the dialog
using the Return icon on the 2nd toolbar.
- OR -
2) You can have IM sort the data after it comes back from
the DBMS by selecting the "Rows => Sort" menu in the open
Report Painter. Then in the Sort dialog, drag the new
column from the LHS to the RHS and check the Ascending
option On/Off as required.
HTH
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by unknown
Good afternoon,
we are using infomaker 10.5 - we must create an
additional field to our system report - which is the
simple summation of the adjoining two columns.
However, its imperative that we get the column to sort,
please advise on what should be done.
Thank you.
Terry Dykstra
2008-09-15 17:04:15 UTC
Permalink
Did you pull the records first? You need records before you can sort in the
db-painter. They should be in the results tab.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
We were able to try your second suggestions - however the
column still did not sort.
In regards to the database painter - How do i get that sort
tab to appear? I had the infomaker file open, i clicked on
Tools -> Database Painter and a new window opened. We then
found the procedure associated with the infomaker file - and
still no sort tab is available? Where do i find it?
Thank you.
-Lisa
Post by Chris Pollach
Hi Lisa;
You have two choices ...
1) From the Report Painter .. enter the Data Source (SQL)
Painter. In that painter have a look at the Sort tab in
the lower part of that dialog. Drag the new column from
the LHS to the RHS to add it to the sorting action. This
will amend the SQL statement when you close the dialog
using the Return icon on the 2nd toolbar.
- OR -
2) You can have IM sort the data after it comes back from
the DBMS by selecting the "Rows => Sort" menu in the open
Report Painter. Then in the Sort dialog, drag the new
column from the LHS to the RHS and check the Ascending
option On/Off as required.
HTH
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by unknown
Good afternoon,
we are using infomaker 10.5 - we must create an
additional field to our system report - which is the
simple summation of the adjoining two columns.
However, its imperative that we get the column to sort,
please advise on what should be done.
Thank you.
unknown
2008-09-15 18:30:43 UTC
Permalink
I generated an execute statement and ran the results - and
we got output - however the sort tab still does not appear.

my question is however for the user - when the user runs the
report in Tessitura (the front end application) they need to
be able to sort the column, so we have to program that the
computed field is sortable. please advise.
Post by Terry Dykstra
Did you pull the records first? You need records before
you can sort in the db-painter. They should be in the
results tab.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
We were able to try your second suggestions - however
the column still did not sort.
In regards to the database painter - How do i get that
sort tab to appear? I had the infomaker file open, i
clicked on Tools -> Database Painter and a new window
opened. We then found the procedure associated with the
infomaker file - and still no sort tab is available?
Where do i find it? >
Post by unknown
Thank you.
-Lisa
Post by Chris Pollach
Hi Lisa;
You have two choices ...
1) From the Report Painter .. enter the Data Source
(SQL) >> Painter. In that painter have a look at the Sort
tab in >> the lower part of that dialog. Drag the new
column from >> the LHS to the RHS to add it to the sorting
action. This >> will amend the SQL statement when you
close the dialog >> using the Return icon on the 2nd
toolbar. >>
Post by unknown
Post by Chris Pollach
- OR -
2) You can have IM sort the data after it comes back
from >> the DBMS by selecting the "Rows => Sort" menu in
the open >> Report Painter. Then in the Sort dialog, drag
the new >> column from the LHS to the RHS and check the
Ascending >> option On/Off as required.
Post by unknown
Post by Chris Pollach
HTH
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by unknown
Good afternoon,
we are using infomaker 10.5 - we must create an
additional field to our system report - which is the
simple summation of the adjoining two columns.
However, its imperative that we get the column to
sort, >> > please advise on what should be done.
Post by unknown
Post by Chris Pollach
Post by unknown
Thank you.
Terry Dykstra
2008-09-15 19:24:32 UTC
Permalink
In the db painter, after you retrieve the records, click anywhere within the
results view and then the menu option 'Rows, Sort' becomes available. The
menus are enabled/disabled depending what the current view is. Sometimes
you need to "wakeup" PB/IM to tell it what the current view is.

Regarding your user, that's a Tessitura problem. If Tessitura calls the
native PowerBuilder dw.sort() command, you will get the standard dialog that
PowerBuilder/InfoMaker use.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
I generated an execute statement and ran the results - and
we got output - however the sort tab still does not appear.
my question is however for the user - when the user runs the
report in Tessitura (the front end application) they need to
be able to sort the column, so we have to program that the
computed field is sortable. please advise.
Post by Terry Dykstra
Did you pull the records first? You need records before
you can sort in the db-painter. They should be in the
results tab.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
We were able to try your second suggestions - however
the column still did not sort.
In regards to the database painter - How do i get that
sort tab to appear? I had the infomaker file open, i
clicked on Tools -> Database Painter and a new window
opened. We then found the procedure associated with the
infomaker file - and still no sort tab is available?
Where do i find it? >
Post by unknown
Thank you.
-Lisa
Post by Chris Pollach
Hi Lisa;
You have two choices ...
1) From the Report Painter .. enter the Data Source
(SQL) >> Painter. In that painter have a look at the Sort
tab in >> the lower part of that dialog. Drag the new
column from >> the LHS to the RHS to add it to the sorting
action. This >> will amend the SQL statement when you
close the dialog >> using the Return icon on the 2nd
toolbar. >>
Post by unknown
Post by Chris Pollach
- OR -
2) You can have IM sort the data after it comes back
from >> the DBMS by selecting the "Rows => Sort" menu in
the open >> Report Painter. Then in the Sort dialog, drag
the new >> column from the LHS to the RHS and check the
Ascending >> option On/Off as required.
Post by unknown
Post by Chris Pollach
HTH
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by unknown
Good afternoon,
we are using infomaker 10.5 - we must create an
additional field to our system report - which is the
simple summation of the adjoining two columns.
However, its imperative that we get the column to
sort, >> > please advise on what should be done.
Post by unknown
Post by Chris Pollach
Post by unknown
Thank you.
unknown
2008-09-17 14:48:27 UTC
Permalink
Thank you,
What we actually need is to make the column in infomaker
sortable. For example if a column that's returned by the
procedure is in the infomaker file - we add the suffix _t to
the header and that column becomes sortable - however that
doesn't work for computed fields.

I believe that the _t is something thats not actually part
of infomaker - and someone coded that on later on, and so we
want to find out where can find what that person did so we
can do the same for computed fields.

All we have to do is say -- compute_1 (which is columnA +
columnbB) and when the report returns it in Tessitura the
user can click the header of the column and it can be
sorted.

Thank you
-Lisa
Post by Terry Dykstra
In the db painter, after you retrieve the records, click
anywhere within the results view and then the menu option
'Rows, Sort' becomes available. The menus are
enabled/disabled depending what the current view is.
Sometimes you need to "wakeup" PB/IM to tell it what the
current view is.
Regarding your user, that's a Tessitura problem. If
Tessitura calls the native PowerBuilder dw.sort() command
, you will get the standard dialog that
PowerBuilder/InfoMaker use.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
I generated an execute statement and ran the results -
and we got output - however the sort tab still does not
appear. >
Post by unknown
my question is however for the user - when the user runs
the report in Tessitura (the front end application) they
need to be able to sort the column, so we have to
program that the computed field is sortable. please
advise. >
Post by unknown
Post by Terry Dykstra
Did you pull the records first? You need records
before >> you can sort in the db-painter. They should be
in the >> results tab.
Post by unknown
Post by Terry Dykstra
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
We were able to try your second suggestions - however
the column still did not sort.
In regards to the database painter - How do i get
that >> > sort tab to appear? I had the infomaker file
open, i >> > clicked on Tools -> Database Painter and a
new window >> > opened. We then found the procedure
associated with the >> > infomaker file - and still no
sort tab is available? >> Where do i find it? >
Post by unknown
Post by Terry Dykstra
Post by unknown
Thank you.
-Lisa
Post by Chris Pollach
Hi Lisa;
You have two choices ...
1) From the Report Painter .. enter the Data Source
(SQL) >> Painter. In that painter have a look at the
Sort >> tab in >> the lower part of that dialog. Drag the
new >> column from >> the LHS to the RHS to add it to the
sorting >> action. This >> will amend the SQL statement
when you >> close the dialog >> using the Return icon on
the 2nd >> toolbar. >>
Post by unknown
Post by Terry Dykstra
Post by unknown
Post by Chris Pollach
- OR -
2) You can have IM sort the data after it comes back
from >> the DBMS by selecting the "Rows => Sort" menu
in >> the open >> Report Painter. Then in the Sort dialog
, drag >> the new >> column from the LHS to the RHS and
check the >> Ascending >> option On/Off as required.
Post by unknown
Post by Terry Dykstra
Post by unknown
Post by Chris Pollach
HTH
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by unknown
Good afternoon,
we are using infomaker 10.5 - we must create an
additional field to our system report - which is
the >> >> > simple summation of the adjoining two columns.
Post by unknown
Post by Terry Dykstra
Post by unknown
Post by Chris Pollach
Post by unknown
However, its imperative that we get the column to
sort, >> > please advise on what should be done.
Post by unknown
Post by Chris Pollach
Post by unknown
Thank you.
Terry Dykstra
2008-09-17 19:07:40 UTC
Permalink
It's a Tessitura issue. That's a PB application where they wrote their own
sort routine when you click on a column header. Tessitura is not taking
computed fields into account, even though PowerBuilder supports sorting
based on computed fields. It's not an InfoMaker issue. You have to take it
up with the Tessitura folks.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
Thank you,
What we actually need is to make the column in infomaker
sortable. For example if a column that's returned by the
procedure is in the infomaker file - we add the suffix _t to
the header and that column becomes sortable - however that
doesn't work for computed fields.
I believe that the _t is something thats not actually part
of infomaker - and someone coded that on later on, and so we
want to find out where can find what that person did so we
can do the same for computed fields.
All we have to do is say -- compute_1 (which is columnA +
columnbB) and when the report returns it in Tessitura the
user can click the header of the column and it can be
sorted.
Thank you
-Lisa
Post by Terry Dykstra
In the db painter, after you retrieve the records, click
anywhere within the results view and then the menu option
'Rows, Sort' becomes available. The menus are
enabled/disabled depending what the current view is.
Sometimes you need to "wakeup" PB/IM to tell it what the
current view is.
Regarding your user, that's a Tessitura problem. If
Tessitura calls the native PowerBuilder dw.sort() command
, you will get the standard dialog that
PowerBuilder/InfoMaker use.
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
I generated an execute statement and ran the results -
and we got output - however the sort tab still does not
appear. >
Post by unknown
my question is however for the user - when the user runs
the report in Tessitura (the front end application) they
need to be able to sort the column, so we have to
program that the computed field is sortable. please
advise. >
Post by unknown
Post by Terry Dykstra
Did you pull the records first? You need records
before >> you can sort in the db-painter. They should be
in the >> results tab.
Post by unknown
Post by Terry Dykstra
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement
Post by unknown
We were able to try your second suggestions - however
the column still did not sort.
In regards to the database painter - How do i get
that >> > sort tab to appear? I had the infomaker file
open, i >> > clicked on Tools -> Database Painter and a
new window >> > opened. We then found the procedure
associated with the >> > infomaker file - and still no
sort tab is available? >> Where do i find it? >
Post by unknown
Post by Terry Dykstra
Post by unknown
Thank you.
-Lisa
Post by Chris Pollach
Hi Lisa;
You have two choices ...
1) From the Report Painter .. enter the Data Source
(SQL) >> Painter. In that painter have a look at the
Sort >> tab in >> the lower part of that dialog. Drag the
new >> column from >> the LHS to the RHS to add it to the
sorting >> action. This >> will amend the SQL statement
when you >> close the dialog >> using the Return icon on
the 2nd >> toolbar. >>
Post by unknown
Post by Terry Dykstra
Post by unknown
Post by Chris Pollach
- OR -
2) You can have IM sort the data after it comes back
from >> the DBMS by selecting the "Rows => Sort" menu
in >> the open >> Report Painter. Then in the Sort dialog
, drag >> the new >> column from the LHS to the RHS and
check the >> Ascending >> option On/Off as required.
Post by unknown
Post by Terry Dykstra
Post by unknown
Post by Chris Pollach
HTH
--
Regards ... Chris
ISUG - NA RUG Director
http://chrispollach.pbdjmagazine.com
Post by unknown
Good afternoon,
we are using infomaker 10.5 - we must create an
additional field to our system report - which is
the >> >> > simple summation of the adjoining two columns.
Post by unknown
Post by Terry Dykstra
Post by unknown
Post by Chris Pollach
Post by unknown
However, its imperative that we get the column to
sort, >> > please advise on what should be done.
Post by unknown
Post by Chris Pollach
Post by unknown
Thank you.
Loading...