PM80296: isNull CrystalReports function is returning incorrect False as result on CQWeb client

Rational ClearQuest Fix Pack 8 (8.0.0.8) for 8.0
Rational ClearQuest Fix Pack 1 (8.0.1.1) for 8.0.1
Rational ClearQuest Fix Pack 11 (8.0.0.11) for 8.0
Rational ClearQuest Fix Pack 4 (8.0.1.4) for 8.0.1
Rational ClearQuest Fix Pack 5 (8.0.1.5) for 8.0.1
Rational ClearQuest Fix Pack 12 (8.0.0.12) for 8.0
Rational ClearQuest Fix Pack 6 (8.0.1.6) for 8.0.1
Rational ClearQuest Fix Pack 13 (8.0.0.13) for 8.0
Rational ClearQuest Fix Pack 14 (8.0.0.14) for 8.0
Rational ClearQuest Fix Pack 7 (8.0.1.7) for 8.0.1
Rational ClearQuest Fix Pack 15 (8.0.0.15) for 8.0
Rational ClearQuest Fix Pack 8 (8.0.1.8) for 8.0.1
Rational ClearQuest Fix Pack 16 (8.0.0.16) for 8.0
Rational ClearQuest Fix Pack 9 (8.0.1.9) for 8.0.1
Rational ClearQuest Fix Pack 17 (8.0.0.17) for 8.0
Rational ClearQuest Fix Pack 10 (8.0.1.10) for 8.0.1
Rational ClearQuest Fix Pack 18 (8.0.0.18) for 8.0
Rational ClearQuest Fix Pack 11 (8.0.1.11) for 8.0.1
Rational ClearQuest Fix Pack 19 (8.0.0.19) for 8.0
Rational ClearQuest Fix Pack 12 (8.0.1.12) for 8.0.1
Rational ClearQuest Fix Pack 20 (8.0.0.20) for 8.0
Rational ClearQuest Fix Pack 13 (8.0.1.13) for 8.0.1
Rational ClearQuest Fix Pack 21 (8.0.0.21) for 8.0
Rational ClearQuest Fix Pack 14 (8.0.1.14) for 8.0.1
Rational ClearQuest Fix Pack 15 (8.0.1.15) for 8.0.1
Rational ClearQuest Fix Pack 16 (8.0.1.16) for 8.0.1
Rational ClearQuest Fix Pack 17 (8.0.1.17) for 8.0.1
Rational ClearQuest Fix Pack 18 (8.0.1.18) for 8.0.1
Rational ClearQuest Fix Pack 19 (8.0.1.19) for 8.0.1

APAR status

• Closed as program error.

Error description

• When a formula is build with the isNull function, then running
  the report on CQWeb client returns False where it should be True
  on records with data. On CQ Windows client the report works as
  expected.
  
  Steps to reproduce:
  1- On default DefectTracking SAMPL schema/database, create a
  report based on query/report format for record: Defect.
  2- Add the fields: id, Headline and Description to define the
  report.
  3- Modify some records adding text in the 'Description' field.
  4- Author the report with supported CR version and add the 3
  fields to display on it.
  5- Create a formula field; eg. Null and define it in the formula
  editor as:
  isNull ({ClearQuest.description}) , add it to the report and
  save the report.
  6- Run the report on CQWindows client. The report will display:
  'False' on records with text in the description field and 'True'
  on records containing no text in the description field, as
  expected.
  7- Run same report on CQWeb client, report is displaying 'False'
  on all records!
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When using the Crystal Reports isNull function to test for
  an empty ClearQuest string field, the result is inconsistent
  between the desktop clients and the Report Server for
  Crystal Reports.  When running a report using the Report
  Server for Crystal Reports, the isNull function returns
  false for cases where a value of true is expected.
  

Problem conclusion

• A fix is available in ClearQuest 8.0.0.8 and 8.0.1.1.
  
  The ClearQuest Reporting Driver was updated to treat empty
  string values as nulls.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  CLEARQUEST WIN

• Fixed component ID

  5724G3600

Applicable component levels

• R712 PSN

     UP