Hi, I have the below enclosed report in which I am using a calendar objects for start date and end dates for date range selection.
In the expression below,TRANS_ID_MAX is taken as max(GC_TRANS_ID) in the script but I want to restrict this max(GC_TRANS_ID) to be <=VENDDATE(the varaible used for calendar object basically the enddate which is the max of date range in the calendar object.).Is there a way to do this.How to use the varaible ports in script or pls suggest if theres any other way to do this.
sum({$<STORE_NUMBER={'SVS*'},GC_BUY_OR_REDEEM={B},
CALENDAR_DATE={'>=$(=Date(VSTARTDATE))<=$(=Date(VENDDATE))'}>}
if(GC_TRANS_ID=TRANS_ID_MAX,
GC_BALANCE))
Thanks,
Swetha
