Report Layout... TextBox Issue

I have two TextBoxes, they are next to each other and they touch.
According to their properties they are the same height, they are also the
same distance from the top.
Preview: they line up perfectly
After Deployment: one appears as though it is a slightly different height
Export To PDF: suddenly they're the same again
Why is this happening and how can I fix it?There are various properties on the text box you can set to specify where
it is located. If they have the same properties, that means they actually
want to be located in the same space. But the HTML viewer will position
them differently because it does not support overlay.
<Height></Height>
<Width></Width>
<Top></Top>
<Left></Left>
--
| Thread-Topic: Report Layout... TextBox Issue
| thread-index: AcS6nZhfn6F0qzGsTYehI9XjssWUhg==| X-WBNR-Posting-Host: 64.86.141.134
| From: "=?Utf-8?B?TUVSNzg=?=" <MER78@.discussions.microsoft.com>
| Subject: Report Layout... TextBox Issue
| Date: Mon, 25 Oct 2004 07:19:10 -0700
| Lines: 10
| Message-ID: <4592BB8A-993A-4A7A-98F1-2690E2E5658E@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33048
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have two TextBoxes, they are next to each other and they touch.
|
| According to their properties they are the same height, they are also the
| same distance from the top.
|
| Preview: they line up perfectly
| After Deployment: one appears as though it is a slightly different height
| Export To PDF: suddenly they're the same again
|
| Why is this happening and how can I fix it?
||||I think I mis-worded my question... I've had endless problems with text boxes
that touch... at least according to their properties they don't overlap... it
looks ok in one format... in another boxes get pushed onto other lines etc...
especially in excel...
I've started using a table for text boxes that touch whenever I can...
though it took me awhile to notice that you can use a table without having it
connected to a data source... if you put all of your stuff in header rows.
""Brad Syputa - MS"" wrote:
> There are various properties on the text box you can set to specify where
> it is located. If they have the same properties, that means they actually
> want to be located in the same space. But the HTML viewer will position
> them differently because it does not support overlay.
> <Height></Height>
> <Width></Width>
> <Top></Top>
> <Left></Left>

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..