Sorry for not providing the details.... My database looks like this. SNo Restaurent Items 1 Rest1 Item1 2 Rest1 Item2 3 Rest2 Item1 4 Rest2 Item3 5 Rest2 Item4 6 Rest3 Item2 7 Rest3 Item4 Which means that, Rest1 contains only Item1, Item2 Rest2 contains only Item1, Item3, Item4 Rest3 contains only Item2, Item4 And my report should be like a comparison chart. Restaurent values on Y-axis and Item values on X-axis and inside the report,if Rest1 is having Item1, then a tick mark should be placed in that particular column .Similarly a tick mark under Item2 but null values for item3 and item4
modified on Saturday, December 15, 2007 4:38:38 AM