Hi,
I am using prompt macro function in my report.
i am taking multiple year values in the prompt macro function
Year in #prompt ('year').
from that i need to take the maximum value.
i tried with max function. but not sucessful.
is anyother way to get the maximum value
create a data item with the expression maximum([Year] for report).
I think you should use #promptmany to get multiple select prompt.
thanks for you reply siva.
I used this prompt macro function in native sql for calculation.
from that i need to take maximum value.
for ex.
select * from table where year = (max#prompt('year')#)
from the above query i need to take the all the values from the table where year max year.
max will not work in Where clause, try writing a subquery for the prompt