Showing posts with label exporting. Show all posts
Showing posts with label exporting. Show all posts

Monday, March 26, 2012

Formatting, pdf, and SP2

I have a strange issue that I need help resolving. Basically, the formatting
on a report that I am exporting to pdf changed when I updated my VS to the
SP2 of the Reporting Services. Here's what I am trying to do and what SP2 did:
I have a report that I created that makes address labels. I made it to where
it has three columns, and it fit 10 rows on one page. It worked great, until
I installed SP2. Now, it will only print three across the top of the page,
then move on to the next page.
So, my questions are: 1) should I reinstall pre-SP2 RS so that I can do this
report the way that I had it, or 2) does anyone know of an example that will
help me to do what I had done in the pre-SP2 installation?
Any help would be greatly appreciated!!!It sounds weird, and at least I don't know if this is either caused by the
SP2. But what you can do is redefine your report's margins

Monday, March 12, 2012

Formating issues when exporting to excel

I have several columns in a report that have conditional formating. If
the criteria is met the data in the row is supposed to be green,
otherwise it is black. When I export this to excel, excel looks at the
format of the first row and then sets the formating for all the cells
to that color. Is there a way to make sure excel formats each
individual cell correctly?Also noticed that when i export the report when i run the report
through Visual Studio it exports it correctly. Is this a version issue
with RS?|||Hi, I have the same problems to set the color for each cell. Do you find the
solution? If does, please post back. Thank you.
"acahn@.planetmagpie.com" wrote:
> I have several columns in a report that have conditional formating. If
> the criteria is met the data in the row is supposed to be green,
> otherwise it is black. When I export this to excel, excel looks at the
> format of the first row and then sets the formating for all the cells
> to that color. Is there a way to make sure excel formats each
> individual cell correctly?
>|||Hi Jim,
I have not figured out the problem. I'm hopeing that when we migrate to
reporting services for 2005, that it fixes the issue...
"Jim Pan" wrote:
> Hi, I have the same problems to set the color for each cell. Do you find the
> solution? If does, please post back. Thank you.
> "acahn@.planetmagpie.com" wrote:
> > I have several columns in a report that have conditional formating. If
> > the criteria is met the data in the row is supposed to be green,
> > otherwise it is black. When I export this to excel, excel looks at the
> > format of the first row and then sets the formating for all the cells
> > to that color. Is there a way to make sure excel formats each
> > individual cell correctly?
> >
> >