I have a report that is made up of several smaller reports. My main report
has a main list and then an inner list. I have this set up so that the entire
report is repeated for each individual product campaign, one per page (in
other words, I have 20 or so pages of the same report, populated with
different data on each page). This works fine when it is published and viewed
through the report manager, but when I go to export it, the first page is
sometimes, but not always blank (except for the header and footer which
contains the correct data for that campaign). Yet if I reorder the campaigns
and make the page that was showing up blank not be the first page anymore, it
displays fine when exported. I did some research on this issue and the
closest thing that I found was someone else posing a similar question on an
MSDN "Chat"
(http://www.microsoft.com/technet/community/chats/trans/sql/sql060704.mspx).
Unfortunately they did not have a solution at that time. If anyone has a
solution to this please let me know. Thanks,
DavidDo you have the "Page Break at Start" option enabled on anything?
"David" wrote:
> I have a report that is made up of several smaller reports. My main report
> has a main list and then an inner list. I have this set up so that the entire
> report is repeated for each individual product campaign, one per page (in
> other words, I have 20 or so pages of the same report, populated with
> different data on each page). This works fine when it is published and viewed
> through the report manager, but when I go to export it, the first page is
> sometimes, but not always blank (except for the header and footer which
> contains the correct data for that campaign). Yet if I reorder the campaigns
> and make the page that was showing up blank not be the first page anymore, it
> displays fine when exported. I did some research on this issue and the
> closest thing that I found was someone else posing a similar question on an
> MSDN "Chat"
> (http://www.microsoft.com/technet/community/chats/trans/sql/sql060704.mspx).
> Unfortunately they did not have a solution at that time. If anyone has a
> solution to this please let me know. Thanks,
> David|||I have "Page Break at END" enabled on my most inner list.
"Mark Parter" wrote:
> Do you have the "Page Break at Start" option enabled on anything?
> "David" wrote:
> > I have a report that is made up of several smaller reports. My main report
> > has a main list and then an inner list. I have this set up so that the entire
> > report is repeated for each individual product campaign, one per page (in
> > other words, I have 20 or so pages of the same report, populated with
> > different data on each page). This works fine when it is published and viewed
> > through the report manager, but when I go to export it, the first page is
> > sometimes, but not always blank (except for the header and footer which
> > contains the correct data for that campaign). Yet if I reorder the campaigns
> > and make the page that was showing up blank not be the first page anymore, it
> > displays fine when exported. I did some research on this issue and the
> > closest thing that I found was someone else posing a similar question on an
> > MSDN "Chat"
> > (http://www.microsoft.com/technet/community/chats/trans/sql/sql060704.mspx).
> > Unfortunately they did not have a solution at that time. If anyone has a
> > solution to this please let me know. Thanks,
> > David
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment