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
you can do the total........go to funtions on report exprerssion..
that will work
thank
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.
Quote from: robin2008 on 31 Oct 2008 09:38:35 AM
you can do the total........go to funtions on report exprerssion..
that will work
thank