Skip to Content
0
Former Member
Jun 01, 2010 at 10:54 PM

Query doesn't pull data within Report

13 Views

Hi All,

For some odd reason, I can run the following query against my informix database using DbVisualizer or Sql Editor just fine. But when I press F5 in Crystal report, I get nothing back. Any suggestions?

SELECT

screenlog.user_id, screenlog.session_id, screenlog.full_query

FROM

screenlogdb@ol_xxxpdb99991:informix.screenlog screenlog

WHERE

(screenlog.full_query LIKE '%201111%' OR

screenlog.full_query LIKE '%511111%' OR

screenlog.full_query LIKE '%601111%' OR

screenlog.full_query LIKE '%9549658111%' OR

screenlog.full_query LIKE '%9549658111%' OR

screenlog.full_query LIKE '%9549658111%' OR

screenlog.full_query LIKE '%9549658111%' OR

screenlog.full_query LIKE '%TAA-9403-234%') AND

screenlog.user_id NOT LIKE '%pthn.com'

ORDER BY

screenlog.user_id ASC,

screenlog.session_id ASC

Thanks.

Matt