Is is possible to sort on one item, but report another–for example, a size scale may be S, M, L, and XL (the order we want to see it), but an alpha sort on this field would give the wrong order (however, sorting on a sequence number associated with each size gives the correct order but we don’t want to see the seq#!).
Listserv Archives (BOB member since 2002-06-25)
You can display the seq # anywhere in the report, then sort on it. Then just make the seq # field invisible. We have done this by just making the text color white and then shrinking up the column as thin as we can get it.
Amy
Alice Harper aharper@UNIONBAY.COM 09/10/1998 03:58pm >>>
Is is possible to sort on one item, but report another–for example, a size scale may be
S, M, L, and XL (the order we want to see it), but an alpha sort on this field would give the wrong order (however, sorting on a sequence number associated with each size gives the correct order but we don’t want to see the seq#!).
Listserv Archives (BOB member since 2002-06-25)
In Format…Sorts you can click on the box that says Custom… and then choose Values… From there, you can dictate the order you want them sorted, like S, M, L, and XL.
Maria D. Carter 
BusinessObjects Developer
mcarter@gbncmail.ims.att.com
Is is possible to sort on one item, but report another–for example, a size scale may be
S, M, L, and XL (the order we want to see it), but an alpha sort on this field would give the wrong order (however, sorting on a sequence number associated with each size gives the correct order but we don’t want to see the seq#!).
Listserv Archives (BOB member since 2002-06-25)
Alice Harper writes:
Is is possible to sort on one item, but report another.
Alice,
Try sorting on the sequence number, then hiding it.
Click on the table then menu: Format - Table. Choose the “Pivot” tab. Select the variable, in your case “Seq Number”, and select “Hide”.
Hope this helps,
Shawn Leven
Southwestern Bell
Information Services
SL7699@SBC.COM
Listserv Archives (BOB member since 2002-06-25)
Is is possible to sort on one item, but report another
There are two ways I have used. The first is to show the sequence number in the report but change the text colour to white (or hide it). The second is to define all the sorts for the report in the data provider instead of the report. You put a sort on the sequence number then on the description field and this should order a report including only the description field in its data provider in the correct order.
Louise Priest
Fraser Williams Pharma Systems
Listserv Archives (BOB member since 2002-06-25)
Hello Alice,
Alice Harper wrote:
Is is possible to sort on one item, but report another–for example, a size scale may be S, M, L, and XL (the order we want to see it), but an alpha sort on this field would give the wrong order (however, sorting on a sequence number associated with each size gives the correct order but we don’t want to see the seq#!).
There are two ways in which your requirement can be met. I will enunciate both of them.
Method 1: Using Custom sort
Listserv Archives (BOB member since 2002-06-25)
You can place a sort on the size and then choose format sorts from the tool part. Select the appropriate sort and then choose customize. Then you can move the data into any sort order you wish.
Kasey Quigley
The BOC Group
______________________________ Reply Separator _________________________________
Listserv Archives (BOB member since 2002-06-25)
Alice,
We have had to do something similar at our project. In our case we had to set up the object to be viewed as a master section. You could choose to have it anywhere in the report. Follow the steps below:
Samita Chitre
Braun Technology Group
Senior Consultant
251 North Illinois Street, Suite 1210
Indianapolis, IN 46204
Tel: (317)-822-4507
Listserv Archives (BOB member since 2002-06-25)
Note that you can hide columns in a table – right mouse click on the edge of the selected table, go to the “pivot” tab, right mouse click on the column you want to hide.
Timo
You can display the seq # anywhere in the report, then sort on it. Then just make the seq # field invisible. We have done this by just making the text color white and then shrinking up the column as thin as we can get it.
Listserv Archives (BOB member since 2002-06-25)
** Reply to note from Alice Harper aharper@UNIONBAY.COM on Thu, 10 Sep 1998 12:58:59 -0700
Just do a custom sort on the size scale putting them in the order you want . Select field sort function custom sort and arrange them how you want
Is is possible to sort on one item, but report another–for example, a size
scale may be
S, M, L, and XL (the order we want to see it), but an alpha sort on this
field would give the wrong order (however, sorting on a sequence number associated with each size gives the correct order but we don’t want to see the seq#!).
For old 3.1 info: Penn: Page not found
Search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’ Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
Larry A. Dick , Computer Specialist 11 Sep 98 12:00:47
NIST Bldg 225 Room B217 Gaithersburg MD 20899 301-975-4186
OS/2 Jstreet Beta
11th commandment - Covet not thy neighbor’s Pentium.
Listserv Archives (BOB member since 2002-06-25)
You can sort on the seq# and then just hide the column on the report. To do that just select the table and select format/table from the menu. Click on the Pivot tab and click on the seq# in the used variables box and click hide. For further information check “Hide data in a table, crosstab or chart” in the online help.
Date sent: Thu, 10 Sep 1998 12:58:59 -0700
Is is possible to sort on one item, but report another–for example, a size scale may be S, M, L, and XL (the order we want to see it), but an alpha sort on this field would give the wrong order (however, sorting on a sequence number associated with each size gives the correct order but we don’t want to see the seq#!).
For old 3.1 info: Penn: Page not found
Search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’ Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
Shannon Lee Wittal
swittal@qgraph.com
Listserv Archives (BOB member since 2002-06-25)
Hi Shawn,
I’ve tried this with the names of the day’s in the week. Hiding the value wich holds the number of the day resetted the sorting to alpha sort of the weekdays. So I have to display the names.
greetings
hans
************************************************************* Hans Kingma
Unisource Carrier Services
Industriestrasse 21
8304 Wallisellen
Switzerland
Phone: +41 1 839 32 11
Fax: +41 1 839 32 95
Alice Harper writes:
Is is possible to sort on one item, but report another.
Alice,
Try sorting on the sequence number, then hiding it.
Click on the table then menu: Format - Table. Choose the “Pivot” tab.
Select the variable, in your case “Seq Number”, and select “Hide”.
Hope this helps,
Shawn Leven
Southwestern Bell
Information Services
SL7699@SBC.COM
Pls report bounces in response to postings to BUSOB-L-Request@listserv.aol.com
For old 3.1 info:
Penn: Page not found
Search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’
Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’
Listserv Archives (BOB member since 2002-06-25)