Skip to main content
C
Cozmo2
Inspiring
April 27, 2015
Question

Print 0 when null value is returned

  • April 27, 2015
  • 1 reply
  • 858 views

When I run my query and the award is not found a null value is returned, I'd like to show that as a 0 value on my excel report.Is there a way to do this?

This topic has been closed for replies.

1 reply

EddieLotter
EddieLotter
Inspiring
April 27, 2015

You can do it in your SQL query, for example in MS SQL Server you can use the IsNull() function or you can use the expression builder in Report Builder to show a 0 when the field value is an empty string.

Cheers

Eddie

C
Cozmo2Author
Inspiring
April 28, 2015

​I don't think the query will work because a record is not returned. I

tried checking for a length of zero and still blanks are being returned.

I'm using a sub report and when it does not find the record it returns

blanks. Not sure what I'm doing wrong. Please help.

Bonni

---

Bonni Harris

Database Analyst

Eureka College

300 E. College Avenue

Eureka, IL 61530-1500

309-467-6467

On Mon, Apr 27, 2015 at 3:34 PM, EddieLotter <forums_noreply@adobe.com>

EddieLotter
EddieLotter
Inspiring
April 28, 2015

Please show your query.

Cheers

Eddie

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices