Mind Twisting Questions for Report Studio: Try it

There is a prompt page having the options for ascending and descending, based on the prompt value selected , the report page generates the list column value sorted in either ascending or descending:

Questions by jjrkl_sandeep   answers by jjrkl_sandeep

Showing Answers 1 - 12 of 12 Answers

Ramu

  • Nov 25th, 2013
 

1. Select the List Report you want to display

2. Goto Query Explorer, Click on Query 1, drag Data item into the Query 1.

3. Drag & drop value promt. Add values (1,2,3)

3. Give expression case ?Parameter?

when C1 then 1

when C2 then 2 else 3

end

4.Select Data item, if you want rename & Sort to Ascending..

5. Now open page 1, Drag & drop Data item to your report.

6. Run the report....

  Was this answer useful?  Yes

Mayank Sanghvi

  • Aug 2nd, 2016
 

In addition to above answer you can use two separate list for ascending and descending order.

  Was this answer useful?  Yes

Martina Vaz

  • Jun 26th, 2017
 

Create 2 lists. one with ascending one descending. depending on the prompt selection display the list

  Was this answer useful?  Yes

Vishalakshi

  • Feb 12th, 2021
 

First step : Create a static prompts namely Ascending and Descending for asscociated with one paramater .
Second step : Create a macro with same parameter to which value in the list you wanted to create Asc and Desc. syntax: #macro(parametername, token)#

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions