Promt Macro

[EArumugam]

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

[sivakumar.sm]

create a data item with the expression maximum([Year] for report).

I think you should use #promptmany to get multiple select prompt.

[EArumugam]

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.

[sivakumar.sm]

max will not work in Where clause, try writing a subquery for the prompt