A Crystal Report built on an IAL displays data correctly without a WHERE clause, but comes back completely blank as soon as a WHERE clause is added to the underlying Quick Report — even though the same WHERE clause works fine on an equivalent plain-SQL Quick Report.

Q: A Crystal Report built on an IAL displays data correctly without a WHERE clause, but comes back completely blank as soon as a WHERE clause is added to the underlying Quick Report — even though the same WHERE clause works fine on an equivalent plain-SQL Quick Report.

Check the direction of the link between CR_WEB_INIT and the IAL — it needs to be CR_WEB_INIT linked to the IAL, not the IAL linked to CR_WEB_INIT; having this backwards has caused exactly this symptom (blank output only once a WHERE clause is introduced), and correcting the link direction resolves it without needing to change the WHERE clause or the report layout itself.

Answer

Check the direction of the link between CR_WEB_INIT and the IAL — it needs to be CR_WEB_INIT linked to the IAL, not the IAL linked to CR_WEB_INIT; having this backwards has caused exactly this symptom (blank output only once a WHERE clause is introduced), and correcting the link direction resolves it without needing to change the WHERE clause or the report layout itself.

← Browse Reporting and analytics questions