I have an existing report that I'm running for Date Range 7/27-7/31 and the problem I run into is that if a ticket was opened
AND closed during the same period,
only the "Closed" status of that ticket shows in the report. There is nothing in my Select Expert that filters only "Active" or "Inactive" tickets, so the results should be any value.
I thought maybe it was my Join in the Database Expert that links my two tables, but it's currently set to Left Outer Join, chg.status <-chgstat.code, so it should return all results.
I'm using a {?DateRange} Parameter field. I have a formula but it isn't returning accurate results:
if {chg.ACTIVE_FLAG} = 1
then "Open"
else "Closed"
This shows a ticket that was closed on 7/30 but it doesn't appear in the results as being opened on 7/28.
I tried the following formula, but it still doesn't pull Open AND Closed status on the same ticket, and returns a True/False statement:
if {?DateRange}=PDMTimeToDateTime ({chg.open_date})
then {chgstat.sym}="Open"
else if {?DateRange}=PDMTimeToDateTime ({chg.close_date})
then {chgstat.sym}="Closed"
I know I'm close to finding an answer but it just isn't coming to me. I know this can probably be done using a UNION, but how does that translate to an if/then statement?
I'm on a deadline and need to figure this out before Monday. I haven't found anything helpful in the forums and could really use some expert advice. Any assistance would be greatly appreciated.
Michael