Select fields in DB2 query without having them appear in ‘sort by’ window pane

520 pts.
Tags:
DB2 Web Query
IBM DB2
Hello Does anyone know how to select fields in the DB2 Query for report purposes, and yet not have them appear in the sort by window pane. Seem simple enough, but, when I have the field select tab highlighted, and double click on any field, the field automatically appears in the sort by window pane. 

So, if I want to sort by member no, and, I have member no, member address in fields, both fields appear in the sort by window pane, when in essence, I want both fields to be on my report, but only need to sort by the member no field. Can anyone help me out ?

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can drag and drop fields from the list on the left into the Sum/Print box on the far right. This adds that column to the report, but not as part of the sort sequence. By default, the “Sum” tab at the top of the Sum/Print box is selected, meaning that the value of the columns in that window will be summarized on the report. If you want to see the details, click the “Print” tab.

NOTE: if you are using Firefox, drag and drop won’t work. You can still use Firefox, but to get columns into the Sum/Print box, select the field in the list at left, then click the “Add” button above the Sum/Print window. (it has a little plus sign.)

HTH,
Michael

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following