How can I get a user prompted parameter into the report to only use at run time.
ie a table column holds scores for different questions, based on the sum of these scores a “star” rating of 1 to 5 can be given. This star rating does not exist in the database and is based on the sum of the scores. I would like the user to be able to select a star rating to act as a filter for the report … but how do I get a report level parameter into the query ??
salty_pete 
(BOB member since 2010-03-10)
Salty,
In Universe:-
Create “Star” Object - Case construct with the calculation
Ex:-
CASE Scores
WHEN 80 THEN 1
WHEN 70 THEN 2
ELSE 3
END
“STAR”
Does this works for you?
BO_Stuffed (BOB member since 2008-03-29)
I now have a “Star Scores” measure object defined as :
sum(@Select(Cp Xrscores\Question Score)) where CP_XRSCORES.QUESTION_LABEL BETWEEN ‘5’ AND ‘7’
Which does give me the scores. I can see how the Case construct will work in determining the rating to apply to each scor. However referring back to your answer above how do I get the user to input their choice of 1, 2, … etc. 
[/img]
salty_pete 
(BOB member since 2010-03-10)
In the end I gave up on trying to find a way of the user inputting a Star rating … I’ve used multiple tabs/reports with each tab using a filter for the respective star rating. Which I shall promote as an “improvement” over their old system. 
salty_pete (BOB member since 2010-03-10)