I'm trying a to create a report and need some help because I'm having issues with my report. I have two tables - tblworkorder and tbltime (joined by idworkorder). I have 2 types of time - Direct Labor which has a Work Order related to the time charge and Indirect Labor which does not have a Work Order (ex. sick leave, or holidays). 95% of the time charges have a work order and 5% do not.
The problem I'm having is that once I cannot get the indirect labor records to show in my table box if I highlight/select any workorders from the list. Is there anyway I can still get it to show both the direct and indirect labor to show?
The solution given by the guys above will work for the example data that you have provided.
I am assuming that the data you have provided above is a data dump from the tables within your qvw file and the dash is in fact representative of a null value so in reality, you probably won't be able to make the manual change as described above in the actual report i.e. you will be pulling new data when this is reloaded...apologies if I am wrong in this assumption...
Going back to my earlier suggestion, what you could do as part of your script is use an if statement to replace null wo numbers with a value.
I suggested 999 but this could be anything...
I have attached a qvw file...I have tried to suggest a route and offer my apologies if |I am way off the mark - I am relatively new to QlikView....
