Report Header

Can any one tell me what to use to substitute Table in report Header?Or is there any other way?Because when i am using Textboxes align horizontally as replace to table,to align to my table in the body,when i exported it to excel,ive got problems in alignment in cell,Thanks

Hi,

Please read the BOL about Excel rendering:

Designing and Creating Reports > Design Considerations for Report Rendering > Designing for Microsoft Excel Output >

Regards,

Janos

|||Thanks for the reply..But have you forgotten to put the link to the Text?Or it really does not contain a link?
Thank You..|||Another thing,i am now aware that even a bit point exceed in edge of textboxes can cause some distortion in Excel.But no matter how i align all the cells,It always happen to be that over lapping takes place.Even though i copied the exact size of the textboxes in the table.So i think,putting the table header in the report header would be the best solution,where i dont think is possible(but i do hope)..
Thanks again..|||

Hi,

I'm so sorry, I forget to link it. Here you are:

http://technet.microsoft.com/en-us/library/ms159836.aspx

or in BOL:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/d2cfa39f-7092-4c55-aab2-6d28ab5731e2.htm

Regards,

Janos

|||Hi,
You can put Table Header in to the Report header.But then you face problem in Sorting i.e you will not get column names as sort by option.
For Example if u have column named Sales in Report Header which is the first column.
In Excel you wont get Sort by Sales ,instead you will get sort by column A.This happens because you should not have any gap between Table Header and its detail section.
Overlapping of cells also makes a separate column in Excel.
Hope it was useful to you.

Thanks ,
Shri|||Thanks for the reply..I have learned a lot..but i think its not enough.I still can't fix my issue.|||I had tried your suggestion shrinidhiBK,but still it wont work.Because when i preview my report, an error comes out saying that a DataRegion cannot be placed in a report header..By the way...thanks for the reply..