Good Day,

   I'm a beginner for crystal report version X, I have a column "Itemcode", most of my itemcode starts 20001 and up, but some are blank code, how can i show this blank code in my report? because i've notice everytime i generate report blank code didn't show..sample below:

     Itemcode       Item Description
     20001          Thread Pin
     ...            Fork Clutch

    The item code with sign period does not appear in my report, what formula will i do?

Thanks :)



Edited by jejo1102 - 12 Jan 2015 at 7:05pm

check whether your query is fetching data with blank records. If not then handle it at query to fetch these records also. Mostly it will be because Itemcode will be having a filter with parameter and if you don't give any parameter it doesn't pull the values with null values.

Handle it like this in your query

Select * from
YourTable
Where Nvl(Item_Code,-12345)=
Nvl(Nvl(Parameter,Item_Code),-12345)

This works where your itemcode is number. Incase is its char replace the -12345 with some dummy character which your column wont be having.

Hope this helps.