i have 2 lists in an single page of single query..
my requirement is if i run the report in excel sheet then i have to display list1 in sheet1, list2 in sheet2 and both in sheet3..
need suggestions..
You're going to need 3 pages in your report with List 1 on page1, List2 on page2 and list1 and list2 on page3.