Hi There,
I have to create a report that includes Category and Related sub category on HR service. I was trying to do this with database view.
On my choice list table I have element Category and element Sub Category. For Element category dependent value is HR service sys id and for Element subcategory dependent value is category value.
I created the database view below.
When I create the report from this view it giving me HR service, Category and sub category labels. However, It is not giving me categories that do not have any sub category. For e.g. HR service General Inquiry has Category Workday task and sub category Name change and Address change. and another Category New Hire Inquiry and no sub category.
The report is not show the category that has no sub category. How do I populate all the category into the report. and if the sub category is not associated with it then sub category should be blank
You might want to try adding the 'Left Join' column to the list, then setting the value to 'true' for the subcategory:
You might want to try adding the 'Left Join' column to the list, then setting the value to 'true' for the subcategory:
