Show results based on two related lists

[ErikJ1]

Hi all!

I need to create a report on sc_cat_item where both of the related lists "Available for" and "Not available for" are empty.

I can't do it with the reportdesigner since it only supports one related list.

What is the best practice for this?

Is it possible to combine all the data with a databaseview and report on that?

Is it possible to make a dynamic filter to show the results?

Are there other options to achieve the same goal?

//Erik

[Dr Atul G- LNG]

Hi @ErikJ1 

You can create DB view with sc_cat_item and available for and not available for table.