preferences and report schema design