CODEWITHSUNDEEP
sql-serverpostgresqlreporting-services
Terrible Coder
Terrible Coder

Reputation: 990

how to pass nullable value sql server report

Using Odbc connection am creating reports in sql server report for postgres database. I have issue in passing nullable value parameter although the query is working fine in query deginer but not working while running the server. my query

Select * 
from "FF"."Rpt_vEventReportpart1" a 
where a."CallType" is null or a."CallType"= (COALESCE(?,a."CallType"))

Upvotes: 0

Views: 32

Answers (1)

Clodoaldo Neto
Clodoaldo Neto

Reputation: 125464

Just a guess. Try it:

where 
    a."CallType" is null or 
    ? is null or
    a."CallType" = ?

Upvotes: 1

Related Questions