Best way to create reports with related data (eg user criteria)

[KB15]

I'm trying to figure out a way to display catalog items with their user criteria like the below. Is this something that can be done with a standard report?

Item	Available For	Not available for
New Computer	New York, California, Washington
New Phone		Florida, Arizona

[sachin_namjoshi]

Available for and not available for related lists points to sc_cat_item_user_criteria_mtom and sc_cat_item_user_criteria_no_mtom tables respectively.

You will have to create a database view between sc_cat_item, sc_cat_item_user_criteria_no_mtom and sc_cat_item_user_criteria_no_mtom tables with required join conditions.

you can then report on database view.

Regards,

Sachin