Arrival sequence sorting

building reports desktopintelligence
1

Listers,

I need a way to retrieve a Personal data file (Text) and have the results not pre-sort. Does anyone know a way to retrieve a document in Arrival Sequence???

Thanks in advance for you help

Tim Day
URM Stores, Inc
Spokane, Wa 99217
509.467.2726

Listserv Archives (BOB member since 2002-06-25)

2

In a message dated 00-01-21 11:05:07 EST, you write:

I need a way to retrieve a Personal data file (Text) and have the results not
pre-sort. Does anyone know a way to retrieve a document in Arrival
Sequence?
??

Tim:

I don’t believe that there is a way to turn of the default sorting. What you could do, perhaps, is simply add a “row number” column to the beginning of your data. This would accomplish two things:

  1. If the row number is the first column, then it becomes the default primary sort. So your data should be in “arrival order” as you suggested.

  2. Since the row number is guaranteed to be unique, you will not experience any default aggregation either.

If your text file comes from an external source, you could easily create a macro in Excel (or other spreadsheet of choice…) to open the file, create a row number column, and resave the file as text.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

Listserv Archives (BOB member since 2002-06-25)

3

Wha not use the BusinessObjects “Misc” function “RowIndex()”? You can add a column to our table with the formula “=RowIndex()” in there, then hide it from being displayed.

If you hide it but do not add it as your first column, you still can use it to put a sot on it.
This will sort on the order as retrieved from the database…

Hope this helps.
Walter

DRathbun@AOL.COM wrote:

In a message dated 00-01-21 11:05:07 EST, you write:

I need a way to retrieve a Personal data file (Text) and have the results not
pre-sort. Does anyone know a way to retrieve a document in Arrival
Sequence?
??

Tim:

I don’t believe that there is a way to turn of the default sorting. What you could do, perhaps, is simply add a “row number” column to the beginning of your data. This would accomplish two things:

  1. If the row number is the first column, then it becomes the default primary sort. So your data should be in “arrival order” as you suggested.
  1. Since the row number is guaranteed to be unique, you will not experience any default aggregation either.

If your text file comes from an external source, you could easily create a macro in Excel (or other spreadsheet of choice…) to open the file, create a row number column, and resave the file as text.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

OR search: Mail to listserv@listserv.aol.com, ‘search a_phrase in BUSOB-L’ Unsubscribe: Mail to listserv@listserv.aol.com, ‘unsubscribe BUSOB-L’

–
DI Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at

Listserv Archives (BOB member since 2002-06-25)