Hey everyone, excuse the noob question. Only been live on OVSD 1 day.
I'm trying to build a forward schedule of Changes report in Crystal. I'm using Change view (v_change) for the main report and I'm trying to use a work order view as a subreport. Unfortunately, there are no v_workorder views listed.
Best I can come up with is sd_workorder which is a table. I figured I'd link the value wor_cha_oid in the sd_workorders table to object_id field in v_change view but its not working. The report shows me all the changes in the system, but no workorders what-so-ever.
So a few questions... 1) Does ServiceDesk 5.1 have a workorder view? 2) If (1) = Yes then what would cause it to not show up when I run the create views command? 3) What field connects workorders to changes?
We've been on SP1 a couple weeks now. Will the "generate views" functionality now create an appropriate work order view? Or will I have to trick the tool into doing what I need (like every other "feature").