FSG Report - Internal SQL generated by FSG Report

Hi,

I have an FSG report where the end of the FSG SQL query varies if I set the column Amount Type as PTD Actual and YTD Actual.

If I use only YTD ACTUAL in all the columns of the given column set, then query ends like

—————
AND ((nvl(bal.period_name,”)=’JAN10′
AND((bal.ACTUAL_FLAG = ‘A’)
OR
((bal.ACTUAL_FLAG = ‘A’
AND (nvl(bal.PERIOD_NET_DR,0) != 0) or (nvl(bal.PERIOD_NET_CR,0)!=0)))))))) )
—————–

If I use only PTD Acutal as amount type in all the columns

——————-
AND ((nvl(bal.period_name,”)=’JAN10′
AND((bal.ACTUAL_FLAG = ‘A’