Report making

[Priyadarshini2]

i have a filed called business unit, which have options in a hirarchial manner. example, under Enrollment there are a b and c child options are there. I want to make a report where if the condition given as 'Business unit is Enrollment' then all the tasks with enrollment and as business unit as A B C as well should come

[Dr Atul G- LNG]

Hi @Priyadarshini2 

How the options A/B/C are stored in SN? are you storing these in separate fields?  Like we have category and sub category.

Like this

[Priyadarshini2]

yes as sub category, under one sub category there are again some child category also present. My requirement is, if the condition given as Business unit is Enrollment then if the business unit chosen as enrollment will come, if the business unit chosen as A or B or C that should also come or else if the business unit chosen as any child category that record should also come.

[Dr Atul G- LNG]

So you mean the format is like

BU  -- Enrollment

Sub BU - A

sub to Sub BU - D

Then if you select BU = Enrolment then all records come? 

[Priyadarshini2]

yes exactly