Matrix report not setting the pagewidth properly

Hi,
I have a matrix report that displays offices down the page and all the
days in a month across the page, with a subreport in each cell
displaying other data.
The problem i am having is when i load the page the first time it will
only display half the days, when i press refresh or change the zoom
level it correctly displays all the data.
I have tried setting the zoom level on the url and setting the actual
and interactive page size to A2 (594mm x 420mm) and it has made no
difference.
Any suggestions on how i can get this to display correctly?
Thanks
DarrynOn Mar 11, 9:49 pm, darryn.brya...@.gmail.com wrote:
> Hi,
> I have a matrix report that displays offices down the page and all the
> days in a month across the page, with a subreport in each cell
> displaying other data.
> The problem i am having is when i load the page the first time it will
> only display half the days, when i press refresh or change the zoom
> level it correctly displays all the data.
> I have tried setting the zoom level on the url and setting the actual
> and interactive page size to A2 (594mm x 420mm) and it has made no
> difference.
> Any suggestions on how i can get this to display correctly?
> Thanks
> Darryn
Usually, when including subreports in a table, etc of another report,
the format tends to be a little hard to control (at least, at the
granular level). If there is a way to avoid using the subreport(s) in
this way, I would suggest it. I would check the complexity of the
queries/stored procedures used for the subreports and maybe use the
Database Engine Tuning Advisor to improve the performance of the
queries/stored procedures. It seems like there might be a bottleneck
with the queries. Hope this helps.
Regards,
Enrique Martinez
Sr. SQL Server Developer