Working with ARS 6.3 patch 20 and HD 6 on Solaris with remote Oracle 10gr2
database.
I have run the following query on the Change Request Form:
('Category*' = "Testing Tools" OR 'Category*' =
"Remedy") AND 'ReleaseID' = $NULL$ AND 'Status*' <= "Pending"
and I get the expected results.
I now need to create a report with the same selection criteria. When I add
my report to the REPORT form and enter the above in the qualification it
doesn't work. The issue seems to be with the 'ReleaseID' = NULL check.
I tried using $\NULL$ and that just shows as "\NULL" and no records are
returned.
In the Report Form the Base Qualification shows as:
('200000003' = "Testing Tools" OR '200000003' = "Remedy") AND '800000000'
= $\NULL$ AND '7' <= "Pending"
When I pull up the report the qualification shows as:
('200000003' = "Testing Tools" OR '200000003' = "Remedy") AND '800000000'
= "\NULL" AND '7' <= "Pending"
If I manually select the qualification I need, it shows as:
('200000003' = "Testing Tools" OR '200000003' = "Remedy") AND '800000000'
= $\NULL$ AND '7' <= "Pending"
It appears that whenever I use a $ in the Report Forms Base Qualification
the $ is replace with a double quote(").
What am I doing wrong?
Thanks,
Greg
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
