excel formatting problem... could this be a bug?

Okay, I'll try my best to explain this....
I have a table on my report. Above the header for 5 of my columns, I need
to place a cell that spans all those columns. It looks like this:
--
| h |
--
| h | h | h | h | h |
--
| d | d | d | d | d |
--
h = header row
d = detail row
so, to do this I took the header cell for the left most column and merged it
with the
4 other header cells. Then I put a rectangle into that cell, and drew a
line through the middle to create the two level effect in the single header
cell. Then, where each 'h' is in the above diagram, I put a text box with
some text in it that serves as a label. So, basically all 5 of my detail
columns have their own individual header, as well as a header that applies to
all of them.
When I run the report, and export it to PDF, everything looks great. When I
export to excel, I get a strange effect. SRS seems to want to put the cell
for the textbox in the bottom right most 'cell' in the header in a row below
the other 4 in the second header 'row'.. So, it looks like this in Excel:
--
| h |
--
| h | h | h | h | |
--
| h |
| --|
| d | d | d | d | d |
--
h = header row
d = detail row
Anybody have any idea what's going on here? If I remove the 5th text box in
the header (the one that's causing the problem), excel formats fine.
It would be nice if I could merge cells across rows as well as columns,
because that would make this problem trivial.
Any help is greatly appreciated.
Jeff
JeffJeff,
Have you tried inserting a second table header row above the original table
header row? Then do the merging on the inserted header row. I just did this
on a report at my work. Doing so gave me this effect:
| H1 |
|H1|H2|H3|H4|
|D1|D2|D3|D4|
H1 = Table header inserted by me.
H2 = Orginal header inserted by RS
D..= Detail records
To do this right click on the handle for the exisitng table header row and
click Insert Row Above. The formatting stayed when I downloaded the report
to Excel. Hope this helps.
"Jeff" wrote:
> Okay, I'll try my best to explain this....
> I have a table on my report. Above the header for 5 of my columns, I need
> to place a cell that spans all those columns. It looks like this:
> --
> | h |
> --
> | h | h | h | h | h |
> --
> | d | d | d | d | d |
> --
> h = header row
> d = detail row
> so, to do this I took the header cell for the left most column and merged it
> with the
> 4 other header cells. Then I put a rectangle into that cell, and drew a
> line through the middle to create the two level effect in the single header
> cell. Then, where each 'h' is in the above diagram, I put a text box with
> some text in it that serves as a label. So, basically all 5 of my detail
> columns have their own individual header, as well as a header that applies to
> all of them.
> When I run the report, and export it to PDF, everything looks great. When I
> export to excel, I get a strange effect. SRS seems to want to put the cell
> for the textbox in the bottom right most 'cell' in the header in a row below
> the other 4 in the second header 'row'.. So, it looks like this in Excel:
> --
> | h |
> --
> | h | h | h | h | |
> --
> | h |
> | --|
> | d | d | d | d | d |
> --
>
> h = header row
> d = detail row
> Anybody have any idea what's going on here? If I remove the 5th text box in
> the header (the one that's causing the problem), excel formats fine.
> It would be nice if I could merge cells across rows as well as columns,
> because that would make this problem trivial.
> Any help is greatly appreciated.
>
> Jeff
> Jeff|||Hmmm.
I vaguely remember trying something like this, but maybe I didn't set it up
right. I'll give it another shot. Thanks.
"bsod55" wrote:
> Jeff,
> Have you tried inserting a second table header row above the original table
> header row? Then do the merging on the inserted header row. I just did this
> on a report at my work. Doing so gave me this effect:
> | H1 |
> |H1|H2|H3|H4|
> |D1|D2|D3|D4|
> H1 = Table header inserted by me.
> H2 = Orginal header inserted by RS
> D..= Detail records
> To do this right click on the handle for the exisitng table header row and
> click Insert Row Above. The formatting stayed when I downloaded the report
> to Excel. Hope this helps.
> "Jeff" wrote:
> > Okay, I'll try my best to explain this....
> >
> > I have a table on my report. Above the header for 5 of my columns, I need
> > to place a cell that spans all those columns. It looks like this:
> >
> > --
> > | h |
> > --
> > | h | h | h | h | h |
> > --
> > | d | d | d | d | d |
> > --
> >
> > h = header row
> > d = detail row
> >
> > so, to do this I took the header cell for the left most column and merged it
> > with the
> > 4 other header cells. Then I put a rectangle into that cell, and drew a
> > line through the middle to create the two level effect in the single header
> > cell. Then, where each 'h' is in the above diagram, I put a text box with
> > some text in it that serves as a label. So, basically all 5 of my detail
> > columns have their own individual header, as well as a header that applies to
> > all of them.
> >
> > When I run the report, and export it to PDF, everything looks great. When I
> > export to excel, I get a strange effect. SRS seems to want to put the cell
> > for the textbox in the bottom right most 'cell' in the header in a row below
> > the other 4 in the second header 'row'.. So, it looks like this in Excel:
> >
> > --
> > | h |
> > --
> > | h | h | h | h | |
> > --
> > | h |
> > | --|
> > | d | d | d | d | d |
> > --
> >
> >
> > h = header row
> > d = detail row
> >
> > Anybody have any idea what's going on here? If I remove the 5th text box in
> > the header (the one that's causing the problem), excel formats fine.
> >
> > It would be nice if I could merge cells across rows as well as columns,
> > because that would make this problem trivial.
> >
> > Any help is greatly appreciated.
> >
> >
> > Jeff
> > Jeff

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 not showing client name in heading

I am putting the client name in my header using ReportItems! reference to
textbox in report - this renders correctly on my server and in pdf however in
excel the client name is not showing up on the report. There are 2 textboxes
overlapping each other because I have 2 groups and when the page spans the
client name will come from the alt text box. I have tried NOT overlapping
them and the result is the same - neither one displays on the export to excel.This is common. In RS 2000, the pdf rendering extension didn't do it...
What you have to do to work around it is use rectangles and textboxes to
simulate a page header OR you can pass it in as a parameter.
-Tim
"MJT" <MJT@.discussions.microsoft.com> wrote in message
news:365BECF1-AD51-42E0-BF79-DE9011DC166C@.microsoft.com...
>I am putting the client name in my header using ReportItems! reference to
> textbox in report - this renders correctly on my server and in pdf however
> in
> excel the client name is not showing up on the report. There are 2
> textboxes
> overlapping each other because I have 2 groups and when the page spans the
> client name will come from the alt text box. I have tried NOT overlapping
> them and the result is the same - neither one displays on the export to
> excel.|||Thanks Tim,
Cant pass as a parm as they use client code (not the same) for the parm
and takes too long to run if I make it a report parm (since it cant be a
query parm I am using a stored procedure). I noticed your post about putting
this info not in a page heading but in a rectangle and hiding/showing which
might be an option if hiding/showing didnt leave white space when hidden (big
problem). Seems like such a simple basic thing that should work, doesnt it?
I mean ... who *doesnt* need data information in their heading'
"Tim Dot NoSpam" wrote:
> This is common. In RS 2000, the pdf rendering extension didn't do it...
> What you have to do to work around it is use rectangles and textboxes to
> simulate a page header OR you can pass it in as a parameter.
> -Tim
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:365BECF1-AD51-42E0-BF79-DE9011DC166C@.microsoft.com...
> >I am putting the client name in my header using ReportItems! reference to
> > textbox in report - this renders correctly on my server and in pdf however
> > in
> > excel the client name is not showing up on the report. There are 2
> > textboxes
> > overlapping each other because I have 2 groups and when the page spans the
> > client name will come from the alt text box. I have tried NOT overlapping
> > them and the result is the same - neither one displays on the export to
> > excel.
>
>|||Hi
Can to tell me to Hide or disable page Header while exporting to Excel format.
calvin
"MJT" wrote:
> I am putting the client name in my header using ReportItems! reference to
> textbox in report - this renders correctly on my server and in pdf however in
> excel the client name is not showing up on the report. There are 2 textboxes
> overlapping each other because I have 2 groups and when the page spans the
> client name will come from the alt text box. I have tried NOT overlapping
> them and the result is the same - neither one displays on the export to excel.|||Hi
I want to export a report to excel format, but in excel the page header
should not come. Can u please help how to slove this.
Calvin
"Tim Dot NoSpam" wrote:
> This is common. In RS 2000, the pdf rendering extension didn't do it...
> What you have to do to work around it is use rectangles and textboxes to
> simulate a page header OR you can pass it in as a parameter.
> -Tim
> "MJT" <MJT@.discussions.microsoft.com> wrote in message
> news:365BECF1-AD51-42E0-BF79-DE9011DC166C@.microsoft.com...
> >I am putting the client name in my header using ReportItems! reference to
> > textbox in report - this renders correctly on my server and in pdf however
> > in
> > excel the client name is not showing up on the report. There are 2
> > textboxes
> > overlapping each other because I have 2 groups and when the page spans the
> > client name will come from the alt text box. I have tried NOT overlapping
> > them and the result is the same - neither one displays on the export to
> > excel.
>
>

Excel export missing table header

I am working with RS2000 SP2 and VS2003.

I have a simple report with just one table, two levels of grouping with subtotals and a table header. There is also a separate page header. The report renders correctly on screen and when printed.

When I export the report in Excel format the detail lines, group sub-totals and page head appear. However, the problem I have is that the table header is not shown. So the user can't make out what data is shown each column. How can I get the table header to appear when exporting to Excel?

TIA, Magendo_man

To complicate matters further, I have added another table to this report, which is a copy of the original one. This table uses the same dataset but is filtered and sorted differently, with no grouping and a footer total. I set the table to have a page break before it is printed.

Now when I export to Excel I get the same problem with missing table header for the first table, but I do get the table header for this second table.

TIA, Magendo_man

Excel Export Does not print Date

Hi Guys,
I have a date in the report Page header.
When i export this report to .pdf it shows the date in the adobe but when i
export it to excel file date does not appear
plz help me
Thanks
ChandraI've the same problem but the date-values in my report are shown as decimal
values. Do you've already a solution?
"Chandra" wrote:
> Hi Guys,
> I have a date in the report Page header.
> When i export this report to .pdf it shows the date in the adobe but when i
> export it to excel file date does not appear
> plz help me
> Thanks
> Chandra
>

every other printed page blank?

I made a report, put a header, footer and a table on it with data, when in
report view it shows up as 24 pages.. when in print view it shows up as 60
pages with every other one blank but containing a header and footer only?
what would cause this? page size, margins, anything like that? thanks!Check the page size on your currently selected printer and the border sizes
Check the width of the report - it should be less than (page width - left
border - right border)
HTH,
Andrei.
"Smokey Grindle" <nospam@.dontspamme.com> wrote in message
news:OBudLkNOHHA.420@.TK2MSFTNGP06.phx.gbl...
>I made a report, put a header, footer and a table on it with data, when in
>report view it shows up as 24 pages.. when in print view it shows up as 60
>pages with every other one blank but containing a header and footer only?
>what would cause this? page size, margins, anything like that? thanks!
>|||got it thanks! It was the "report" size that was too large for the page size
+ margins
"Andrei" <andrei.toma@.era-environmental.com> wrote in message
news:eCEqEsNOHHA.1248@.TK2MSFTNGP03.phx.gbl...
> Check the page size on your currently selected printer and the border
> sizes
> Check the width of the report - it should be less than (page width - left
> border - right border)
> HTH,
> Andrei.
> "Smokey Grindle" <nospam@.dontspamme.com> wrote in message
> news:OBudLkNOHHA.420@.TK2MSFTNGP06.phx.gbl...
>>I made a report, put a header, footer and a table on it with data, when in
>>report view it shows up as 24 pages.. when in print view it shows up as 60
>>pages with every other one blank but containing a header and footer only?
>>what would cause this? page size, margins, anything like that? thanks!
>