Excel Format different from PDF and Image

I have a report that looks good in .PDF and .tif format, but really bad
in Excel format. Can anything be done about this?
Thank you!Carol,
At the heart of things is the fact that .PDF and .TIF simply render an
image of the report while Excel is trying to insert the entire report,
including headers and footers, into a viable spreadsheet.
Without seeing the Excel output, it's tough to know for sure what
issues you're having but typically the problem with Excel is it inserts
additional columns (and sometimes rows as well) that don't exist in the
original report design.
The cause is that the left and right borders of some report objects
(text boxes, etc.) are not lining up in the different report sections
and/or data regions. For example, if there's a text box in the page
header that's 1" wide and then a 1.25" wide table column in the body
(under the 1" header text box), Excel will render that into two
columns. That's a pretty basic example but the problem greatly
exacerbates if you're using free-form data regions or multiple tables
or tables with subreports.
Unfortunately, the only way to resolve this is to manipulate everything
in the report design to line up as much as possible. It helps to use
the various width and height properties to set things to match up
exactly as opposed to relying just on "eyeballing" it.
Hope this helps.

Excel Exports Hidden Images

Hello,
I think this may be a bug with SSRS 2005 but wanted to verify in case anyone
has a remedy. My report contains a table with an image on the detail row
whose visibility is toggled based on a value. Everything works as expected
when viewing the report onscreen or exporting to PDF. However, the Excel
Export ignores the visibility expression and displays the image for every
detail row. Any thoughts or workarounds?
Thanks in advance!
KathyOn Jul 6, 10:44 am, Kathy <K...@.discussions.microsoft.com> wrote:
> Hello,
> I think this may be a bug with SSRS 2005 but wanted to verify in case anyone
> has a remedy. My report contains a table with an image on the detail row
> whose visibility is toggled based on a value. Everything works as expected
> when viewing the report onscreen or exporting to PDF. However, the Excel
> Export ignores the visibility expression and displays the image for every
> detail row. Any thoughts or workarounds?
> Thanks in advance!
> Kathy
As far as I know, you are correct. Hopefully this will be corrected in
a future SP or in SSRS 2008. Sorry that I could not be of further
assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Thank you for the quick response. Have a lovely day!
"EMartinez" wrote:
> On Jul 6, 10:44 am, Kathy <K...@.discussions.microsoft.com> wrote:
> > Hello,
> >
> > I think this may be a bug with SSRS 2005 but wanted to verify in case anyone
> > has a remedy. My report contains a table with an image on the detail row
> > whose visibility is toggled based on a value. Everything works as expected
> > when viewing the report onscreen or exporting to PDF. However, the Excel
> > Export ignores the visibility expression and displays the image for every
> > detail row. Any thoughts or workarounds?
> >
> > Thanks in advance!
> > Kathy
>
> As far as I know, you are correct. Hopefully this will be corrected in
> a future SP or in SSRS 2008. Sorry that I could not be of further
> assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jul 9, 8:38 am, Kathy <K...@.discussions.microsoft.com> wrote:
> Thank you for the quick response. Have a lovely day!
> "EMartinez" wrote:
> > On Jul 6, 10:44 am, Kathy <K...@.discussions.microsoft.com> wrote:
> > > Hello,
> > > I think this may be a bug with SSRS 2005 but wanted to verify in case anyone
> > > has a remedy. My report contains a table with an image on the detail row
> > > whose visibility is toggled based on a value. Everything works as expected
> > > when viewing the report onscreen or exporting to PDF. However, the Excel
> > > Export ignores the visibility expression and displays the image for every
> > > detail row. Any thoughts or workarounds?
> > > Thanks in advance!
> > > Kathy
> > As far as I know, you are correct. Hopefully this will be corrected in
> > a future SP or in SSRS 2008. Sorry that I could not be of further
> > assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Excel Exporting - Merged Columns

Hey Ppl,
When exporting to excel, the renderer merges columns. I have a Header that contains an image and two simple labels (image on left and two label starting from about center). When there is a table beneath the Header, the right hand side of the image and the left hand sides of the labels create merged colums where it intersects in the table below.
Is there a way to stop this' Or
Has anyone found a way around this'
I have tried overlapping (exporting places them side-by-side) , background image (this is not exported to excel)
It is driving me mad =S, ANY help appreciated
Thanks in Advance
SheaYou can use SimplePageHeaders device info - the page header is rendered like
an excel header and will not be part of the excel sheet. In this way will
not affect your sheet structure.
Excel doens't allow background image for individual cells, only for the
sheet.
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shea Strickland" <Shea Strickland@.discussions.microsoft.com> wrote in
message news:6D038509-CFDE-433B-AF35-34828E767329@.microsoft.com...
> Hey Ppl,
> When exporting to excel, the renderer merges columns. I have a Header that
contains an image and two simple labels (image on left and two label
starting from about center). When there is a table beneath the Header, the
right hand side of the image and the left hand sides of the labels create
merged colums where it intersects in the table below.
> Is there a way to stop this' Or
> Has anyone found a way around this'
> I have tried overlapping (exporting places them side-by-side) , background
image (this is not exported to excel)
> It is driving me mad =S, ANY help appreciated
> Thanks in Advance
> Shea|||Hi Nico,
This sounds like the fix, although I have been looking thought the report properties / sub menus pretty much everywhere and i cant find anything to do with SimplePageHeaders device info. Where is this located? or is this in a .config file?
Thanks for your help
Shea
"Nico Cristache [MSFT]" wrote:
> You can use SimplePageHeaders device info - the page header is rendered like
> an excel header and will not be part of the excel sheet. In this way will
> not affect your sheet structure.
> Excel doens't allow background image for individual cells, only for the
> sheet.
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Shea Strickland" <Shea Strickland@.discussions.microsoft.com> wrote in
> message news:6D038509-CFDE-433B-AF35-34828E767329@.microsoft.com...
> > Hey Ppl,
> >
> > When exporting to excel, the renderer merges columns. I have a Header that
> contains an image and two simple labels (image on left and two label
> starting from about center). When there is a table beneath the Header, the
> right hand side of the image and the left hand sides of the labels create
> merged colums where it intersects in the table below.
> >
> > Is there a way to stop this' Or
> > Has anyone found a way around this'
> >
> > I have tried overlapping (exporting places them side-by-side) , background
> image (this is not exported to excel)
> >
> > It is driving me mad =S, ANY help appreciated
> >
> > Thanks in Advance
> > Shea
>
>|||It is a device info property - you need to set it on the url when you access
the report (rc:SimplePageHeaders=true)
--
Nico Cristache [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Shea Strickland" <SheaStrickland@.discussions.microsoft.com> wrote in
message news:94539F7F-912A-4850-B3F6-2F61E0DC77E5@.microsoft.com...
> Hi Nico,
> This sounds like the fix, although I have been looking thought the report
properties / sub menus pretty much everywhere and i cant find anything to do
with SimplePageHeaders device info. Where is this located? or is this in a
.config file?
> Thanks for your help
> Shea
> "Nico Cristache [MSFT]" wrote:
> > You can use SimplePageHeaders device info - the page header is rendered
like
> > an excel header and will not be part of the excel sheet. In this way
will
> > not affect your sheet structure.
> >
> > Excel doens't allow background image for individual cells, only for the
> > sheet.
> >
> > --
> > Nico Cristache [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Shea Strickland" <Shea Strickland@.discussions.microsoft.com> wrote in
> > message news:6D038509-CFDE-433B-AF35-34828E767329@.microsoft.com...
> > > Hey Ppl,
> > >
> > > When exporting to excel, the renderer merges columns. I have a Header
that
> > contains an image and two simple labels (image on left and two label
> > starting from about center). When there is a table beneath the Header,
the
> > right hand side of the image and the left hand sides of the labels
create
> > merged colums where it intersects in the table below.
> > >
> > > Is there a way to stop this' Or
> > > Has anyone found a way around this'
> > >
> > > I have tried overlapping (exporting places them side-by-side) ,
background
> > image (this is not exported to excel)
> > >
> > > It is driving me mad =S, ANY help appreciated
> > >
> > > Thanks in Advance
> > > Shea
> >
> >
> >|||Thanks for the speedy responses =)
Ok i've done that i put it in a url and it worked (only when i format straight to EXCEL). It did not put the image in the header though (is this possible?).
Next question, I have a web treeview control dynamically built with the navigate url property of the node set to the path property of the CatalogItem.Path returned from the ws' ListChildren method. This then displays the report in an iFrame when clicked. I appended the "&rs:SimplePageHeader=true" to the naviaget url fine. But when you choose Excel from the export drop down it resets the url and looses the rs device info setting. I dont wish to automatically asume that the user would like to export the Excel, so it is necessary to show it first in a iframe instead of specifying the "rs:format=EXCEL". Is it possible to change the behaviour of the Excel export option in the dropdown or similar'
Thanks heaps
Shea
"Nico Cristache [MSFT]" wrote:
> It is a device info property - you need to set it on the url when you access
> the report (rc:SimplePageHeaders=true)
> --
> Nico Cristache [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Shea Strickland" <SheaStrickland@.discussions.microsoft.com> wrote in
> message news:94539F7F-912A-4850-B3F6-2F61E0DC77E5@.microsoft.com...
> > Hi Nico,
> >
> > This sounds like the fix, although I have been looking thought the report
> properties / sub menus pretty much everywhere and i cant find anything to do
> with SimplePageHeaders device info. Where is this located? or is this in a
> ..config file?
> >
> > Thanks for your help
> > Shea
> >
> > "Nico Cristache [MSFT]" wrote:
> >
> > > You can use SimplePageHeaders device info - the page header is rendered
> like
> > > an excel header and will not be part of the excel sheet. In this way
> will
> > > not affect your sheet structure.
> > >
> > > Excel doens't allow background image for individual cells, only for the
> > > sheet.
> > >
> > > --
> > > Nico Cristache [MSFT]
> > > Microsoft SQL Server Reporting Services
> > >
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Shea Strickland" <Shea Strickland@.discussions.microsoft.com> wrote in
> > > message news:6D038509-CFDE-433B-AF35-34828E767329@.microsoft.com...
> > > > Hey Ppl,
> > > >
> > > > When exporting to excel, the renderer merges columns. I have a Header
> that
> > > contains an image and two simple labels (image on left and two label
> > > starting from about center). When there is a table beneath the Header,
> the
> > > right hand side of the image and the left hand sides of the labels
> create
> > > merged colums where it intersects in the table below.
> > > >
> > > > Is there a way to stop this' Or
> > > > Has anyone found a way around this'
> > > >
> > > > I have tried overlapping (exporting places them side-by-side) ,
> background
> > > image (this is not exported to excel)
> > > >
> > > > It is driving me mad =S, ANY help appreciated
> > > >
> > > > Thanks in Advance
> > > > Shea
> > >
> > >
> > >
>
>sql

excel export binary data?

hi

i used to export my tables to excel file

but now i have tables which have binary (image) data

what happens to them?

is there any way to backup these data?

Hi,

IMHO it is always a bad idea to store image data in a database, as databases are not meant to store BLOBs. It's possible, of course, in which case you can backup the data by backing up your database, but if I were you, I'd store the data on a fileshare, and only store a link to the location of the image in the database.

HTH.

Peter

Excel Export - How to stop Merged Columns?

Hello All,
I am having a lot of fun when exporting to excel. When there is a control (image etc) above a table and the sides of the image stop half way through a column this creates a merged column in excel. This creates headaches for clients when trying to chart this data. Is there anyway around this? Or any secrets?
I placed the image into a header and set the device info url to "rc:SimplePageHeaders=true" this helped by placing the header into an excel header upon rendering BUT there was no image in there'
Thanks in advance
SheaThat is one of the drawbacks of Excel exporting is the columns need to line up. Try this. If the image is wider than the first column and ends in the middle of the second column. insert a column between the first and second columns and make it so its edge lines up with the edge of the image. reduce the width of the now third column so the new column and it are the same width as the original second column. Then merge the two cells in the table. That may help with your problem.
"Shea Strickland" wrote:
> Hello All,
> I am having a lot of fun when exporting to excel. When there is a control (image etc) above a table and the sides of the image stop half way through a column this creates a merged column in excel. This creates headaches for clients when trying to chart this data. Is there anyway around this? Or any secrets?
> I placed the image into a header and set the device info url to "rc:SimplePageHeaders=true" this helped by placing the header into an excel header upon rendering BUT there was no image in there'
> Thanks in advance
> Sheasql

Example with image

Hi,
Is there example what gets image form custom code or from custom assembly as Byte() ( reading from file, etc ), what works correctly in Report Manager ?
Thanks.Thanks, I've solved my problem.|||FYI: Visual Studio 2005 Beta 1 (download from
http://lab.msdn.microsoft.com/vs2005/) contains a nice command line tool
related to code access security: PermCalc. After installation it is located
at \Program Files\Microsoft Visual Studio 8\Common7\IDE\Permcalc.exe
PermCalc estimates all necessary security permissions that must be granted
for every dll entrypoint in order to avoid security exceptions at runtime.
This estimation is done by performing static IL analysis. Permcalc is also
integrated into the VS Whidbey UI. In order to get the list of necessary
permissions for all custom assembly entry points, you would just run e.g.
permcalc -progress -library CustomAssembly.dll
Therefore you can more easily identify which missing security permission
asserts and grants cause the execution of custom assemblies to fail. Note:
PermCalc can even analyze dlls compiled with older versions of the .NET
Framework (e.g. VS 2003).
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:D91E77B8-2643-457A-A371-CE6D103459EE@.microsoft.com...
> Thanks, I've solved my problem.|||I have created an employee scorecard report that is populated through
choosing a parameter. Now when an employee is chosen from the list his data
will show on the report and I need to show their picture. The pictures are
stored in a folder on a netword drive as LastName, FirstName.jpg
So when someone choses Joe Schmo, it would be Schmo, Joe.jpg stored in
i://intranet/employeePictures
Any help would be greatly appreciated!
"Robert Bruckner [MSFT]" wrote:
> FYI: Visual Studio 2005 Beta 1 (download from
> http://lab.msdn.microsoft.com/vs2005/) contains a nice command line tool
> related to code access security: PermCalc. After installation it is located
> at \Program Files\Microsoft Visual Studio 8\Common7\IDE\Permcalc.exe
> PermCalc estimates all necessary security permissions that must be granted
> for every dll entrypoint in order to avoid security exceptions at runtime.
> This estimation is done by performing static IL analysis. Permcalc is also
> integrated into the VS Whidbey UI. In order to get the list of necessary
> permissions for all custom assembly entry points, you would just run e.g.
> permcalc -progress -library CustomAssembly.dll
> Therefore you can more easily identify which missing security permission
> asserts and grants cause the execution of custom assemblies to fail. Note:
> PermCalc can even analyze dlls compiled with older versions of the .NET
> Framework (e.g. VS 2003).
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Ivan" <Ivan@.discussions.microsoft.com> wrote in message
> news:D91E77B8-2643-457A-A371-CE6D103459EE@.microsoft.com...
> > Thanks, I've solved my problem.
>
>

Exactly HOW would one go about creating a constant for a report?

Do you create it in the code section of the report Properties? IF so, how? If you don't do it there where do you do it?

I have an image in the page header, but I don't want it to repeat after the first page. And there are two images actually, and the one that is chosen for display is based upon a company id.

How do you control that?

You can control the visiblity state of the image based on the Page Number, e.g. set the hidden property to =IIF(Globals!PageNumber = 1, false, true).|||

i have a question for you before answering your question. i did have the same situation...

what is the image source..., whether it is from database, embedded or url .....

since you cannot access dataset in page header, i do not how you are managing to display the image based upon on company id.

what i have done is i have a subreport. in that subreport i am getting the image from db and displaying based upon company id parameter.

the same thing i placed it in main report and pass the company id as parameter... based upon the company id, it displays respective company logo.

regarding displaying it only first page or not, i use the global variables like pagenumber to play with....

hope u got what u want

|||what you described is what I ended up doing. I actually have the image (gif) in the project in a table header, it takes up two rows, one for each image, and which one is displayed is dependent on the company id.|||still my question is: whatis the process for creating a constant for a report? Do you do it through custom code?

Exactly HOW would one go about creating a constant for a report?

Do you create it in the code section of the report Properties? IF so, how? If you don't do it there where do you do it?

I have an image in the page header, but I don't want it to repeat after the first page. And there are two images actually, and the one that is chosen for display is based upon a company id.

How do you control that?

You can control the visiblity state of the image based on the Page Number, e.g. set the hidden property to =IIF(Globals!PageNumber = 1, false, true).|||

i have a question for you before answering your question. i did have the same situation...

what is the image source..., whether it is from database, embedded or url .....

since you cannot access dataset in page header, i do not how you are managing to display the image based upon on company id.

what i have done is i have a subreport. in that subreport i am getting the image from db and displaying based upon company id parameter.

the same thing i placed it in main report and pass the company id as parameter... based upon the company id, it displays respective company logo.

regarding displaying it only first page or not, i use the global variables like pagenumber to play with....

hope u got what u want

|||what you described is what I ended up doing. I actually have the image (gif) in the project in a table header, it takes up two rows, one for each image, and which one is displayed is dependent on the company id.|||still my question is: whatis the process for creating a constant for a report? Do you do it through custom code?

Exactly HOW would one go about creating a constant for a report?

Do you create it in the code section of the report Properties? IF so, how? If you don't do it there where do you do it?

I have an image in the page header, but I don't want it to repeat after the first page. And there are two images actually, and the one that is chosen for display is based upon a company id.

How do you control that?

You can control the visiblity state of the image based on the Page Number, e.g. set the hidden property to =IIF(Globals!PageNumber = 1, false, true).|||

i have a question for you before answering your question. i did have the same situation...

what is the image source..., whether it is from database, embedded or url .....

since you cannot access dataset in page header, i do not how you are managing to display the image based upon on company id.

what i have done is i have a subreport. in that subreport i am getting the image from db and displaying based upon company id parameter.

the same thing i placed it in main report and pass the company id as parameter... based upon the company id, it displays respective company logo.

regarding displaying it only first page or not, i use the global variables like pagenumber to play with....

hope u got what u want

|||what you described is what I ended up doing. I actually have the image (gif) in the project in a table header, it takes up two rows, one for each image, and which one is displayed is dependent on the company id.|||still my question is: whatis the process for creating a constant for a report? Do you do it through custom code?