Saturday, February 25, 2012

RS driving nuts :(..

There seems to be lot of issues with formatting the appearance of the cells.
for instance, if I reset the Border from "No Border" to "Bottom Border" for
a partcular cell, save the changes, Rebuild the report; the final report
still does not the changes show the updated Border of the cell.
Similarly, adjusting the row height of a cell or adjusting the column widths
still causes empry spaces to appear in the row and blank pages in the pdf
version.
None of the changes are updated after a built. This is really driving me
nuts. Pls. help. The formatting's taking lot of time.
Does the SP1 support strong formatting/pdf export? I need to urgently submit
this report to a client and hence have been reluctant to apply the new patch
in a fear of breaking something.It took me a while to figure out the boarder stuff in RS, too.
Those values are for each cell in the table. So, if you turn the bottom boarder off on a cell and the top boarder is on for the
cell under it then the cell will look like it still had the bottom boarder.
As for as the blank pages in the PDF. This one took me a while to realize what was happening.
What I found is that the space of the report plus the margins that I was using for the report were greater then the size of the
paper that I was exporting the report to. Be sure the sum of those two measurements are less then the dimension of your page.
Hope this helps!
"newmem" <""> wrote in message news:%23ULthaTWEHA.2928@.tk2msftngp13.phx.gbl...
> There seems to be lot of issues with formatting the appearance of the cells.
> for instance, if I reset the Border from "No Border" to "Bottom Border" for
> a partcular cell, save the changes, Rebuild the report; the final report
> still does not the changes show the updated Border of the cell.
> Similarly, adjusting the row height of a cell or adjusting the column widths
> still causes empry spaces to appear in the row and blank pages in the pdf
> version.
> None of the changes are updated after a built. This is really driving me
> nuts. Pls. help. The formatting's taking lot of time.
> Does the SP1 support strong formatting/pdf export? I need to urgently submit
> this report to a client and hence have been reluctant to apply the new patch
> in a fear of breaking something.
>|||A couple of additional thoughts.
If you first click on a table row or column selector any border
modifications will be applied to the entire row or column.
To avoid the extra pages in PDF please check that
(Report.PageWidth - Report.LeftMargin - Report.Right Margin) >= Body.Width
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:eVdg6nTWEHA.2928@.tk2msftngp13.phx.gbl...
> It took me a while to figure out the boarder stuff in RS, too.
> Those values are for each cell in the table. So, if you turn the bottom
boarder off on a cell and the top boarder is on for the
> cell under it then the cell will look like it still had the bottom
boarder.
> As for as the blank pages in the PDF. This one took me a while to realize
what was happening.
> What I found is that the space of the report plus the margins that I was
using for the report were greater then the size of the
> paper that I was exporting the report to. Be sure the sum of those two
measurements are less then the dimension of your page.
> Hope this helps!
> "newmem" <""> wrote in message
news:%23ULthaTWEHA.2928@.tk2msftngp13.phx.gbl...
> > There seems to be lot of issues with formatting the appearance of the
cells.
> > for instance, if I reset the Border from "No Border" to "Bottom Border"
for
> > a partcular cell, save the changes, Rebuild the report; the final report
> > still does not the changes show the updated Border of the cell.
> > Similarly, adjusting the row height of a cell or adjusting the column
widths
> > still causes empry spaces to appear in the row and blank pages in the
pdf
> > version.
> >
> > None of the changes are updated after a built. This is really driving me
> > nuts. Pls. help. The formatting's taking lot of time.
> >
> > Does the SP1 support strong formatting/pdf export? I need to urgently
submit
> > this report to a client and hence have been reluctant to apply the new
patch
> > in a fear of breaking something.
> >
> >
>|||Indeed, the border formatting is a bit tricky. Nevertheless I got acceptable
results in a quick time using the print preview. It's faster than a build
and comes very close to e.g. the PDF layout.
roland|||thanks guys.
After much manipulating the values of the left/right margin and the column
spacing, I think I got rid of the blank page.
The following might be helpful to note:
(FYI:) The new Wrox book on RS says that with multiple columns, reporting
services uses the following equation:
Report Page Width >= (Body Width * No. of Columns) + (column spacing * (No.
of columns -1 )
"Roland" <nomail@.spamprotect.com> wrote in message
news:uiJeothWEHA.3120@.TK2MSFTNGP12.phx.gbl...
> Indeed, the border formatting is a bit tricky. Nevertheless I got
acceptable
> results in a quick time using the print preview. It's faster than a build
> and comes very close to e.g. the PDF layout.
> roland
>

No comments:

Post a Comment