Hi,
Is it possible to have report parameter of string type displayed as a text
box instead of dropdown ? This will enable the user to type-in the parameter
value rather than choosing one. I have one more question. Is report
parameter of type String always displayed as a drop down list ? Can I have
checkboxes as report parameters ? These question are very basic. Iam new to
SSRS. Please provide help.
Thanks,
RKOn Oct 17, 5:48 am, "S V Ramakrishna"
<ramakrishna.seeth...@.translogicsys.com> wrote:
> Hi,
> Is it possible to have report parameter of string type displayed as a text
> box instead of dropdown ? This will enable the user to type-in the parameter
> value rather than choosing one. I have one more question. Is report
> parameter of type String always displayed as a drop down list ? Can I have
> checkboxes as report parameters ? These question are very basic. Iam new to
> SSRS. Please provide help.
> Thanks,
> RK
Regardless of datatype, anytime you provide a choice of available
values, whether non-queried or queried, you'll be presented with the
drop down. The drop down is the only option for displaying available
values. The only time you'll see checkboxes is if you select the
Multi-Value option and even then the checkboxes appear by way of the
drop down.
If you want your users to enter the parameter value in a text box, you
will not be able to offer available values. There is a slight caveat
to my last statement. You can use the prompt to suggest potential
values to be entered into the text box. For example, you could have
your prompt read, "Enter one of the following values: Yes; No; Maybe."
HTH
Showing posts with label text. Show all posts
Showing posts with label text. Show all posts
Friday, March 30, 2012
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 on successful sql logins
--____SBTWNWYYMXLIXECXQHOY____
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Looking for how to create a report for sql'05 to see who's logging in = succesfully and then failed user logins as well perhaps on a second = report.
Is there a way to capture logins historically with just sql server? How = do you set this up? Could someone point me in the right direction or, = possibly an example?
Thanks
--____SBTWNWYYMXLIXECXQHOY____
Content-Type: multipart/related; boundary="____NDKLCVQYBPHYCAFJJABM____"
--____NDKLCVQYBPHYCAFJJABM____
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
&
Looking for how to create a report for sql'05 to see who's logging in = succesfully and then failed user logins as well perhaps on a second = report.
Is there a way to capture logins historically with just sql server?&nb= sp; How do you set this up? Could someone point me in the right = direction or, possibly an example?
Thanks
--____NDKLCVQYBPHYCAFJJABM____--
--____SBTWNWYYMXLIXECXQHOY____--Go to Server Properties, Security tab, Login auditing. Login information
will be written to SQL Server Log and Windows Event Viewer.
Ben Nevarez, MCDBA, OCP
Database Administrator
"James Wuerflein" wrote:
> Looking for how to create a report for sql'05 to see who's logging in succesfully and then failed user logins as well perhaps on a second report.
> Is there a way to capture logins historically with just sql server? How do you set this up? Could someone point me in the right direction or, possibly an example?
> Thanks
>|||--____OGQMDAXZFWTVEKBBRRSF____
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
What an easy way to take that an create a report forthose logins that I =could give to management?
Thanks
>> Ben Nevarez<BenNevarez@.discussions.microsoft.com> 05/03 6:37 PM >>
Go to Server Properties, Security tab, Login auditing. Login information=20=
will be written to SQL Server Log and Windows Event Viewer.
Ben Nevarez, MCDBA, OCP
Database Administrator
"James Wuerflein" wrote:
> Looking for how to create a report for sql'05 to see who's logging in =succesfully and then failed user logins as well perhaps on a second =report. > > Is there a way to capture logins historically with just sql server? How =do you set this up? Could someone point me in the right direction or, =possibly an example?
> > Thanks
>
--____OGQMDAXZFWTVEKBBRRSF____
Content-Type: multipart/related; boundary="____CECFBOUWBBNUBTTKVERM____"
--____CECFBOUWBBNUBTTKVERM____
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
&
What an easy way to take that an create a report forthose logins that =I could give to management?
Thanks> Ben Nevarez 05/03 6:37 PM >>
Go to Server Properties, Security tab, =Login auditing. Login information will be written to SQL Server Log =and Windows Event Viewer.Ben Nevarez, MCDBA, OCPDatabase =Administrator"James Wuerflein" wrote:> Looking for =how to create a report for sql'05 to see who's logging in succesfully and =then failed user logins as well perhaps on a second report. > => Is there a way to capture logins historically with just sql =server? How do you set this up? Could someone point me in the =right direction or, possibly an example?> > Thanks> =
--____CECFBOUWBBNUBTTKVERM____--
--____OGQMDAXZFWTVEKBBRRSF____--
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Looking for how to create a report for sql'05 to see who's logging in = succesfully and then failed user logins as well perhaps on a second = report.
Is there a way to capture logins historically with just sql server? How = do you set this up? Could someone point me in the right direction or, = possibly an example?
Thanks
--____SBTWNWYYMXLIXECXQHOY____
Content-Type: multipart/related; boundary="____NDKLCVQYBPHYCAFJJABM____"
--____NDKLCVQYBPHYCAFJJABM____
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
&
Looking for how to create a report for sql'05 to see who's logging in = succesfully and then failed user logins as well perhaps on a second = report.
Is there a way to capture logins historically with just sql server?&nb= sp; How do you set this up? Could someone point me in the right = direction or, possibly an example?
Thanks
--____NDKLCVQYBPHYCAFJJABM____--
--____SBTWNWYYMXLIXECXQHOY____--Go to Server Properties, Security tab, Login auditing. Login information
will be written to SQL Server Log and Windows Event Viewer.
Ben Nevarez, MCDBA, OCP
Database Administrator
"James Wuerflein" wrote:
> Looking for how to create a report for sql'05 to see who's logging in succesfully and then failed user logins as well perhaps on a second report.
> Is there a way to capture logins historically with just sql server? How do you set this up? Could someone point me in the right direction or, possibly an example?
> Thanks
>|||--____OGQMDAXZFWTVEKBBRRSF____
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
What an easy way to take that an create a report forthose logins that I =could give to management?
Thanks
>> Ben Nevarez<BenNevarez@.discussions.microsoft.com> 05/03 6:37 PM >>
Go to Server Properties, Security tab, Login auditing. Login information=20=
will be written to SQL Server Log and Windows Event Viewer.
Ben Nevarez, MCDBA, OCP
Database Administrator
"James Wuerflein" wrote:
> Looking for how to create a report for sql'05 to see who's logging in =succesfully and then failed user logins as well perhaps on a second =report. > > Is there a way to capture logins historically with just sql server? How =do you set this up? Could someone point me in the right direction or, =possibly an example?
> > Thanks
>
--____OGQMDAXZFWTVEKBBRRSF____
Content-Type: multipart/related; boundary="____CECFBOUWBBNUBTTKVERM____"
--____CECFBOUWBBNUBTTKVERM____
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
&
What an easy way to take that an create a report forthose logins that =I could give to management?
Thanks> Ben Nevarez 05/03 6:37 PM >>
Go to Server Properties, Security tab, =Login auditing. Login information will be written to SQL Server Log =and Windows Event Viewer.Ben Nevarez, MCDBA, OCPDatabase =Administrator"James Wuerflein" wrote:> Looking for =how to create a report for sql'05 to see who's logging in succesfully and =then failed user logins as well perhaps on a second report. > => Is there a way to capture logins historically with just sql =server? How do you set this up? Could someone point me in the =right direction or, possibly an example?> > Thanks> =
--____CECFBOUWBBNUBTTKVERM____--
--____OGQMDAXZFWTVEKBBRRSF____--
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
I have a page with a List of about 12 fields with text labels.
Something like this:
Label1
Field1
Label2
Field2
Label3
Field3
Label4
Field4
IS there any way to scale this so that if, for example, Label3/Field3 are
empty, I can move Label4/Field up? Right now, it leaves a big blank line in
the report.
Any help on this would be greatly appreciated!
Chris KyleTry adding this in the visibility / hidden property, for each row pair
=IIF(IsNothing(Field!Field1.Value), True, False)
Kaisa M. Lindahl Lervik
"Chris Kye" <pixelboy@.yourdomain.com> wrote in message
news:2239d6e237054d6ea161b45bc23e60aa@.ureader.com...
>I have a page with a List of about 12 fields with text labels.
> Something like this:
> Label1
> Field1
> Label2
> Field2
> Label3
> Field3
> Label4
> Field4
> IS there any way to scale this so that if, for example, Label3/Field3 are
> empty, I can move Label4/Field up? Right now, it leaves a big blank line
> in
> the report.
> Any help on this would be greatly appreciated!
> Chris Kyle
Something like this:
Label1
Field1
Label2
Field2
Label3
Field3
Label4
Field4
IS there any way to scale this so that if, for example, Label3/Field3 are
empty, I can move Label4/Field up? Right now, it leaves a big blank line in
the report.
Any help on this would be greatly appreciated!
Chris KyleTry adding this in the visibility / hidden property, for each row pair
=IIF(IsNothing(Field!Field1.Value), True, False)
Kaisa M. Lindahl Lervik
"Chris Kye" <pixelboy@.yourdomain.com> wrote in message
news:2239d6e237054d6ea161b45bc23e60aa@.ureader.com...
>I have a page with a List of about 12 fields with text labels.
> Something like this:
> Label1
> Field1
> Label2
> Field2
> Label3
> Field3
> Label4
> Field4
> IS there any way to scale this so that if, for example, Label3/Field3 are
> empty, I can move Label4/Field up? Right now, it leaves a big blank line
> in
> the report.
> Any help on this would be greatly appreciated!
> Chris Kyle
Report item not linked to a dataset
I have a need to add a text box to a report. The text box will have an
expression that I need to have that captues the value of a field from a
second data set associated with the report. I add a text box but in the edit
expresssion process I can't access any fields (from any data set) and i get
the message Report item not linked to a dataset. I'm not trying to add a new
table or anything like that. I just want to be able to grab that field value
and disply.
--
Thanks, JimOn Sep 21, 11:38 am, Jim B <J...@.lightning.com> wrote:
> I have a need to add a text box to a report. The text box will have an
> expression that I need to have that captues the value of a field from a
> second data set associated with the report. I add a text box but in the edit
> expresssion process I can't access any fields (from any data set) and i get
> the message Report item not linked to a dataset. I'm not trying to add a new
> table or anything like that. I just want to be able to grab that field value
> and disply.
> --
> Thanks, Jim
If I'm understanding you correctly, you should be able to reference a
dataset via an aggregate expression. Something like this should work.
=Max(Fields!SomeFieldName.Value, "SomeDatasetName")
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||That's exactly what I needed to know. Thanks for your response to my question.
--
Thanks, Jim
"EMartinez" wrote:
> On Sep 21, 11:38 am, Jim B <J...@.lightning.com> wrote:
> > I have a need to add a text box to a report. The text box will have an
> > expression that I need to have that captues the value of a field from a
> > second data set associated with the report. I add a text box but in the edit
> > expresssion process I can't access any fields (from any data set) and i get
> > the message Report item not linked to a dataset. I'm not trying to add a new
> > table or anything like that. I just want to be able to grab that field value
> > and disply.
> > --
> > Thanks, Jim
>
> If I'm understanding you correctly, you should be able to reference a
> dataset via an aggregate expression. Something like this should work.
> =Max(Fields!SomeFieldName.Value, "SomeDatasetName")
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Sep 23, 9:20 am, Jim B <J...@.lightning.com> wrote:
> That's exactly what I needed to know. Thanks for your response to my question.
> --
> Thanks, Jim
> "EMartinez" wrote:
> > On Sep 21, 11:38 am, Jim B <J...@.lightning.com> wrote:
> > > I have a need to add a text box to a report. The text box will have an
> > > expression that I need to have that captues the value of a field from a
> > > second data set associated with the report. I add a text box but in the edit
> > > expresssion process I can't access any fields (from any data set) and i get
> > > the message Report item not linked to a dataset. I'm not trying to add a new
> > > table or anything like that. I just want to be able to grab that field value
> > > and disply.
> > > --
> > > Thanks, Jim
> > If I'm understanding you correctly, you should be able to reference a
> > dataset via an aggregate expression. Something like this should work.
> > =Max(Fields!SomeFieldName.Value, "SomeDatasetName")
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Glad I could help.
Regards,
Enrique Martinez
Sr. Software Consultant
expression that I need to have that captues the value of a field from a
second data set associated with the report. I add a text box but in the edit
expresssion process I can't access any fields (from any data set) and i get
the message Report item not linked to a dataset. I'm not trying to add a new
table or anything like that. I just want to be able to grab that field value
and disply.
--
Thanks, JimOn Sep 21, 11:38 am, Jim B <J...@.lightning.com> wrote:
> I have a need to add a text box to a report. The text box will have an
> expression that I need to have that captues the value of a field from a
> second data set associated with the report. I add a text box but in the edit
> expresssion process I can't access any fields (from any data set) and i get
> the message Report item not linked to a dataset. I'm not trying to add a new
> table or anything like that. I just want to be able to grab that field value
> and disply.
> --
> Thanks, Jim
If I'm understanding you correctly, you should be able to reference a
dataset via an aggregate expression. Something like this should work.
=Max(Fields!SomeFieldName.Value, "SomeDatasetName")
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||That's exactly what I needed to know. Thanks for your response to my question.
--
Thanks, Jim
"EMartinez" wrote:
> On Sep 21, 11:38 am, Jim B <J...@.lightning.com> wrote:
> > I have a need to add a text box to a report. The text box will have an
> > expression that I need to have that captues the value of a field from a
> > second data set associated with the report. I add a text box but in the edit
> > expresssion process I can't access any fields (from any data set) and i get
> > the message Report item not linked to a dataset. I'm not trying to add a new
> > table or anything like that. I just want to be able to grab that field value
> > and disply.
> > --
> > Thanks, Jim
>
> If I'm understanding you correctly, you should be able to reference a
> dataset via an aggregate expression. Something like this should work.
> =Max(Fields!SomeFieldName.Value, "SomeDatasetName")
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Sep 23, 9:20 am, Jim B <J...@.lightning.com> wrote:
> That's exactly what I needed to know. Thanks for your response to my question.
> --
> Thanks, Jim
> "EMartinez" wrote:
> > On Sep 21, 11:38 am, Jim B <J...@.lightning.com> wrote:
> > > I have a need to add a text box to a report. The text box will have an
> > > expression that I need to have that captues the value of a field from a
> > > second data set associated with the report. I add a text box but in the edit
> > > expresssion process I can't access any fields (from any data set) and i get
> > > the message Report item not linked to a dataset. I'm not trying to add a new
> > > table or anything like that. I just want to be able to grab that field value
> > > and disply.
> > > --
> > > Thanks, Jim
> > If I'm understanding you correctly, you should be able to reference a
> > dataset via an aggregate expression. Something like this should work.
> > =Max(Fields!SomeFieldName.Value, "SomeDatasetName")
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Glad I could help.
Regards,
Enrique Martinez
Sr. Software Consultant
Saturday, February 25, 2012
Report header when using columns
Hi,
I am designing a report with two columns, and I'm trying to add a header
only on the first page of the report. I've added a text box in the body of
the report, but my problem is that this textbox can't be larger than the
column size.
Is there any way to put this header on the whole width of the report ?
Thanks in advance.
--
Florent MERYHi,
No need to add text boxes. Just follow the below steps
Right click on the table-> select properties->General Tab-> Uncheck the
"Repeat header row on each page"..
Regards,
Sriman.
"Florent" wrote:
> Hi,
> I am designing a report with two columns, and I'm trying to add a header
> only on the first page of the report. I've added a text box in the body of
> the report, but my problem is that this textbox can't be larger than the
> column size.
> Is there any way to put this header on the whole width of the report ?
> Thanks in advance.
> --
> Florent MERY|||Thank you for your answer, but it's not exactly what I'm trying to do. As I'm
using 2 columns in my report, the table headers will only appear on the top
of the first column.
What I would like to do is to have in fact a kind of title zone for my
report, only for the first page.
If I use the Page header, with a conditional visibility, I always get a
blanck zone at the top of every page, even when the header is not visible.
And if I use the table header rows, it only appear on the first column of
the page, and it does not use the whole width of the page.
Any workaround for my problem ?
Thanks in advance...
--
Florent MERY
"Sriman" wrote:
> Hi,
> No need to add text boxes. Just follow the below steps
> Right click on the table-> select properties->General Tab-> Uncheck the
> "Repeat header row on each page"..
> Regards,
> Sriman.
> "Florent" wrote:
> > Hi,
> >
> > I am designing a report with two columns, and I'm trying to add a header
> > only on the first page of the report. I've added a text box in the body of
> > the report, but my problem is that this textbox can't be larger than the
> > column size.
> >
> > Is there any way to put this header on the whole width of the report ?
> >
> > Thanks in advance.
> >
> > --
> > Florent MERY
I am designing a report with two columns, and I'm trying to add a header
only on the first page of the report. I've added a text box in the body of
the report, but my problem is that this textbox can't be larger than the
column size.
Is there any way to put this header on the whole width of the report ?
Thanks in advance.
--
Florent MERYHi,
No need to add text boxes. Just follow the below steps
Right click on the table-> select properties->General Tab-> Uncheck the
"Repeat header row on each page"..
Regards,
Sriman.
"Florent" wrote:
> Hi,
> I am designing a report with two columns, and I'm trying to add a header
> only on the first page of the report. I've added a text box in the body of
> the report, but my problem is that this textbox can't be larger than the
> column size.
> Is there any way to put this header on the whole width of the report ?
> Thanks in advance.
> --
> Florent MERY|||Thank you for your answer, but it's not exactly what I'm trying to do. As I'm
using 2 columns in my report, the table headers will only appear on the top
of the first column.
What I would like to do is to have in fact a kind of title zone for my
report, only for the first page.
If I use the Page header, with a conditional visibility, I always get a
blanck zone at the top of every page, even when the header is not visible.
And if I use the table header rows, it only appear on the first column of
the page, and it does not use the whole width of the page.
Any workaround for my problem ?
Thanks in advance...
--
Florent MERY
"Sriman" wrote:
> Hi,
> No need to add text boxes. Just follow the below steps
> Right click on the table-> select properties->General Tab-> Uncheck the
> "Repeat header row on each page"..
> Regards,
> Sriman.
> "Florent" wrote:
> > Hi,
> >
> > I am designing a report with two columns, and I'm trying to add a header
> > only on the first page of the report. I've added a text box in the body of
> > the report, but my problem is that this textbox can't be larger than the
> > column size.
> >
> > Is there any way to put this header on the whole width of the report ?
> >
> > Thanks in advance.
> >
> > --
> > Florent MERY
Subscribe to:
Posts (Atom)