I have a report that consists of a number of subreports. When I export to
PDF I get blank pages on every second page. No data is missing, it looks
like an incorrect margin setting or additional page break. If I export the
original "Sub"reports to PDF, then the problem does not occur.
I have checked the margins in the report and the subreports, and they are
all identical. Does anyone have any ideas I can try?
AndreCheck your master report.
Look at your report width as well as your left and right margins.
"Andre" <Andre@.discussions.microsoft.com> wrote in message
news:05B0EB7A-8DE7-4323-A4AF-383F4E4D8543@.microsoft.com...
>I have a report that consists of a number of subreports. When I export to
> PDF I get blank pages on every second page. No data is missing, it looks
> like an incorrect margin setting or additional page break. If I export
> the
> original "Sub"reports to PDF, then the problem does not occur.
> I have checked the margins in the report and the subreports, and they are
> all identical. Does anyone have any ideas I can try?
> Andresql
Showing posts with label subreports. Show all posts
Showing posts with label subreports. Show all posts
Wednesday, March 28, 2012
PDF Rendering - Page break with images
Hi,
I have a main page which has subreports, images and tables. in Preview i can
see the reports with proper page breaks, but when i render it to pdf, the
image and table in the main page is moving to another page, actually only 3
pages has to be printed in pdf but it is printing to 10 pages.
any suggestions please.
Thanks and regards,
AnithaI got the solution, i need to put all the lables and data in a Table to
display it in one page.
"Anitha Naidu" wrote:
> Hi,
> I have a main page which has subreports, images and tables. in Preview i can
> see the reports with proper page breaks, but when i render it to pdf, the
> image and table in the main page is moving to another page, actually only 3
> pages has to be printed in pdf but it is printing to 10 pages.
> any suggestions please.
> Thanks and regards,
> Anitha
>|||Try placing everything inside a rectangle control.
Place a rectangle in a blank area of the body.
Cut the controls including tables you want to contain, select the
rectangle, then paste the controls back in. Align things the way you
want inside the rectangle. This is the best way to restrict things in
RS. It may not work, but it's worth a try.
Cheers
Chris
Anitha Naidu wrote:
> I got the solution, i need to put all the lables and data in a Table
> to display it in one page.
>
> "Anitha Naidu" wrote:
> > Hi,
> >
> > I have a main page which has subreports, images and tables. in
> > Preview i can see the reports with proper page breaks, but when i
> > render it to pdf, the image and table in the main page is moving to
> > another page, actually only 3 pages has to be printed in pdf but it
> > is printing to 10 pages.
> >
> > any suggestions please.
> >
> > Thanks and regards,
> > Anitha
> >
I have a main page which has subreports, images and tables. in Preview i can
see the reports with proper page breaks, but when i render it to pdf, the
image and table in the main page is moving to another page, actually only 3
pages has to be printed in pdf but it is printing to 10 pages.
any suggestions please.
Thanks and regards,
AnithaI got the solution, i need to put all the lables and data in a Table to
display it in one page.
"Anitha Naidu" wrote:
> Hi,
> I have a main page which has subreports, images and tables. in Preview i can
> see the reports with proper page breaks, but when i render it to pdf, the
> image and table in the main page is moving to another page, actually only 3
> pages has to be printed in pdf but it is printing to 10 pages.
> any suggestions please.
> Thanks and regards,
> Anitha
>|||Try placing everything inside a rectangle control.
Place a rectangle in a blank area of the body.
Cut the controls including tables you want to contain, select the
rectangle, then paste the controls back in. Align things the way you
want inside the rectangle. This is the best way to restrict things in
RS. It may not work, but it's worth a try.
Cheers
Chris
Anitha Naidu wrote:
> I got the solution, i need to put all the lables and data in a Table
> to display it in one page.
>
> "Anitha Naidu" wrote:
> > Hi,
> >
> > I have a main page which has subreports, images and tables. in
> > Preview i can see the reports with proper page breaks, but when i
> > render it to pdf, the image and table in the main page is moving to
> > another page, actually only 3 pages has to be printed in pdf but it
> > is printing to 10 pages.
> >
> > any suggestions please.
> >
> > Thanks and regards,
> > Anitha
> >
Monday, March 26, 2012
PDF export
I have a main report with 2 subreports as the only items
in a list control. I am linking the 2 reports to a field
in the dataset of the main report. When I view the
report from the report manager or just from the report
URL it looks fine. When I export to PDF the first page
is blank. The 2nd page and all other pages are fine, but
the data from the first page just isn't there. The data
on the 2nd page is supposed to be the 2nd page so it's
just the first page that is not showing up. Has anyone
else seen this and have an idea of how to correct it?Rick,
I see this same problem with my report. Although with mine I have about 20
pages, but if I re-order those pages moving any other page to the first page
position, that page becomes blank, and the old first page is fine, so no
matter what is on the page, it is always the first one that is blank. I have
posted around on this and have not gotten a working response, I did however
find a MSDN "chat" where microsoft briefly mentioned this and said they knew
about it but did not know how to fix it
(http://www.microsoft.com/technet/community/chats/trans/sql/sql060704.mspx)
well post here if you ever get a solution. Thanks and sorry I couldnt be more
helpful.
David
"Rick" wrote:
> I have a main report with 2 subreports as the only items
> in a list control. I am linking the 2 reports to a field
> in the dataset of the main report. When I view the
> report from the report manager or just from the report
> URL it looks fine. When I export to PDF the first page
> is blank. The 2nd page and all other pages are fine, but
> the data from the first page just isn't there. The data
> on the 2nd page is supposed to be the 2nd page so it's
> just the first page that is not showing up. Has anyone
> else seen this and have an idea of how to correct it?
>
in a list control. I am linking the 2 reports to a field
in the dataset of the main report. When I view the
report from the report manager or just from the report
URL it looks fine. When I export to PDF the first page
is blank. The 2nd page and all other pages are fine, but
the data from the first page just isn't there. The data
on the 2nd page is supposed to be the 2nd page so it's
just the first page that is not showing up. Has anyone
else seen this and have an idea of how to correct it?Rick,
I see this same problem with my report. Although with mine I have about 20
pages, but if I re-order those pages moving any other page to the first page
position, that page becomes blank, and the old first page is fine, so no
matter what is on the page, it is always the first one that is blank. I have
posted around on this and have not gotten a working response, I did however
find a MSDN "chat" where microsoft briefly mentioned this and said they knew
about it but did not know how to fix it
(http://www.microsoft.com/technet/community/chats/trans/sql/sql060704.mspx)
well post here if you ever get a solution. Thanks and sorry I couldnt be more
helpful.
David
"Rick" wrote:
> I have a main report with 2 subreports as the only items
> in a list control. I am linking the 2 reports to a field
> in the dataset of the main report. When I view the
> report from the report manager or just from the report
> URL it looks fine. When I export to PDF the first page
> is blank. The 2nd page and all other pages are fine, but
> the data from the first page just isn't there. The data
> on the 2nd page is supposed to be the 2nd page so it's
> just the first page that is not showing up. Has anyone
> else seen this and have an idea of how to correct it?
>
Tuesday, March 20, 2012
Pathing Error: Subreport(s) could not be shown
Hi Folks
I have a working report with 5 additional subreports on my PC. Also, works
fine on the development server.
The issue is with PRODUCTION.
Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
Can anyone tell me if suppling the 'path' in the main report .rdl for all of
the subreports will fix the issue. Tried several permuations and have not
been able to have a subreport shown.
robjust doublechecked:
1. CAN deploy from VB.NET into the 'Home' directory in PRODUCTION and the
report/subreports work just fine :)
2. However, our 'normal' mode of operations is to copy the .RDLs from
DEVELOPMENT and upload them.
3. Attempting to deploy to any of the subdirectories/folders throws up an
authentication dialog.
4. My TargetServerURL: http://myproductionserver.here.mycompany.com/Reports
This needs to be something like:
http://myproductionserver.here.mycompany.com/Reports/thisapplicationreportsdir/reportnumber123
thanks
rob
"RobKaratzas" wrote:
> Hi Folks
> I have a working report with 5 additional subreports on my PC. Also, works
> fine on the development server.
> The issue is with PRODUCTION.
> Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
> Can anyone tell me if suppling the 'path' in the main report .rdl for all of
> the subreports will fix the issue. Tried several permuations and have not
> been able to have a subreport shown.
> rob|||sorry...
Finally, when deployed by hand (uploaded from .RDLs into where the reports
need to be) the subreports INDIVIDUALLY work just fine (so I'm pretty sure
it's a simply pathing related issue in the MAIN report).
Now, just how to modify the main report with the specific paths needed for
each subreport.
rob
"RobKaratzas" wrote:
> just doublechecked:
> 1. CAN deploy from VB.NET into the 'Home' directory in PRODUCTION and the
> report/subreports work just fine :)
> 2. However, our 'normal' mode of operations is to copy the .RDLs from
> DEVELOPMENT and upload them.
> 3. Attempting to deploy to any of the subdirectories/folders throws up an
> authentication dialog.
> 4. My TargetServerURL: http://myproductionserver.here.mycompany.com/Reports
> This needs to be something like:
> http://myproductionserver.here.mycompany.com/Reports/thisapplicationreportsdir/reportnumber123
> thanks
> rob
> "RobKaratzas" wrote:
> > Hi Folks
> >
> > I have a working report with 5 additional subreports on my PC. Also, works
> > fine on the development server.
> >
> > The issue is with PRODUCTION.
> >
> > Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
> >
> > Can anyone tell me if suppling the 'path' in the main report .rdl for all of
> > the subreports will fix the issue. Tried several permuations and have not
> > been able to have a subreport shown.
> >
> > rob|||Used the 'move' option to move all the reports to the proper location in the
SSRS tree.
The reports run just fine, however, this isn't the optimal way we want to
have to deploy our reports (preference is to upload the .rdls by hand).
rob
"RobKaratzas" wrote:
> sorry...
> Finally, when deployed by hand (uploaded from .RDLs into where the reports
> need to be) the subreports INDIVIDUALLY work just fine (so I'm pretty sure
> it's a simply pathing related issue in the MAIN report).
> Now, just how to modify the main report with the specific paths needed for
> each subreport.
> rob
> "RobKaratzas" wrote:
> > just doublechecked:
> >
> > 1. CAN deploy from VB.NET into the 'Home' directory in PRODUCTION and the
> > report/subreports work just fine :)
> >
> > 2. However, our 'normal' mode of operations is to copy the .RDLs from
> > DEVELOPMENT and upload them.
> >
> > 3. Attempting to deploy to any of the subdirectories/folders throws up an
> > authentication dialog.
> >
> > 4. My TargetServerURL: http://myproductionserver.here.mycompany.com/Reports
> > This needs to be something like:
> > http://myproductionserver.here.mycompany.com/Reports/thisapplicationreportsdir/reportnumber123
> >
> > thanks
> > rob
> >
> > "RobKaratzas" wrote:
> >
> > > Hi Folks
> > >
> > > I have a working report with 5 additional subreports on my PC. Also, works
> > > fine on the development server.
> > >
> > > The issue is with PRODUCTION.
> > >
> > > Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
> > >
> > > Can anyone tell me if suppling the 'path' in the main report .rdl for all of
> > > the subreports will fix the issue. Tried several permuations and have not
> > > been able to have a subreport shown.
> > >
> > > rob|||Rob,
Can I ask why you're not developing and deploying all your rdl's at
once, inside a single report project? It seems logical to keep
associated reports in the same "container", especially when you have 6
reports to keep track of.|||hi toolman
this is just how this company operates...
operations folks don't have access to/use any IDEs to deploy
in this case, I ended deploying this for them into production (Home
directory) and then had to use the 'MOVE' to move all reports.
not an ideal situation, but since I was the person who initially setup the
system(s), I still have access to them still. but typically, this would have
caused issues in this environment.
thanks rob
"toolman" wrote:
> Rob,
> Can I ask why you're not developing and deploying all your rdl's at
> once, inside a single report project? It seems logical to keep
> associated reports in the same "container", especially when you have 6
> reports to keep track of.
>
I have a working report with 5 additional subreports on my PC. Also, works
fine on the development server.
The issue is with PRODUCTION.
Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
Can anyone tell me if suppling the 'path' in the main report .rdl for all of
the subreports will fix the issue. Tried several permuations and have not
been able to have a subreport shown.
robjust doublechecked:
1. CAN deploy from VB.NET into the 'Home' directory in PRODUCTION and the
report/subreports work just fine :)
2. However, our 'normal' mode of operations is to copy the .RDLs from
DEVELOPMENT and upload them.
3. Attempting to deploy to any of the subdirectories/folders throws up an
authentication dialog.
4. My TargetServerURL: http://myproductionserver.here.mycompany.com/Reports
This needs to be something like:
http://myproductionserver.here.mycompany.com/Reports/thisapplicationreportsdir/reportnumber123
thanks
rob
"RobKaratzas" wrote:
> Hi Folks
> I have a working report with 5 additional subreports on my PC. Also, works
> fine on the development server.
> The issue is with PRODUCTION.
> Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
> Can anyone tell me if suppling the 'path' in the main report .rdl for all of
> the subreports will fix the issue. Tried several permuations and have not
> been able to have a subreport shown.
> rob|||sorry...
Finally, when deployed by hand (uploaded from .RDLs into where the reports
need to be) the subreports INDIVIDUALLY work just fine (so I'm pretty sure
it's a simply pathing related issue in the MAIN report).
Now, just how to modify the main report with the specific paths needed for
each subreport.
rob
"RobKaratzas" wrote:
> just doublechecked:
> 1. CAN deploy from VB.NET into the 'Home' directory in PRODUCTION and the
> report/subreports work just fine :)
> 2. However, our 'normal' mode of operations is to copy the .RDLs from
> DEVELOPMENT and upload them.
> 3. Attempting to deploy to any of the subdirectories/folders throws up an
> authentication dialog.
> 4. My TargetServerURL: http://myproductionserver.here.mycompany.com/Reports
> This needs to be something like:
> http://myproductionserver.here.mycompany.com/Reports/thisapplicationreportsdir/reportnumber123
> thanks
> rob
> "RobKaratzas" wrote:
> > Hi Folks
> >
> > I have a working report with 5 additional subreports on my PC. Also, works
> > fine on the development server.
> >
> > The issue is with PRODUCTION.
> >
> > Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
> >
> > Can anyone tell me if suppling the 'path' in the main report .rdl for all of
> > the subreports will fix the issue. Tried several permuations and have not
> > been able to have a subreport shown.
> >
> > rob|||Used the 'move' option to move all the reports to the proper location in the
SSRS tree.
The reports run just fine, however, this isn't the optimal way we want to
have to deploy our reports (preference is to upload the .rdls by hand).
rob
"RobKaratzas" wrote:
> sorry...
> Finally, when deployed by hand (uploaded from .RDLs into where the reports
> need to be) the subreports INDIVIDUALLY work just fine (so I'm pretty sure
> it's a simply pathing related issue in the MAIN report).
> Now, just how to modify the main report with the specific paths needed for
> each subreport.
> rob
> "RobKaratzas" wrote:
> > just doublechecked:
> >
> > 1. CAN deploy from VB.NET into the 'Home' directory in PRODUCTION and the
> > report/subreports work just fine :)
> >
> > 2. However, our 'normal' mode of operations is to copy the .RDLs from
> > DEVELOPMENT and upload them.
> >
> > 3. Attempting to deploy to any of the subdirectories/folders throws up an
> > authentication dialog.
> >
> > 4. My TargetServerURL: http://myproductionserver.here.mycompany.com/Reports
> > This needs to be something like:
> > http://myproductionserver.here.mycompany.com/Reports/thisapplicationreportsdir/reportnumber123
> >
> > thanks
> > rob
> >
> > "RobKaratzas" wrote:
> >
> > > Hi Folks
> > >
> > > I have a working report with 5 additional subreports on my PC. Also, works
> > > fine on the development server.
> > >
> > > The issue is with PRODUCTION.
> > >
> > > Our networking folks are disabling 127.0.0.1 and localhost in PRODUCTION.
> > >
> > > Can anyone tell me if suppling the 'path' in the main report .rdl for all of
> > > the subreports will fix the issue. Tried several permuations and have not
> > > been able to have a subreport shown.
> > >
> > > rob|||Rob,
Can I ask why you're not developing and deploying all your rdl's at
once, inside a single report project? It seems logical to keep
associated reports in the same "container", especially when you have 6
reports to keep track of.|||hi toolman
this is just how this company operates...
operations folks don't have access to/use any IDEs to deploy
in this case, I ended deploying this for them into production (Home
directory) and then had to use the 'MOVE' to move all reports.
not an ideal situation, but since I was the person who initially setup the
system(s), I still have access to them still. but typically, this would have
caused issues in this environment.
thanks rob
"toolman" wrote:
> Rob,
> Can I ask why you're not developing and deploying all your rdl's at
> once, inside a single report project? It seems logical to keep
> associated reports in the same "container", especially when you have 6
> reports to keep track of.
>
Subscribe to:
Posts (Atom)