Report Sort Order chosen by the user

Document ID : KB000055764
Last Modified Date : 14/02/2018
Show Technical Document Details

In building reports, there can be a need to allow more than one way to sort a report. You may want to allow the end user to choose the column by which they want the report sorted. The steps below will walk you through building a report using the sample Global_Sports database. This report will prompt the user with a choice of "City" or "Company" and it will sort by whichever field is chosen.

Operating Systems:

CleverPath Eureka Reporter version 7.0 is supported on Windows 98, Windows NT and Windows 2000. Version 7.1 is supported on Windows XP, Windows 2000 and Windows 2003. Version 7.2 is supported on Windows XP and Windows 2003

Start by getting into Report Designer and opening a blank Free Form Report. Make sure you are pointing to the Global_Sports data source as well at the iqsports.iqk under Query >Database Connnection Override or Tools >Database Connection Defaults.

Place the City and Company fields from the Customers folder on the detail line of the report.

imga

Create a prompt on the page header area. Double click on the prompt and under Choice Value to Add, type City and click Add. Do the same for Company. Click Ok.

imgb

Create a custom on the detail line with the PROMPT column as the value.

imgc

Go to the translate tab of that custom and translate the custom to be the field "City" when the prompt = City.Also, translate the prompt to be the field "Company" when the prompt = Company. Click Ok.

imgd

Right click on the custom and choose Hide Toggle to hide the custom from being output.

Now go to Query/Sort Order and choose to sort on the Custom field.

imge

So the report will look like this:

imgf

When you run the report you will see the prompt:

imgg

Choosing City will give the following output:

imgh

Choosing Company will give the following output:

imgi

We take pride in our technical documents and are interested in your feedback. Please email your comments to us directly at: portalsdksupport@ca.com

Be sure to include the document id in the message.