Cross tab report don't show all combinations, Member browsers shows all

Hi All,

We have a worksheet that runs longer about 20+ minutes. Issue we are facing is when we are running report with cross tab layout, it randomly shows one or only few combinations available where as when we run the worksheet with member browser layout, it show all members and displays required series upon selecting each member. As I mention this tables longer, even after select a memeber in the member browser, worksheet run the fetch and displays data. Now issue to solve is why doesn't cross tab display all combinations where are real data exists and it is shown in