Qdesign - Sorting Question

[Whittall, Conrad]

Hi Catherine,

I'm assuming you're not using a relational database, otherwise you could
have simply added an ORDERBY clause to the ACCESS statement in your QDESIGN.

So, why not just use a QUIZ report, run on-line (initiated from a QUICK
screen that the user already has access to), and formatted for the user's
terminal -- 80 columns by 23/24 lines (depending on your standard screen
size)? That way you can extract the data from your database, sort it into
the required order, and format it for display -- even putting sort break
header/footers and PRINT AT clauses in if you like.

Best regards,
Conrad

Conrad Whittall
e-Learning Architect, Global Education Services
Cognos Incorporated, 3755 Riverside Drive, Ottawa, Ontario, K1G 4K9, Canada

>  -----Original Message-----
> From: 	Catherine Litten [mailto:catherine.litten@valleypres.org] 
> Sent:	Wednesday 30 October 2002 13:42
> To:	Powerhouse List Server
> Subject:	Qdesign - Sorting Question
> 
> I am rather stagnant in my use of QDesign - I usually develop simple
> screens with little more than redefines of data and data population based
> on user responses.  However, this time I have a user that wants a screen
> that is really much like a report.  This is just a find screen that lists
> who is on suspension (usually less than a screen full)  They would like
> this in alpha order by last name and name is not a key field.  
> 
> Any recommendations on how to show the data sorted the way they like
> (usually I just tell them they need a quiz report instead of a screen)
> without changing the structure of the database?
> 
> Thank you,
> Catherine
> 
> 
> 
> *****************************
> Catherine Litten, Sr. Programmer/Analyst, Valley Presbyterian Hospital 
>  15107 Vanowen Street, Van Nuys, CA 91405  (818)782.6600 x 2140 
> catherine.litten@valleypres.org
> ********************************
> The thoughts, comments, and opinions expressed herein are mine.  They do
> not reflect those of my employer, nor anyone else.
> ********************************
> This E-mail is covered by the Electronic Communications Privacy Act, 18
> U.S.C. §§ 2510-2521 and is legally privileged. This information is
> confidential information and is intended only for the use of the
> individual or entity named above. If the reader of this message is not the
> intended recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited.  If
> you have received this transmission in error, please notify the sender
> immediately by return electronic transmission and then immediately delete
> this transmission.
> 
> 
This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.