Let me explain my problem. I have 2 data providers which bring information about the last month and 13 rolling months. The report contains a table based on the last month data provider and 2 crosstabs and 1 graph based on the 13 rolling months data provider.
The problem is that I have the Product Group dimension as section from the last month data provider and this is causing some blank lines to appear in my crosstabs.
I did a test. When i put the Product Group dimension as section from the the last 13 rolling months data provider, it simply causes chaos in my first table.
So it looks like there some Product Group which are present in DP1 and not in DP2 and vice versa and BO does Outer Join when it links DP… Search here for Data Provider Synchronization…
It has been my experience that linked data providers, crosstabs, and sections are a pain, and just don’t work the way you want. If you eliminate one of the three, you’d be ok.