Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Query is returning rows but report is blank

Hi,

I have the following query in "Show SQL query"

SELECT "ITT1_1"."Code", "ITT1"."ChildNum", "ITT1"."Code", "OITW"."WhsCode", "OITW"."AvgPrice", "ITM1"."PriceList", "OITM"."ItemName"

FROM ((("SBK_IL_ACC"."dbo"."ITT1" "ITT1_1" INNER JOIN "SBK_IL_ACC"."dbo"."ITT1" "ITT1" ON "ITT1_1"."Father"="ITT1"."Father") INNER JOIN "SBK_IL_ACC"."dbo"."OITM" "OITM" ON "ITT1_1"."Father"="OITM"."ItemCode") INNER JOIN "SBK_IL_ACC"."dbo"."ITM1" "ITM1" ON "ITT1_1"."Father"="ITM1"."ItemCode") INNER JOIN "SBK_IL_ACC"."dbo"."OITW" "OITW" ON "ITT1"."Code"="OITW"."ItemCode"

WHERE "ITT1_1"."Code"=N'500005' AND "ITT1"."Code"<>N'500005' AND "OITW"."AvgPrice"<>0 AND "OITW"."WhsCode" LIKE N'HO%%%%' AND "ITM1"."PriceList"=1 AND "ITT1"."ChildNum"=1

The O/P is :

500005 1 9000073 HOMFG 966.01 ; 1 Synthetic 5LTR

500005 1 9000047 HOMFG 875.51 ; 1 Synthetic 4LTR

500005 1 9000021 HOMFG 361.68 ; 1 Synthetic 1LTR

500005 1 9000024 HOMFG 243.32 ; 1 Synthetic 0.5LTR

500005 1 9000048 HOMFG 158.25 ; 1 Synthetic 0.2LTR

But when I pull any data I am not able to see it, the report is showing blank. Any pointers would help me.

Former Member
Former Member replied

wild card in Crystal is * not %

Try

{ITT1_1.Code} = '500005'

AND {ITT1.Code} '500005'

AND {OITW.AvgPrice} &lt;&gt; 0

AND {OITW.WhsCode} LIKE 'HO*'

AND {ITM1.PriceList} = 1

AND {ITT1.ChildNum} = 1

Ian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question