Executable File Variation

[unknown]

I created an executable file with several reports in it. I
added the .exe to another computer and one of the reports is
troublesome.

The report, when run on two different computers returns
different data. The report is written with one "group" of
data that is displayed entirely in the "trailer group"
section. The line items being queried may be repetitive
which is why I used a group so that I would only see the
repeated line item once in the trailer section. This report
works on my own PC, but when run on another, it displays the
repeated line items for each instance and does not limit the
"trailer group" to 'DISTINCT' line items as it should.
Any ideas? It seems strange that the same file operates
differently on different PC's.

-Dan

[Terry Dykstra [TeamSybase]]

Do you have a sort in the report itself (not the SQL) that matches the
group(s)?
--
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 created an executable file with several reports in it. I
added the .exe to another computer and one of the reports is
troublesome.
The report, when run on two different computers returns
different data. The report is written with one "group" of
data that is displayed entirely in the "trailer group"
section. The line items being queried may be repetitive
which is why I used a group so that I would only see the
repeated line item once in the trailer section. This report
works on my own PC, but when run on another, it displays the
repeated line items for each instance and does not limit the
"trailer group" to 'DISTINCT' line items as it should.
Any ideas? It seems strange that the same file operates
differently on different PC's.
-Dan

[unknown]

I did have a "group sort" specified in the properties tab of
the group. It was an unnecessary sort, so I removed it. I
have not been able to test it yet, will it make a
difference?
-Dan


Do you have a sort in the report itself (not the SQL) that

matches the group(s)?
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement

executable file with several reports in it. I added the
.exe to another computer and one of the reports is

troublesome. >

The report, when run on two different computers returns
different data. The report is written with one "group"
of data that is displayed entirely in the "trailer
group" section. The line items being queried may be
repetitive which is why I used a group so that I would
only see the repeated line item once in the trailer
section. This report works on my own PC, but when run
on another, it displays the repeated line items for each
instance and does not limit the "trailer group" to
'DISTINCT' line items as it should. Any ideas? It seems
strange that the same file operates differently on

different PC's. >

-Dan

[Terry Dykstra [TeamSybase]]

You don't want a group sort. That's typically only used for things like
'greatest salary' within a group, i.e. a sort based on aggregate functions.
Normally you want to sort at the report level (Menu: Rows, Sort). This sort
should match the group order.
--
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 did have a "group sort" specified in the properties tab of
the group. It was an unnecessary sort, so I removed it. I
have not been able to test it yet, will it make a
difference?
-Dan
Do you have a sort in the report itself (not the SQL) that

matches the group(s)?
--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement

executable file with several reports in it. I added the
.exe to another computer and one of the reports is

troublesome. >

The report, when run on two different computers returns
different data. The report is written with one "group"
of data that is displayed entirely in the "trailer
group" section. The line items being queried may be
repetitive which is why I used a group so that I would
only see the repeated line item once in the trailer
section. This report works on my own PC, but when run
on another, it displays the repeated line items for each
instance and does not limit the "trailer group" to
'DISTINCT' line items as it should. Any ideas? It seems
strange that the same file operates differently on

different PC's. >

-Dan