parametric sort

[system]

I want to create a report by parametric sort.

FOr ex When i run the report the report should prompt me something like this
sort by:- and i should be able to select one of the below
store,manager,customer,cashier and accordingly the report should display the data sorted by selected value.

Is there a way we cna do this in BO XI r3.

Thanks,
–h

---

hourigan (BOB member since 2007-04-06)

[system]

Potentially through a VBA script in Desktop Intelligence… since there’s not a way to know what the end user will select at the Universe level.

---

digpen (BOB member since 2002-08-15)

[system]

FOr ex When i run the report the report should prompt me something like this
sort by:- and i should be able to select one of the below
store,manager,customer,cashier and accordingly the report should display the data sorted by selected value.

You can do it using DeskI. You have to create different tables (data blocks) one for each of your options. In the first block apply sort on store column, in the second apply the sort on manager column and …

Hide these blocks based on the UserResponse(). Check the following link:
How to show and hide reports based on user selection.

---

BO_Chief (BOB member since 2004-06-06)