Please consider registering

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
BIRT - Passing null value
July 27, 2017
1:46 am
Forum Posts: 5
Member Since:
October 19, 2016
sp_UserOfflineSmall Offline


Maximo / BIRT newbie here.  I am trying to figure out how to pass null value in BIRT.  My stored proc/query works when passing null value, but I cannot figure out how to get it to work in BIRT!  

If I include DepartmentValue and AccountValue, it works a treat.  When I am trying to pass Department code, and would like to to return all for said department (with AccountValue = null), report is blank.

 Any ideas?

var DepartmentValue = params["DepartmentValue"].value;
var AccountValue = params["AccountValue"].value;

EXEC sp_ByDeptOrAcct '"+DepartmentValue+"','"+AccountValue+"','"+startdt+"','"+enddt+"'
September 6, 2017
1:26 pm
Stoneham, MA USA
Forum Posts: 1118
Member Since:
March 2, 2009
sp_UserOfflineSmall Offline

Hello, Please register to see the Admin’s answer!

Forum Timezone: America/New_York

Most Users Ever Online: 54

Currently Online:
1 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

sun kim: 60

madd0g17: 59

v.barsamov: 51

cgregory: 45

Maximofresher: 45

matta0990: 33

Member Stats:

Guest Posters: 0

Members: 14366

Moderators: 0

Admins: 4

Forum Stats:

Groups: 1

Forums: 8

Topics: 1580

Posts: 4295

Newest Members:

Megan Morgan, Devendra Verma, stephen stephens, maxexpertise Hilal, Jeroen van Proosdij, Neeraja N

Administrators: Chon: 1118, kristensibilia: 0, Joe Grassia: 0, bpaik: 0