October 19, 2016
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.
var DepartmentValue = params["DepartmentValue"].value; var AccountValue = params["AccountValue"].value; EXEC sp_ByDeptOrAcct '"+DepartmentValue+"','"+AccountValue+"','"+startdt+"','"+enddt+"'
Most Users Ever Online: 54
Currently Browsing this Page:
sun kim: 60
Guest Posters: 0
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