Stella1209
Programmer
I am using CR 8.5. My report connected to Oracle database using ODBC.
My problem is that when I refresh report with new paramaters(I have 5 parameters) it's show me the same data, it looks like the SQl Query is not updating.
The "Save Data with report" option is unchecked.
This is a selection formula that I have:
if {?CCN}="" then true
else
{C_ILSOBG.CCN}={?CCN} and
if {?Year}="" then true
else
{C_ILSOBG.CAL_YEAR}={?Year} and
if {?Period}="" then true
else
{C_ILSOBG.BOOKING_MONTH}={?Period} and
if {?Planer}="" then true
else
{C_ILSO.PLANNER}={?Planer} and
if {?HLP}="" then true
else
{C_ILSO.HPL}={?HLP}
If you have any idea how I can fix that problem please let me know.
Thanks.
My problem is that when I refresh report with new paramaters(I have 5 parameters) it's show me the same data, it looks like the SQl Query is not updating.
The "Save Data with report" option is unchecked.
This is a selection formula that I have:
if {?CCN}="" then true
else
{C_ILSOBG.CCN}={?CCN} and
if {?Year}="" then true
else
{C_ILSOBG.CAL_YEAR}={?Year} and
if {?Period}="" then true
else
{C_ILSOBG.BOOKING_MONTH}={?Period} and
if {?Planer}="" then true
else
{C_ILSO.PLANNER}={?Planer} and
if {?HLP}="" then true
else
{C_ILSO.HPL}={?HLP}
If you have any idea how I can fix that problem please let me know.
Thanks.