If you are unable to create a new account, please email support@bspsoftware.com

 

urgent requirement how to view report ouput records based on prompt selection?

Started by bvk.cognoise, 21 Mar 2011 05:02:30 AM

Previous topic - Next topic

bvk.cognoise

hi i have requirement

i created a report with data items .eg: branch name,branch id,revenue.

in this report i want to find out the top 'x' records based on prompt selection.for example

i added static choice to my value prompt  like
top 10 revenue generated branches,
top 20 revenue generated branches,
top 30 revenue generated branches,
top 'x' revenue generated branches,

based on prompt selection i want report output.plz reply me ASAP.

thanks in advance for your reply

thanks
vamsi
Regards
BVK

bvk.cognoise

hi I'm sorry,
i got solution but still have some problem.
>i created report with that dataitems(branch id,branch name,revenue)
>i created a calculated column like' rank of revenue'
rank([revenue])
>i created a dynamic filter on ' rank of revenue'column
>i change aggregation function to After aggregation function
>im getting the text prompt

but here  i want value prompt drop down list insted of using textbox prompt.
how can i assign that calculated column to value prompt.i dont use static choices again.i want to show the values which is located in calculated column. we can use static choices but i have 2000 records.so its difficult to me add 2000 records.

how can we solve this.
plz reply me ASAP
Regards
BVK