calculating total

[pooja]

monthly entrance fee 45/50/85...varies

how to get total of montly fees according to month select by player......like
if player select 2month then 45*2=90.....and if 6month then 45*6=270...and so on....


pjsgfdsdfdgdfs

[robin2008]

you can do the total........go to funtions on report exprerssion..
that will work


thank

[DanSev]

if the report has a prompt that the user enters a number of month (or a predefined number) In your query create a data item called 'Total Fee', and place in it this expression:

#'[Monthly Entrance Fee] * ' + prompt('number_of_months','token','6')#

number_of_months -- the parameter name used in the prompt, and 6 is the default value.
Monthly Entrance Fee is a reference to the data item that stores the entrance fees.

[madhupujari]

you can do the total........go to funtions on report exprerssion..
that will work


thank