Easiest thing would be to create a dummy object in Designer with the
following SELECT clause and no Tables associated with it: @Prompt(‘Enter rate’,‘n’,)
In effect, this would bring back a constant from the database, which is no
big deal, but the users would need to include it in the query panel. It
doesn’t have to be visible in the report.
To be able to multiply this object with another, be sure to make it a Number
type and a Measure.
I have created a report which sums total number of hours per section in a
master detail report.
I now need to calculate total cost per section (= total hrs * rate).
I need to get the user to input this rate each time they run the report
as
it is likely to vary.
This rate is not an object in the universe and will not be used in the
where
condition.
Is there a way that I can capture what the user enters and use this in
formulae within my report?
[Clayton, Cindy, HRBUS] Could you create a user defined object for
‘Rate’? Choose Tools/Universes.
Select the appropriate universe. Select ‘User Objects’. Choose
‘Add’. Type a name for your object and
make it’s type numeric. On the formula tab, choose numeric
functions/numeric prompt. In the question
box, enter whatever you want to prompt with enclosed by “”. Add
this object to your result objects.
It’s located in the user objects folder at/near the bottom of your
folder list. When you run the report,
you’ll be prompted for a value for your user object. I think you
can’t submit this to the document agent
and possibly someone will post other issues with this solution.
Cindy
Alternatively, a generic solution would be to create a blank object with a
prompt in Designer of type “number”. This can be used by anybody and in
any situation where a user is requied to enter a value. The example below
may be appropriate.
If I understand it correctly, it is very simple in Business Objects. You
can use the UserResponse function to get the value that the user entered
and multiply that by the number of hours.
Good Luck