Skip to Content
0
Apr 27, 2022 at 06:52 AM

Crystal Reports return empty data

252 Views Last edit Apr 27, 2022 at 03:39 AM 3 rev

Hello, I'm new to using Crystal Reports. I created a custom report to display data from views and tables. when using a formula or field to display data, no data is displayed even though the data is in the database. Is any suggestions to fix this? I had try with condition from another fields:

<code>IF NOT ISNULL({@batch_number}) AND NOT ISNULL ({@batch_name}) THEN 
    {AR_GLPOST_3.NAMECUST}
ELSE
    "EMPTY"

or

if isNUll({AR_GLPOST_3.NAMECUST}) THEN "why is it empty?" ELSE {AR_GLPOST_3.NAMECUST}