Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parameters Problem/SQL Query

Status
Not open for further replies.

Stella1209

Programmer
Feb 9, 2001
32
US
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top