Sorting from Prompt

[robin2008]

I have a report monthly statement where LOAN, ZIP, NAME and lots of other things

I already have a date  and loantype prompt from begining
Now they asked me to add one more prompt which must contain LOAN, ZIP and NAME to sort(accending order).and prompt should be multi function so that user can chose one or more than one value.

anybody plz help me out
thank yu

[Suraj]

Just add a new data item in front of your list.
case
when ?Sort Prompt? = 'Loan' then [LOAN_ID]
when ?Sort Prompt? = 'Zip' then [Zip]
when ?Sort Prompt? =  'Name' then [Name]
end

Then sort this ascendingly.
Then hide the column and heading by going to properties and setting box type = none

If you have searched it here or ittoolbox, the answer is already there.

[robin2008]

Thank  You Suraj

But I dont have List only...I have two tales right and left side.....so where  should I drag this data item.......actually this a statement report like invoice like U have logo, copanu name, peron address...n so  on...
could you plase give me a little more help hints , please

I thank you

robin

[Suraj]

then just create the data item with logic above.
click anywhere in the list one at a time
go to advanced sorting, and apply sorting for the new data item.
remove any other sorting.
repeat for all the lists.

[robin2008]

hello suraj...plz help.....this is the way I did.........but not working....

I create data item with logic you gave(only for one to try)

case
when ?sort prompt? = 'zipcode' the [CHRMAILZIPCODE]
end

then I took this data item to the report page and place side by side with zipcode. and this is table not the list .
then --advanced soeting and drag the new sorting data item to group sorting.

but the result is different
1- result coming with two propmt pages where I need this zipcode sortig prompt on the same page where other propmt are
2- result coming out with the value prompt...but I need drop down prompt

plz help

robin