I have developed few reports using reporting services (service pack 2), but
still facing some problem in the date parameter and would look for help /
share here. Thanks advance!
1) How RS treat the date format?
YYYY-MM-DD (the data is correct when i use this format)
DD/MM/YYYY
MM/DD/YYYY
What is the purpose to define the date parameter as "MM/DD/YYYY" from the
"Expression" windows?
Any way to limit the input date format or any method to convert the format
to YYYY-MM-DD if user really input the format as DD/MM/YYYY or MM/DD/YYYY?
2) Anyone know how to use date time picker in RS, or possible to use it? I
believe if RS could use the date time picker, I don't need to worry the
parameter formatHi,
have a look at this article:
http://www.databasejournal.com/features/mssql/article.php/2197931
You'll find the way to solve your problem (I had the same problem and by
converting the date with the CONVERT function in my SQL query I managed to
solve it).
If you have some time could you take a look at my post (just after yours),
maybe you have the solution.
Thanks,
--
JB
"Franklin" wrote:
> I have developed few reports using reporting services (service pack 2), but
> still facing some problem in the date parameter and would look for help /
> share here. Thanks advance!
> 1) How RS treat the date format?
> YYYY-MM-DD (the data is correct when i use this format)
> DD/MM/YYYY
> MM/DD/YYYY
> What is the purpose to define the date parameter as "MM/DD/YYYY" from the
> "Expression" windows?
> Any way to limit the input date format or any method to convert the format
> to YYYY-MM-DD if user really input the format as DD/MM/YYYY or MM/DD/YYYY?
> 2) Anyone know how to use date time picker in RS, or possible to use it? I
> believe if RS could use the date time picker, I don't need to worry the
> parameter format
>sql
Showing posts with label format. Show all posts
Showing posts with label format. Show all posts
Wednesday, March 28, 2012
Report Paging
This is a multi-part message in MIME format.
--=_NextPart_000_00B0_01C7B32E.8ACDD040
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How do I define the number of lines per page in Report Designer? I have = defined the report as 11" x 8.5" landscape but when I preview or print, = I am getting alternate correctly numbered pages consisting just a report = header & report footer. I'm assuming that it is related to an issue = with rows per page, but am unable to find the definition to give that a = try.
--=_NextPart_000_00B0_01C7B32E.8ACDD040
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
How do I define the = number of lines per page in Report Designer? I have defined the report as = 11=94 x 8.5=94 landscape but when I preview or print, I am getting alternate correctly = numbered pages consisting just a report header & report footer. I=92m = assuming that it is related to an issue with rows per page, but am unable to find = the definition to give that a try.
--=_NextPart_000_00B0_01C7B32E.8ACDD040--On Jun 20, 2:31 pm, "Joe" <hortoris...@.gmail.dot.com> wrote:
> How do I define the number of lines per page in Report Designer? I have defined the report as 11" x 8.5" landscape but when I preview or print, I am getting alternate correctly numbered pages consisting just a report header & report footer. I'm assuming that it is related to an issue with rows per page, but am unable to find the definition to give that a try.
What is the width of the report body? If the body is wider than page
then you will get these extra pages. It doesn't matter if there is
nothing to display, it will still think your report needs to be that
wide.|||There's a good explanation of report paging in
http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx.
However, even having followed the instructions on this blog, we have
problems with report paging as well. We seem to have some reports that show
fewer pages in the report viewer than when they are printed to pdf or the
printer. We even have one report, that depending on the parameters, shows as
a single page in the viewer and many pages when printing in pdf or the
printer. Are there other people having these problems as well?
"Joe" wrote:
> How do I define the number of lines per page in Report Designer? I have defined the report as 11" x 8.5" landscape but when I preview or print, I am getting alternate correctly numbered pages consisting just a report header & report footer. I'm assuming that it is related to an issue with rows per page, but am unable to find the definition to give that a try
--=_NextPart_000_00B0_01C7B32E.8ACDD040
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How do I define the number of lines per page in Report Designer? I have = defined the report as 11" x 8.5" landscape but when I preview or print, = I am getting alternate correctly numbered pages consisting just a report = header & report footer. I'm assuming that it is related to an issue = with rows per page, but am unable to find the definition to give that a = try.
--=_NextPart_000_00B0_01C7B32E.8ACDD040
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
How do I define the = number of lines per page in Report Designer? I have defined the report as = 11=94 x 8.5=94 landscape but when I preview or print, I am getting alternate correctly = numbered pages consisting just a report header & report footer. I=92m = assuming that it is related to an issue with rows per page, but am unable to find = the definition to give that a try.
--=_NextPart_000_00B0_01C7B32E.8ACDD040--On Jun 20, 2:31 pm, "Joe" <hortoris...@.gmail.dot.com> wrote:
> How do I define the number of lines per page in Report Designer? I have defined the report as 11" x 8.5" landscape but when I preview or print, I am getting alternate correctly numbered pages consisting just a report header & report footer. I'm assuming that it is related to an issue with rows per page, but am unable to find the definition to give that a try.
What is the width of the report body? If the body is wider than page
then you will get these extra pages. It doesn't matter if there is
nothing to display, it will still think your report needs to be that
wide.|||There's a good explanation of report paging in
http://blogs.msdn.com/bwelcker/archive/2005/08/19/454043.aspx.
However, even having followed the instructions on this blog, we have
problems with report paging as well. We seem to have some reports that show
fewer pages in the report viewer than when they are printed to pdf or the
printer. We even have one report, that depending on the parameters, shows as
a single page in the viewer and many pages when printing in pdf or the
printer. Are there other people having these problems as well?
"Joe" wrote:
> How do I define the number of lines per page in Report Designer? I have defined the report as 11" x 8.5" landscape but when I preview or print, I am getting alternate correctly numbered pages consisting just a report header & report footer. I'm assuming that it is related to an issue with rows per page, but am unable to find the definition to give that a try
Monday, March 26, 2012
Report out an html string
Is it possible to report out an html string into the rich format?
--> I use an html control (RichTextBox 2.5) that allows the user to create
the main body of a quote in a wysiwyg environment, and that formatting is
successfully saved as an html string to the SQL db and successfully displayed
when opening back up in the control.
--> Will Reporting Services allow me to take that html string and display in
the main body of a report, with the formatting applied (i.e. bold, bullets,
etc.)?
Any help would be greatly appreciated, from saving as a certain datatype in
SQL to rendering the code in the Reporting Services.
Many thanks,
AndyNo. This would most likely would be a security hole if reporting services
allowed that.
However, you could build your own ASP page around reporting services that
might give you a little of the functionality you want.
--
| Thread-Topic: Report out an html string
| thread-index: AcWie3YqffCUH69lRbybl0xkS1lurw==| X-WBNR-Posting-Host: 69.160.170.174
| From: =?Utf-8?B?cGFwYXJoaW5v?= <paparhino@.discussions.microsoft.com>
| Subject: Report out an html string
| Date: Tue, 16 Aug 2005 08:59:19 -0700
| Lines: 16
| Message-ID: <035749C9-7F6C-49E4-BFCD-2DA040AC5CAE@.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.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:50470
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Is it possible to report out an html string into the rich format?
|
| --> I use an html control (RichTextBox 2.5) that allows the user to
create
| the main body of a quote in a wysiwyg environment, and that formatting is
| successfully saved as an html string to the SQL db and successfully
displayed
| when opening back up in the control.
|
| --> Will Reporting Services allow me to take that html string and display
in
| the main body of a report, with the formatting applied (i.e. bold,
bullets,
| etc.)?
|
| Any help would be greatly appreciated, from saving as a certain datatype
in
| SQL to rendering the code in the Reporting Services.
|
| Many thanks,
| Andy
|
--> I use an html control (RichTextBox 2.5) that allows the user to create
the main body of a quote in a wysiwyg environment, and that formatting is
successfully saved as an html string to the SQL db and successfully displayed
when opening back up in the control.
--> Will Reporting Services allow me to take that html string and display in
the main body of a report, with the formatting applied (i.e. bold, bullets,
etc.)?
Any help would be greatly appreciated, from saving as a certain datatype in
SQL to rendering the code in the Reporting Services.
Many thanks,
AndyNo. This would most likely would be a security hole if reporting services
allowed that.
However, you could build your own ASP page around reporting services that
might give you a little of the functionality you want.
--
| Thread-Topic: Report out an html string
| thread-index: AcWie3YqffCUH69lRbybl0xkS1lurw==| X-WBNR-Posting-Host: 69.160.170.174
| From: =?Utf-8?B?cGFwYXJoaW5v?= <paparhino@.discussions.microsoft.com>
| Subject: Report out an html string
| Date: Tue, 16 Aug 2005 08:59:19 -0700
| Lines: 16
| Message-ID: <035749C9-7F6C-49E4-BFCD-2DA040AC5CAE@.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.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:50470
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Is it possible to report out an html string into the rich format?
|
| --> I use an html control (RichTextBox 2.5) that allows the user to
create
| the main body of a quote in a wysiwyg environment, and that formatting is
| successfully saved as an html string to the SQL db and successfully
displayed
| when opening back up in the control.
|
| --> Will Reporting Services allow me to take that html string and display
in
| the main body of a report, with the formatting applied (i.e. bold,
bullets,
| etc.)?
|
| Any help would be greatly appreciated, from saving as a certain datatype
in
| SQL to rendering the code in the Reporting Services.
|
| Many thanks,
| Andy
|
Friday, March 23, 2012
Report needs to go to word
Is there any recommended way to format and export a report so that it can be modified in Word if purchasing SoftArtisans OfficeWriter is not an option?CSV or XML+XSLT if more control on the exported data is required. Of course, there is an always an option to write a custom renderer (not an easy one though).|||
Try Aspose.Words for Reporting Services, http://www.aspose.com/Products/Aspose.WordsRS/
Report needs to go to word
Is there any recommended way to format and export a report so that it can be modified in Word if purchasing SoftArtisans OfficeWriter is not an option?CSV or XML+XSLT if more control on the exported data is required. Of course, there is an always an option to write a custom renderer (not an easy one though).|||
Try Aspose.Words for Reporting Services, http://www.aspose.com/Products/Aspose.WordsRS/
Report Needs only PDF Export Format
Hi,
I have around 20 report in my testserver.In this 5 reports needs to export only in PDF format.
The Other 15 reports are needs to export in PDF,Excel,CSV and TIFF formats.
I am using Reporting Services2005 for developing reports and also using VS2005.
Any suggesstions appreciated.
Thanks,
Prabu
Those formats are all supported. Unfortunately you can't control for a particular report which export formats are supported. They are configured at the server level and apply to each report in the catalog.|||
You may be able to write some Javascript or report code to remove items from the list after the page is rendered.
|||Yes, but this won't prevent people from getting the reports via the SOAP API or putting the format directly on the URL.|||
Being able to render a report with the ability to restrict the export formats for a particular report through URL Parameterization and the WebService API would be a nice addition.
I want to be able to run the report in the report manager, see it display as HTML but only allow it to be exported as Pdf without having to code/provide my own interface on top of the report manager.
Of course, if the report formatted in the Web Browser and on the paper exactly the same that would also be nice. (If I have this wrong please let me know). The above addition would still be nice though.
|||"Of course, if the report formatted in the Web Browser and on the paper exactly the same that would also be nice."
Meant to say this... Of course, if the report formatted in the Web Browser (HTML) and on the paper (Pdf) exactly the same that would also be nice.
Report Needs only PDF Export Format
Hi,
I have around 20 report in my testserver.In this 5 reports needs to export only in PDF format.
The Other 15 reports are needs to export in PDF,Excel,CSV and TIFF formats.
I am using Reporting Services2005 for developing reports and also using VS2005.
Any suggesstions appreciated.
Thanks,
Prabu
Those formats are all supported. Unfortunately you can't control for a particular report which export formats are supported. They are configured at the server level and apply to each report in the catalog.|||
You may be able to write some Javascript or report code to remove items from the list after the page is rendered.
|||Yes, but this won't prevent people from getting the reports via the SOAP API or putting the format directly on the URL.|||Being able to render a report with the ability to restrict the export formats for a particular report through URL Parameterization and the WebService API would be a nice addition.
I want to be able to run the report in the report manager, see it display as HTML but only allow it to be exported as Pdf without having to code/provide my own interface on top of the report manager.
Of course, if the report formatted in the Web Browser and on the paper exactly the same that would also be nice. (If I have this wrong please let me know). The above addition would still be nice though.
|||"Of course, if the report formatted in the Web Browser and on the paper exactly the same that would also be nice."
Meant to say this... Of course, if the report formatted in the Web Browser (HTML) and on the paper (Pdf) exactly the same that would also be nice.
Tuesday, March 20, 2012
Report Manager/Viewer Help!!
The parameters box in the report view displays in tabular format if you have
at least two parameters. Can I change this in anyway so it displays in
columan format.
Current display
1. parameter box 2. parameter box
3. parameter box 4. parameter box
Can I change it to display like:
1. parameter box
2. parameter box
3. parameter box
4. parameter boxThe answer is no you can't! Sorry.
You could generate you're parameter asp page and run the report with
url access from a button on the asp page. That way you can be much more
fancy with the parameters.
Chris
OriginalStealth wrote:
> The parameters box in the report view displays in tabular format if
> you have at least two parameters. Can I change this in anyway so it
> displays in columan format.
> Current display
> 1. parameter box 2. parameter box
> 3. parameter box 4. parameter box
> Can I change it to display like:
> 1. parameter box
> 2. parameter box
> 3. parameter box
> 4. parameter box
at least two parameters. Can I change this in anyway so it displays in
columan format.
Current display
1. parameter box 2. parameter box
3. parameter box 4. parameter box
Can I change it to display like:
1. parameter box
2. parameter box
3. parameter box
4. parameter boxThe answer is no you can't! Sorry.
You could generate you're parameter asp page and run the report with
url access from a button on the asp page. That way you can be much more
fancy with the parameters.
Chris
OriginalStealth wrote:
> The parameters box in the report view displays in tabular format if
> you have at least two parameters. Can I change this in anyway so it
> displays in columan format.
> Current display
> 1. parameter box 2. parameter box
> 3. parameter box 4. parameter box
> Can I change it to display like:
> 1. parameter box
> 2. parameter box
> 3. parameter box
> 4. parameter box
Friday, March 9, 2012
Report looks bad on screen but prints OK
I have a report where I'm using text boxes in a grid format. When I preview
the Report the grid looks fine, but when viewed in the Report Manager, the
boxes don't line up. When I print the report or export to PDF, however, it
is OK. Has this happened to anyone else or does anyone know of any fixes for
this?The problem you are seeing is overlapping textboxes. HTML does not do
overlapping textboxes (or other items). The other formats do.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jmann" <jmann@.discussions.microsoft.com> wrote in message
news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
>I have a report where I'm using text boxes in a grid format. When I
>preview
> the Report the grid looks fine, but when viewed in the Report Manager, the
> boxes don't line up. When I print the report or export to PDF, however,
> it
> is OK. Has this happened to anyone else or does anyone know of any fixes
> for
> this?|||Bruce,
Thanks for the quick response. My text boxes butt up against one another
but do not overlap. Is there a minimum gap that needs to be between the text
boxes in order to eliminate this issue?
"Bruce L-C [MVP]" wrote:
> The problem you are seeing is overlapping textboxes. HTML does not do
> overlapping textboxes (or other items). The other formats do.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
> >I have a report where I'm using text boxes in a grid format. When I
> >preview
> > the Report the grid looks fine, but when viewed in the Report Manager, the
> > boxes don't line up. When I print the report or export to PDF, however,
> > it
> > is OK. Has this happened to anyone else or does anyone know of any fixes
> > for
> > this?
>
>|||As long as they do not overlap you should be ok.
You can check the Location and Size properties for each textbox to determine
if they overlap.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"jmann" <jmann@.discussions.microsoft.com> wrote in message
news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
> Bruce,
> Thanks for the quick response. My text boxes butt up against one another
> but do not overlap. Is there a minimum gap that needs to be between the
> text
> boxes in order to eliminate this issue?
> "Bruce L-C [MVP]" wrote:
>> The problem you are seeing is overlapping textboxes. HTML does not do
>> overlapping textboxes (or other items). The other formats do.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "jmann" <jmann@.discussions.microsoft.com> wrote in message
>> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
>> >I have a report where I'm using text boxes in a grid format. When I
>> >preview
>> > the Report the grid looks fine, but when viewed in the Report Manager,
>> > the
>> > boxes don't line up. When I print the report or export to PDF,
>> > however,
>> > it
>> > is OK. Has this happened to anyone else or does anyone know of any
>> > fixes
>> > for
>> > this?
>>|||Hi Bruce,
I have this same problem even if it is not overlapping ..
Could you check the size of the data and its space in the text box. Some of
my problem fixed by increasing the size of the text boxes. but still it is
there...
Bismi
"Bruce Johnson [MSFT]" wrote:
> As long as they do not overlap you should be ok.
> You can check the Location and Size properties for each textbox to determine
> if they overlap.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
> > Bruce,
> >
> > Thanks for the quick response. My text boxes butt up against one another
> > but do not overlap. Is there a minimum gap that needs to be between the
> > text
> > boxes in order to eliminate this issue?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> The problem you are seeing is overlapping textboxes. HTML does not do
> >> overlapping textboxes (or other items). The other formats do.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> >> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
> >> >I have a report where I'm using text boxes in a grid format. When I
> >> >preview
> >> > the Report the grid looks fine, but when viewed in the Report Manager,
> >> > the
> >> > boxes don't line up. When I print the report or export to PDF,
> >> > however,
> >> > it
> >> > is OK. Has this happened to anyone else or does anyone know of any
> >> > fixes
> >> > for
> >> > this?
> >>
> >>
> >>
>
>|||Bismi,
Could you post or send me a simple RDL that demonstrates the problem. Please
use the Northwind or AdventureWorks sample databases for the data.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bismi" <Bismi@.discussions.microsoft.com> wrote in message
news:3348EAB6-710C-4CEC-AA1B-BD63D85760D8@.microsoft.com...
> Hi Bruce,
> I have this same problem even if it is not overlapping ..
> Could you check the size of the data and its space in the text box. Some
> of
> my problem fixed by increasing the size of the text boxes. but still it is
> there...
> Bismi
> "Bruce Johnson [MSFT]" wrote:
>> As long as they do not overlap you should be ok.
>> You can check the Location and Size properties for each textbox to
>> determine
>> if they overlap.
>> --
>> Bruce Johnson [MSFT]
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "jmann" <jmann@.discussions.microsoft.com> wrote in message
>> news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
>> > Bruce,
>> >
>> > Thanks for the quick response. My text boxes butt up against one
>> > another
>> > but do not overlap. Is there a minimum gap that needs to be between
>> > the
>> > text
>> > boxes in order to eliminate this issue?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> The problem you are seeing is overlapping textboxes. HTML does not do
>> >> overlapping textboxes (or other items). The other formats do.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
>> >> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
>> >> >I have a report where I'm using text boxes in a grid format. When I
>> >> >preview
>> >> > the Report the grid looks fine, but when viewed in the Report
>> >> > Manager,
>> >> > the
>> >> > boxes don't line up. When I print the report or export to PDF,
>> >> > however,
>> >> > it
>> >> > is OK. Has this happened to anyone else or does anyone know of any
>> >> > fixes
>> >> > for
>> >> > this?
>> >>
>> >>
>> >>
>>|||Bruce, I have a sample report RDL that shows the problem.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Textbox Name="textbox10">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<Height>0.25in</Height>
<Width>1in</Width>
<Top>1.125in</Top>
<CanGrow>true</CanGrow>
<Value>Territory ID</Value>
<Left>0.25in</Left>
</Textbox>
<Textbox Name="textbox9">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<Height>0.25in</Height>
<Width>1in</Width>
<Top>0.875in</Top>
<CanGrow>true</CanGrow>
<Value>rowguid</Value>
<Left>0.25in</Left>
</Textbox>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<Height>0.25in</Height>
<Width>1in</Width>
<Top>0.625in</Top>
<CanGrow>true</CanGrow>
<Value>Date</Value>
<Left>0.25in</Left>
</Textbox>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<Height>0.25in</Height>
<Width>1in</Width>
<Top>0.375in</Top>
<CanGrow>true</CanGrow>
<Value>Customer</Value>
<Left>0.25in</Left>
</Textbox>
<Textbox Name="textbox6">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox6</rd:DefaultName>
<Height>0.25in</Height>
<Width>1in</Width>
<Top>0.125in</Top>
<CanGrow>true</CanGrow>
<Value>Account #</Value>
<Left>0.25in</Left>
</Textbox>
<Rectangle Name="rectangle1">
<ReportItems>
<Textbox Name="AccountNumber">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>SandyBrown</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>AccountNumber</rd:DefaultName>
<Height>0.25in</Height>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!AccountNumber.Value)</Value>
</Textbox>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>SandyBrown</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<Height>0.25in</Height>
<Top>0.5in</Top>
<CanGrow>true</CanGrow>
<Value>=First(Fields!ModifiedDate.Value)</Value>
</Textbox>
<Textbox Name="rowguid">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>SandyBrown</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>rowguid</rd:DefaultName>
<Height>0.25in</Height>
<Top>0.75in</Top>
<CanGrow>true</CanGrow>
<Value>=First(Fields!rowguid.Value)</Value>
</Textbox>
<Textbox Name="textbox5">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>SandyBrown</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<Height>0.25in</Height>
<Top>1in</Top>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!TerritoryID.Value)</Value>
</Textbox>
<Textbox Name="CustomerType">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>SandyBrown</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>CustomerType</rd:DefaultName>
<Height>0.25in</Height>
<Top>0.25in</Top>
<CanGrow>true</CanGrow>
<Value>=First(Fields!CustomerType.Value)</Value>
</Textbox>
</ReportItems>
<Height>1.5in</Height>
<Width>2in</Width>
<Style>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Top>0.125in</Top>
<Left>1.25in</Left>
</Rectangle>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="AdventureWorks">
<rd:DataSourceID>8e9586f6-7556-45be-a4cb-d7b6c77dd17d</rd:DataSourceID>
<DataSourceReference>AdventureWorks</DataSourceReference>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="AccountNumber">
<DataField>AccountNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="CustomerType">
<DataField>CustomerType</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ModifiedDate">
<DataField>ModifiedDate</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="rowguid">
<DataField>rowguid</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="TerritoryID">
<DataField>TerritoryID</DataField>
<rd:TypeName>System.Byte</rd:TypeName>
</Field>
<Field Name="CustomerID">
<DataField>CustomerID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="SalesPersonID">
<DataField>SalesPersonID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>AdventureWorks</DataSourceName>
<CommandText>SELECT AccountNumber, CustomerType, ModifiedDate,
rowguid, TerritoryID, CustomerID, SalesPersonID
FROM Customer</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>6f7ba402-93e3-4ff8-9d4d-8be1fa88093e</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
"Bruce Johnson [MSFT]" wrote:
> Bismi,
> Could you post or send me a simple RDL that demonstrates the problem. Please
> use the Northwind or AdventureWorks sample databases for the data.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bismi" <Bismi@.discussions.microsoft.com> wrote in message
> news:3348EAB6-710C-4CEC-AA1B-BD63D85760D8@.microsoft.com...
> > Hi Bruce,
> >
> > I have this same problem even if it is not overlapping ..
> >
> > Could you check the size of the data and its space in the text box. Some
> > of
> > my problem fixed by increasing the size of the text boxes. but still it is
> > there...
> >
> > Bismi
> >
> > "Bruce Johnson [MSFT]" wrote:
> >
> >> As long as they do not overlap you should be ok.
> >>
> >> You can check the Location and Size properties for each textbox to
> >> determine
> >> if they overlap.
> >>
> >> --
> >> Bruce Johnson [MSFT]
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> >> news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
> >> > Bruce,
> >> >
> >> > Thanks for the quick response. My text boxes butt up against one
> >> > another
> >> > but do not overlap. Is there a minimum gap that needs to be between
> >> > the
> >> > text
> >> > boxes in order to eliminate this issue?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> The problem you are seeing is overlapping textboxes. HTML does not do
> >> >> overlapping textboxes (or other items). The other formats do.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> >> >> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
> >> >> >I have a report where I'm using text boxes in a grid format. When I
> >> >> >preview
> >> >> > the Report the grid looks fine, but when viewed in the Report
> >> >> > Manager,
> >> >> > the
> >> >> > boxes don't line up. When I print the report or export to PDF,
> >> >> > however,
> >> >> > it
> >> >> > is OK. Has this happened to anyone else or does anyone know of any
> >> >> > fixes
> >> >> > for
> >> >> > this?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Hi Bruce,
Hope you can wok out with jman's rdl.
Mine is really a big one with around 35 textboxes and I was trying to fix
itin landscape ...
Thanks
Bismi
"Bruce Johnson [MSFT]" wrote:
> Bismi,
> Could you post or send me a simple RDL that demonstrates the problem. Please
> use the Northwind or AdventureWorks sample databases for the data.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bismi" <Bismi@.discussions.microsoft.com> wrote in message
> news:3348EAB6-710C-4CEC-AA1B-BD63D85760D8@.microsoft.com...
> > Hi Bruce,
> >
> > I have this same problem even if it is not overlapping ..
> >
> > Could you check the size of the data and its space in the text box. Some
> > of
> > my problem fixed by increasing the size of the text boxes. but still it is
> > there...
> >
> > Bismi
> >
> > "Bruce Johnson [MSFT]" wrote:
> >
> >> As long as they do not overlap you should be ok.
> >>
> >> You can check the Location and Size properties for each textbox to
> >> determine
> >> if they overlap.
> >>
> >> --
> >> Bruce Johnson [MSFT]
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> >> news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
> >> > Bruce,
> >> >
> >> > Thanks for the quick response. My text boxes butt up against one
> >> > another
> >> > but do not overlap. Is there a minimum gap that needs to be between
> >> > the
> >> > text
> >> > boxes in order to eliminate this issue?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> The problem you are seeing is overlapping textboxes. HTML does not do
> >> >> overlapping textboxes (or other items). The other formats do.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> >> >> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
> >> >> >I have a report where I'm using text boxes in a grid format. When I
> >> >> >preview
> >> >> > the Report the grid looks fine, but when viewed in the Report
> >> >> > Manager,
> >> >> > the
> >> >> > boxes don't line up. When I print the report or export to PDF,
> >> >> > however,
> >> >> > it
> >> >> > is OK. Has this happened to anyone else or does anyone know of any
> >> >> > fixes
> >> >> > for
> >> >> > this?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I have a similar situation. I can format my report so it looks great on the
web screen, but cuts off the lower half of my header when I print using the
print icon in SSRS 2005. I have re-formatted so the hardcopy looks great,
but then there is a blank space of and inch and 1/2 between my header and
detail. Since most of my users are view-only, I am setting it up to look
good in the web view. Now I'm trying to figure out how to disable the print
icon. (Ideally, I the hard-copy and web-view would look alike.)
Any suggestions on correcting this is aprreciated.
Thanks,
--Al
"Bismi" wrote:
> Hi Bruce,
> Hope you can wok out with jman's rdl.
> Mine is really a big one with around 35 textboxes and I was trying to fix
> itin landscape ...
>
> Thanks
> Bismi
> "Bruce Johnson [MSFT]" wrote:
> > Bismi,
> >
> > Could you post or send me a simple RDL that demonstrates the problem. Please
> > use the Northwind or AdventureWorks sample databases for the data.
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Bismi" <Bismi@.discussions.microsoft.com> wrote in message
> > news:3348EAB6-710C-4CEC-AA1B-BD63D85760D8@.microsoft.com...
> > > Hi Bruce,
> > >
> > > I have this same problem even if it is not overlapping ..
> > >
> > > Could you check the size of the data and its space in the text box. Some
> > > of
> > > my problem fixed by increasing the size of the text boxes. but still it is
> > > there...
> > >
> > > Bismi
> > >
> > > "Bruce Johnson [MSFT]" wrote:
> > >
> > >> As long as they do not overlap you should be ok.
> > >>
> > >> You can check the Location and Size properties for each textbox to
> > >> determine
> > >> if they overlap.
> > >>
> > >> --
> > >> Bruce Johnson [MSFT]
> > >> Microsoft SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> > >> news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
> > >> > Bruce,
> > >> >
> > >> > Thanks for the quick response. My text boxes butt up against one
> > >> > another
> > >> > but do not overlap. Is there a minimum gap that needs to be between
> > >> > the
> > >> > text
> > >> > boxes in order to eliminate this issue?
> > >> >
> > >> > "Bruce L-C [MVP]" wrote:
> > >> >
> > >> >> The problem you are seeing is overlapping textboxes. HTML does not do
> > >> >> overlapping textboxes (or other items). The other formats do.
> > >> >>
> > >> >>
> > >> >> --
> > >> >> Bruce Loehle-Conger
> > >> >> MVP SQL Server Reporting Services
> > >> >>
> > >> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> > >> >> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
> > >> >> >I have a report where I'm using text boxes in a grid format. When I
> > >> >> >preview
> > >> >> > the Report the grid looks fine, but when viewed in the Report
> > >> >> > Manager,
> > >> >> > the
> > >> >> > boxes don't line up. When I print the report or export to PDF,
> > >> >> > however,
> > >> >> > it
> > >> >> > is OK. Has this happened to anyone else or does anyone know of any
> > >> >> > fixes
> > >> >> > for
> > >> >> > this?
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >
the Report the grid looks fine, but when viewed in the Report Manager, the
boxes don't line up. When I print the report or export to PDF, however, it
is OK. Has this happened to anyone else or does anyone know of any fixes for
this?The problem you are seeing is overlapping textboxes. HTML does not do
overlapping textboxes (or other items). The other formats do.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jmann" <jmann@.discussions.microsoft.com> wrote in message
news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
>I have a report where I'm using text boxes in a grid format. When I
>preview
> the Report the grid looks fine, but when viewed in the Report Manager, the
> boxes don't line up. When I print the report or export to PDF, however,
> it
> is OK. Has this happened to anyone else or does anyone know of any fixes
> for
> this?|||Bruce,
Thanks for the quick response. My text boxes butt up against one another
but do not overlap. Is there a minimum gap that needs to be between the text
boxes in order to eliminate this issue?
"Bruce L-C [MVP]" wrote:
> The problem you are seeing is overlapping textboxes. HTML does not do
> overlapping textboxes (or other items). The other formats do.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
> >I have a report where I'm using text boxes in a grid format. When I
> >preview
> > the Report the grid looks fine, but when viewed in the Report Manager, the
> > boxes don't line up. When I print the report or export to PDF, however,
> > it
> > is OK. Has this happened to anyone else or does anyone know of any fixes
> > for
> > this?
>
>|||As long as they do not overlap you should be ok.
You can check the Location and Size properties for each textbox to determine
if they overlap.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"jmann" <jmann@.discussions.microsoft.com> wrote in message
news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
> Bruce,
> Thanks for the quick response. My text boxes butt up against one another
> but do not overlap. Is there a minimum gap that needs to be between the
> text
> boxes in order to eliminate this issue?
> "Bruce L-C [MVP]" wrote:
>> The problem you are seeing is overlapping textboxes. HTML does not do
>> overlapping textboxes (or other items). The other formats do.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "jmann" <jmann@.discussions.microsoft.com> wrote in message
>> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
>> >I have a report where I'm using text boxes in a grid format. When I
>> >preview
>> > the Report the grid looks fine, but when viewed in the Report Manager,
>> > the
>> > boxes don't line up. When I print the report or export to PDF,
>> > however,
>> > it
>> > is OK. Has this happened to anyone else or does anyone know of any
>> > fixes
>> > for
>> > this?
>>|||Hi Bruce,
I have this same problem even if it is not overlapping ..
Could you check the size of the data and its space in the text box. Some of
my problem fixed by increasing the size of the text boxes. but still it is
there...
Bismi
"Bruce Johnson [MSFT]" wrote:
> As long as they do not overlap you should be ok.
> You can check the Location and Size properties for each textbox to determine
> if they overlap.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
> > Bruce,
> >
> > Thanks for the quick response. My text boxes butt up against one another
> > but do not overlap. Is there a minimum gap that needs to be between the
> > text
> > boxes in order to eliminate this issue?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> The problem you are seeing is overlapping textboxes. HTML does not do
> >> overlapping textboxes (or other items). The other formats do.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> >> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
> >> >I have a report where I'm using text boxes in a grid format. When I
> >> >preview
> >> > the Report the grid looks fine, but when viewed in the Report Manager,
> >> > the
> >> > boxes don't line up. When I print the report or export to PDF,
> >> > however,
> >> > it
> >> > is OK. Has this happened to anyone else or does anyone know of any
> >> > fixes
> >> > for
> >> > this?
> >>
> >>
> >>
>
>|||Bismi,
Could you post or send me a simple RDL that demonstrates the problem. Please
use the Northwind or AdventureWorks sample databases for the data.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bismi" <Bismi@.discussions.microsoft.com> wrote in message
news:3348EAB6-710C-4CEC-AA1B-BD63D85760D8@.microsoft.com...
> Hi Bruce,
> I have this same problem even if it is not overlapping ..
> Could you check the size of the data and its space in the text box. Some
> of
> my problem fixed by increasing the size of the text boxes. but still it is
> there...
> Bismi
> "Bruce Johnson [MSFT]" wrote:
>> As long as they do not overlap you should be ok.
>> You can check the Location and Size properties for each textbox to
>> determine
>> if they overlap.
>> --
>> Bruce Johnson [MSFT]
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "jmann" <jmann@.discussions.microsoft.com> wrote in message
>> news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
>> > Bruce,
>> >
>> > Thanks for the quick response. My text boxes butt up against one
>> > another
>> > but do not overlap. Is there a minimum gap that needs to be between
>> > the
>> > text
>> > boxes in order to eliminate this issue?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> The problem you are seeing is overlapping textboxes. HTML does not do
>> >> overlapping textboxes (or other items). The other formats do.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
>> >> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
>> >> >I have a report where I'm using text boxes in a grid format. When I
>> >> >preview
>> >> > the Report the grid looks fine, but when viewed in the Report
>> >> > Manager,
>> >> > the
>> >> > boxes don't line up. When I print the report or export to PDF,
>> >> > however,
>> >> > it
>> >> > is OK. Has this happened to anyone else or does anyone know of any
>> >> > fixes
>> >> > for
>> >> > this?
>> >>
>> >>
>> >>
>>|||Bruce, I have a sample report RDL that shows the problem.
<?xml version="1.0" encoding="utf-8"?>
<Report
xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition"
xmlns:rd="">http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<RightMargin>1in</RightMargin>
<Body>
<ReportItems>
<Textbox Name="textbox10">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>5</ZIndex>
<Height>0.25in</Height>
<Width>1in</Width>
<Top>1.125in</Top>
<CanGrow>true</CanGrow>
<Value>Territory ID</Value>
<Left>0.25in</Left>
</Textbox>
<Textbox Name="textbox9">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<Height>0.25in</Height>
<Width>1in</Width>
<Top>0.875in</Top>
<CanGrow>true</CanGrow>
<Value>rowguid</Value>
<Left>0.25in</Left>
</Textbox>
<Textbox Name="textbox8">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<Height>0.25in</Height>
<Width>1in</Width>
<Top>0.625in</Top>
<CanGrow>true</CanGrow>
<Value>Date</Value>
<Left>0.25in</Left>
</Textbox>
<Textbox Name="textbox7">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<Height>0.25in</Height>
<Width>1in</Width>
<Top>0.375in</Top>
<CanGrow>true</CanGrow>
<Value>Customer</Value>
<Left>0.25in</Left>
</Textbox>
<Textbox Name="textbox6">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>LightBlue</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<rd:DefaultName>textbox6</rd:DefaultName>
<Height>0.25in</Height>
<Width>1in</Width>
<Top>0.125in</Top>
<CanGrow>true</CanGrow>
<Value>Account #</Value>
<Left>0.25in</Left>
</Textbox>
<Rectangle Name="rectangle1">
<ReportItems>
<Textbox Name="AccountNumber">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>SandyBrown</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>4</ZIndex>
<rd:DefaultName>AccountNumber</rd:DefaultName>
<Height>0.25in</Height>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!AccountNumber.Value)</Value>
</Textbox>
<Textbox Name="textbox3">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>SandyBrown</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>3</ZIndex>
<Height>0.25in</Height>
<Top>0.5in</Top>
<CanGrow>true</CanGrow>
<Value>=First(Fields!ModifiedDate.Value)</Value>
</Textbox>
<Textbox Name="rowguid">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>SandyBrown</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>2</ZIndex>
<rd:DefaultName>rowguid</rd:DefaultName>
<Height>0.25in</Height>
<Top>0.75in</Top>
<CanGrow>true</CanGrow>
<Value>=First(Fields!rowguid.Value)</Value>
</Textbox>
<Textbox Name="textbox5">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>SandyBrown</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<ZIndex>1</ZIndex>
<Height>0.25in</Height>
<Top>1in</Top>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!TerritoryID.Value)</Value>
</Textbox>
<Textbox Name="CustomerType">
<Style>
<PaddingLeft>2pt</PaddingLeft>
<BackgroundColor>SandyBrown</BackgroundColor>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingBottom>2pt</PaddingBottom>
<PaddingTop>2pt</PaddingTop>
<PaddingRight>2pt</PaddingRight>
</Style>
<rd:DefaultName>CustomerType</rd:DefaultName>
<Height>0.25in</Height>
<Top>0.25in</Top>
<CanGrow>true</CanGrow>
<Value>=First(Fields!CustomerType.Value)</Value>
</Textbox>
</ReportItems>
<Height>1.5in</Height>
<Width>2in</Width>
<Style>
<BorderColor>
<Default>White</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Top>0.125in</Top>
<Left>1.25in</Left>
</Rectangle>
</ReportItems>
<Style />
<Height>2in</Height>
</Body>
<TopMargin>1in</TopMargin>
<DataSources>
<DataSource Name="AdventureWorks">
<rd:DataSourceID>8e9586f6-7556-45be-a4cb-d7b6c77dd17d</rd:DataSourceID>
<DataSourceReference>AdventureWorks</DataSourceReference>
</DataSource>
</DataSources>
<Width>6.5in</Width>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="AccountNumber">
<DataField>AccountNumber</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="CustomerType">
<DataField>CustomerType</DataField>
<rd:TypeName>System.String</rd:TypeName>
</Field>
<Field Name="ModifiedDate">
<DataField>ModifiedDate</DataField>
<rd:TypeName>System.DateTime</rd:TypeName>
</Field>
<Field Name="rowguid">
<DataField>rowguid</DataField>
<rd:TypeName>System.Guid</rd:TypeName>
</Field>
<Field Name="TerritoryID">
<DataField>TerritoryID</DataField>
<rd:TypeName>System.Byte</rd:TypeName>
</Field>
<Field Name="CustomerID">
<DataField>CustomerID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
<Field Name="SalesPersonID">
<DataField>SalesPersonID</DataField>
<rd:TypeName>System.Int32</rd:TypeName>
</Field>
</Fields>
<Query>
<DataSourceName>AdventureWorks</DataSourceName>
<CommandText>SELECT AccountNumber, CustomerType, ModifiedDate,
rowguid, TerritoryID, CustomerID, SalesPersonID
FROM Customer</CommandText>
</Query>
</DataSet>
</DataSets>
<LeftMargin>1in</LeftMargin>
<rd:SnapToGrid>true</rd:SnapToGrid>
<rd:DrawGrid>true</rd:DrawGrid>
<rd:ReportID>6f7ba402-93e3-4ff8-9d4d-8be1fa88093e</rd:ReportID>
<BottomMargin>1in</BottomMargin>
<Language>en-US</Language>
</Report>
"Bruce Johnson [MSFT]" wrote:
> Bismi,
> Could you post or send me a simple RDL that demonstrates the problem. Please
> use the Northwind or AdventureWorks sample databases for the data.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bismi" <Bismi@.discussions.microsoft.com> wrote in message
> news:3348EAB6-710C-4CEC-AA1B-BD63D85760D8@.microsoft.com...
> > Hi Bruce,
> >
> > I have this same problem even if it is not overlapping ..
> >
> > Could you check the size of the data and its space in the text box. Some
> > of
> > my problem fixed by increasing the size of the text boxes. but still it is
> > there...
> >
> > Bismi
> >
> > "Bruce Johnson [MSFT]" wrote:
> >
> >> As long as they do not overlap you should be ok.
> >>
> >> You can check the Location and Size properties for each textbox to
> >> determine
> >> if they overlap.
> >>
> >> --
> >> Bruce Johnson [MSFT]
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> >> news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
> >> > Bruce,
> >> >
> >> > Thanks for the quick response. My text boxes butt up against one
> >> > another
> >> > but do not overlap. Is there a minimum gap that needs to be between
> >> > the
> >> > text
> >> > boxes in order to eliminate this issue?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> The problem you are seeing is overlapping textboxes. HTML does not do
> >> >> overlapping textboxes (or other items). The other formats do.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> >> >> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
> >> >> >I have a report where I'm using text boxes in a grid format. When I
> >> >> >preview
> >> >> > the Report the grid looks fine, but when viewed in the Report
> >> >> > Manager,
> >> >> > the
> >> >> > boxes don't line up. When I print the report or export to PDF,
> >> >> > however,
> >> >> > it
> >> >> > is OK. Has this happened to anyone else or does anyone know of any
> >> >> > fixes
> >> >> > for
> >> >> > this?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Hi Bruce,
Hope you can wok out with jman's rdl.
Mine is really a big one with around 35 textboxes and I was trying to fix
itin landscape ...
Thanks
Bismi
"Bruce Johnson [MSFT]" wrote:
> Bismi,
> Could you post or send me a simple RDL that demonstrates the problem. Please
> use the Northwind or AdventureWorks sample databases for the data.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Bismi" <Bismi@.discussions.microsoft.com> wrote in message
> news:3348EAB6-710C-4CEC-AA1B-BD63D85760D8@.microsoft.com...
> > Hi Bruce,
> >
> > I have this same problem even if it is not overlapping ..
> >
> > Could you check the size of the data and its space in the text box. Some
> > of
> > my problem fixed by increasing the size of the text boxes. but still it is
> > there...
> >
> > Bismi
> >
> > "Bruce Johnson [MSFT]" wrote:
> >
> >> As long as they do not overlap you should be ok.
> >>
> >> You can check the Location and Size properties for each textbox to
> >> determine
> >> if they overlap.
> >>
> >> --
> >> Bruce Johnson [MSFT]
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> >> news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
> >> > Bruce,
> >> >
> >> > Thanks for the quick response. My text boxes butt up against one
> >> > another
> >> > but do not overlap. Is there a minimum gap that needs to be between
> >> > the
> >> > text
> >> > boxes in order to eliminate this issue?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> The problem you are seeing is overlapping textboxes. HTML does not do
> >> >> overlapping textboxes (or other items). The other formats do.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> >> >> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
> >> >> >I have a report where I'm using text boxes in a grid format. When I
> >> >> >preview
> >> >> > the Report the grid looks fine, but when viewed in the Report
> >> >> > Manager,
> >> >> > the
> >> >> > boxes don't line up. When I print the report or export to PDF,
> >> >> > however,
> >> >> > it
> >> >> > is OK. Has this happened to anyone else or does anyone know of any
> >> >> > fixes
> >> >> > for
> >> >> > this?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I have a similar situation. I can format my report so it looks great on the
web screen, but cuts off the lower half of my header when I print using the
print icon in SSRS 2005. I have re-formatted so the hardcopy looks great,
but then there is a blank space of and inch and 1/2 between my header and
detail. Since most of my users are view-only, I am setting it up to look
good in the web view. Now I'm trying to figure out how to disable the print
icon. (Ideally, I the hard-copy and web-view would look alike.)
Any suggestions on correcting this is aprreciated.
Thanks,
--Al
"Bismi" wrote:
> Hi Bruce,
> Hope you can wok out with jman's rdl.
> Mine is really a big one with around 35 textboxes and I was trying to fix
> itin landscape ...
>
> Thanks
> Bismi
> "Bruce Johnson [MSFT]" wrote:
> > Bismi,
> >
> > Could you post or send me a simple RDL that demonstrates the problem. Please
> > use the Northwind or AdventureWorks sample databases for the data.
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Bismi" <Bismi@.discussions.microsoft.com> wrote in message
> > news:3348EAB6-710C-4CEC-AA1B-BD63D85760D8@.microsoft.com...
> > > Hi Bruce,
> > >
> > > I have this same problem even if it is not overlapping ..
> > >
> > > Could you check the size of the data and its space in the text box. Some
> > > of
> > > my problem fixed by increasing the size of the text boxes. but still it is
> > > there...
> > >
> > > Bismi
> > >
> > > "Bruce Johnson [MSFT]" wrote:
> > >
> > >> As long as they do not overlap you should be ok.
> > >>
> > >> You can check the Location and Size properties for each textbox to
> > >> determine
> > >> if they overlap.
> > >>
> > >> --
> > >> Bruce Johnson [MSFT]
> > >> Microsoft SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> > >> news:81F3012B-68FD-4071-8707-2220884DC927@.microsoft.com...
> > >> > Bruce,
> > >> >
> > >> > Thanks for the quick response. My text boxes butt up against one
> > >> > another
> > >> > but do not overlap. Is there a minimum gap that needs to be between
> > >> > the
> > >> > text
> > >> > boxes in order to eliminate this issue?
> > >> >
> > >> > "Bruce L-C [MVP]" wrote:
> > >> >
> > >> >> The problem you are seeing is overlapping textboxes. HTML does not do
> > >> >> overlapping textboxes (or other items). The other formats do.
> > >> >>
> > >> >>
> > >> >> --
> > >> >> Bruce Loehle-Conger
> > >> >> MVP SQL Server Reporting Services
> > >> >>
> > >> >> "jmann" <jmann@.discussions.microsoft.com> wrote in message
> > >> >> news:A26A7D4A-7C4F-4551-8723-1F2AD5188D0D@.microsoft.com...
> > >> >> >I have a report where I'm using text boxes in a grid format. When I
> > >> >> >preview
> > >> >> > the Report the grid looks fine, but when viewed in the Report
> > >> >> > Manager,
> > >> >> > the
> > >> >> > boxes don't line up. When I print the report or export to PDF,
> > >> >> > however,
> > >> >> > it
> > >> >> > is OK. Has this happened to anyone else or does anyone know of any
> > >> >> > fixes
> > >> >> > for
> > >> >> > this?
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >
Wednesday, March 7, 2012
Report Layout depending on Rendering Format
Can I vary the layout (visibility) depending on the rendering format?
Example: If 'PDF' add a title page, if 'HTML' no title page.
ThanksIs there anybody who could help me on that issue?
"Niklas" wrote:
> Can I vary the layout (visibility) depending on the rendering format?
> Example: If 'PDF' add a title page, if 'HTML' no title page.
> Thanks|||It is not possible to have a title page in one output format, but not in
other output formats.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Niklas" <Niklas@.discussions.microsoft.com> wrote in message
news:BFB7935D-892E-4A66-BBBF-1F39B21C8608@.microsoft.com...
> Is there anybody who could help me on that issue?
> "Niklas" wrote:
> > Can I vary the layout (visibility) depending on the rendering format?
> >
> > Example: If 'PDF' add a title page, if 'HTML' no title page.
> >
> > Thanks
Example: If 'PDF' add a title page, if 'HTML' no title page.
ThanksIs there anybody who could help me on that issue?
"Niklas" wrote:
> Can I vary the layout (visibility) depending on the rendering format?
> Example: If 'PDF' add a title page, if 'HTML' no title page.
> Thanks|||It is not possible to have a title page in one output format, but not in
other output formats.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Niklas" <Niklas@.discussions.microsoft.com> wrote in message
news:BFB7935D-892E-4A66-BBBF-1F39B21C8608@.microsoft.com...
> Is there anybody who could help me on that issue?
> "Niklas" wrote:
> > Can I vary the layout (visibility) depending on the rendering format?
> >
> > Example: If 'PDF' add a title page, if 'HTML' no title page.
> >
> > Thanks
Saturday, February 25, 2012
Report in Multiple Columns
I have a report, let's say it has two table columns, Name and Phone. I need to format this report so that it will print Name and Phone top to bottom, and then start at the top of a second column instead of going to another page. Do I do this using body columns, and if so, can someone explain how. I have tried by changing the column property of the body to 2, but it just moved a table column over the the other body column. Am I heading down the wrong path? I am using VS 2003 to create the report.
Thanks
Setting the column property of the body is the right way to accomplish this. However, you need to check the page width value of the report. When Body.Column is 2, the report width is divided in half, if that is smaller than the body width/table width, your table'd get splitted.Tuesday, February 21, 2012
Report Format with a Group
Is there a way to have the data rows begin on the same row as the group fields. For example if I have a student with multiple tests/scores, I want the tests/score to begin on the same line as the students name.
You could place everything on a detail row...basically no grouping level. This will display the student name as a repeating element, however.
You can then add some conditional logic to the Hidden property to only display the first occurrence of that student name.
|||Do you have an example of the logic to hide all but the first occurance? The programming side of this is a little new to me.|||Check out the HideDuplicates feature of TextBox: http://msdn2.microsoft.com/en-us/library/ms152916.aspx.
In ReportDesigner, right click on your textbox and check "Hide duplicates" in the Textbox Properties dialog.
Report Format with a Group
Is there a way to have the data rows begin on the same row as the group fields. For example if I have a student with multiple tests/scores, I want the tests/score to begin on the same line as the students name.
You could place everything on a detail row...basically no grouping level. This will display the student name as a repeating element, however.
You can then add some conditional logic to the Hidden property to only display the first occurrence of that student name.
|||Do you have an example of the logic to hide all but the first occurance? The programming side of this is a little new to me.|||Check out the HideDuplicates feature of TextBox: http://msdn2.microsoft.com/en-us/library/ms152916.aspx.
In ReportDesigner, right click on your textbox and check "Hide duplicates" in the Textbox Properties dialog.
Subscribe to:
Posts (Atom)