Report

[yoli1]

Hello everyone What would be the best solution to implement this : 

1 - Create a simple report for open HR Cases

2 -  Filter all HR Cases where the title of the opened for is IT Technician

[AndersBGS]

Hi @yoli1 ,

for the first report, utilize the table hr_core in the report designer, and create a condition that state is open.

for the second report, again through report designer, again the same table, but the create the condition open for is IT technician.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[yoli1]

Hello @AndersBGS  is it necessary to create two reports? is there a possible solution to create one for the two questions ?

[AndersBGS]

Hi @yoli1 ,

as the title is a string field and not a reference field, I would recommend you to create two reports. If the it technician had been a reference field, you could have created an interactive filter.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[yoli1]

hello @AndersBGS  for question 2 it's the opened for title and the opened for is a reference field (2 -  Filter all HR Cases where the title of the opened for is IT Technician)  I was thinking about using interactive filter but for the question 1 report will show Open HR Cases if i created an Interactive Filter for question 2 it will show Open HR Cases where the title of the opened for is IT Technician as the report in question 1 show Open HR Cases  but in question 2 it says All HR Cases what do you think ?  (1- Open / 2- All )