Report parameter - > Select All Option is not coming

Hi,
I have created a report parameter with multi-value option.
In preview mode i can see "Select All option" but once deployed i can
not see that option over web. any idea?
Regards,
SriOn May 11, 9:34 am, Sriman <Sri...@.discussions.microsoft.com> wrote:
> Hi,
> I have created a report parameter with multi-value option.
> In preview mode i can see "Select All option" but once deployed i can
> not see that option over web. any idea?
> Regards,
> Sri
Without knowing more details, it sounds like you have SQL Server 2005
SP1 installed on the production box. If so, you will want to install
SP2. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Report Page Issue?

I have a report that I developed. When I click the preview tab and see the
report it show's 1 page which is correct. When I click the "Print Preview"
button it shows the 1st page and 3 blank pages after? It also prints this
way.
Why is it doing this?
DavidMake sure that your report satisfies the condition specified below
(Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=Body.Width
Ponnurangam
"Yoshi" <yoshi@.home.com> wrote in message
news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
> I have a report that I developed. When I click the preview tab and see the
> report it show's 1 page which is correct. When I click the "Print Preview"
> button it shows the 1st page and 3 blank pages after? It also prints this
> way.
> Why is it doing this?
> David
>|||Ponnurangam,
I thought that was going to solve my problem but it didn't. Thanks for good
info. Do you have any other suggestions?
Thanks,
Davod
"Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
> Make sure that your report satisfies the condition specified below
> (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> Body.Width
> Ponnurangam
> "Yoshi" <yoshi@.home.com> wrote in message
> news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
>> I have a report that I developed. When I click the preview tab and see
>> the
>> report it show's 1 page which is correct. When I click the "Print
>> Preview"
>> button it shows the 1st page and 3 blank pages after? It also prints
>> this
>> way.
>> Why is it doing this?
>> David
>>
>|||Hi
I have also had the same problem today and have worked out that the white
background with the dots is like the canvas, is the body width and must be
smaller than Report.PageWidth - Report.LeftMargin - Report.Right Margin.
Hope you get my meaning.
Fiona
"Yoshi" wrote:
> Ponnurangam,
> I thought that was going to solve my problem but it didn't. Thanks for good
> info. Do you have any other suggestions?
> Thanks,
> Davod
> "Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
> news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
> > Make sure that your report satisfies the condition specified below
> >
> > (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=> > Body.Width
> >
> > Ponnurangam
> >
> > "Yoshi" <yoshi@.home.com> wrote in message
> > news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
> >> I have a report that I developed. When I click the preview tab and see
> >> the
> >> report it show's 1 page which is correct. When I click the "Print
> >> Preview"
> >> button it shows the 1st page and 3 blank pages after? It also prints
> >> this
> >> way.
> >>
> >> Why is it doing this?
> >>
> >> David
> >>
> >>
> >
> >
>
>|||I finally understand what everyone is saying. Thank you so much!
David P.
"Fiona Harrison" <FionaHarrison@.discussions.microsoft.com> wrote in message
news:40621EF4-C726-4859-935F-53C239980B96@.microsoft.com...
> Hi
> I have also had the same problem today and have worked out that the white
> background with the dots is like the canvas, is the body width and must be
> smaller than Report.PageWidth - Report.LeftMargin - Report.Right Margin.
> Hope you get my meaning.
> Fiona
> "Yoshi" wrote:
>> Ponnurangam,
>> I thought that was going to solve my problem but it didn't. Thanks for
>> good
>> info. Do you have any other suggestions?
>> Thanks,
>> Davod
>> "Ponnurangam" <ponnurangam@.trellisys.net> wrote in message
>> news:eYHybtQsEHA.376@.TK2MSFTNGP09.phx.gbl...
>> > Make sure that your report satisfies the condition specified below
>> >
>> > (Report.PageWidth - Report.LeftMargin - Report.Right Margin) >=>> > Body.Width
>> >
>> > Ponnurangam
>> >
>> > "Yoshi" <yoshi@.home.com> wrote in message
>> > news:#p5bc4IsEHA.2008@.TK2MSFTNGP12.phx.gbl...
>> >> I have a report that I developed. When I click the preview tab and see
>> >> the
>> >> report it show's 1 page which is correct. When I click the "Print
>> >> Preview"
>> >> button it shows the 1st page and 3 blank pages after? It also prints
>> >> this
>> >> way.
>> >>
>> >> Why is it doing this?
>> >>
>> >> David
>> >>
>> >>
>> >
>> >
>>

Report looks different in email

Hey all,

I have an issue with my report looking different in email than it does in the preview page or on the web in the online Report Manager. I've inserted a few pictures and resized them to fit inside cells on a table. They are the right size in preview, the right size on Report Manager, and the right size when exported to excel, however, when I set up a subscription and email it out they are full size as opposed to the size that they were resized to. Any ideas?

I appreciate the help,

Keith

Hi Keith,

What type of email subscription are you using? Are you sending the hyperlink to the report? Or if you're sending the report either embedded or attached, what type of rendering extension are you using (HTML, Excel, etc)?

Thanks for the info,

Jessica

|||

Hi Jessica,

The report is embedded as an email. The format is web archive.

Thank you,

Keith

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

Report Layout

Hi,

When I preview my Reporting Services Report in VS2005 the report uses 2 separate pages. Even when there is very little data on Page 1 it will display something on Page 2.

How do I get all data on the one page?

Thanks.

Hi,

I guess the reason could be that the body of the report exceeds the width of the page. Try reducing the width of the body.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||tried reducing width but no difference|||

Hi,

Could you mention the width of the page and the width of the report body. Also mention the width of the Left and Right margins of the page.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

Body:

Size: 16.75cm(w), 11.25cm(h)

Report:

InteractiveSize: 8.5in(w), 15in(h)

PageSize: 21cm, 30cm

Magins: 2.5cm, 2.5cm

|||

Hi,

Ok. So now let us calculate the width of the report.

report body widht = 8.5 in = 21.59 cm.

As I said before, the report width should be less than the width of the page

widht of the page = 16.75 cm

width of the report body = 21.59 cm

Try reducing the width of the report body.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||

didn't make a difference.

everything seems fine with the width.

Its the two textboxes located at bottom left of report that appear on the second page.

|||

Got it.

There was a ListView in behind one of the tables. Removed that and it works now.

Thanks for the help!

|||

Its about the height then. I hope you arent using a control that increases the height of the page, there by throwing the boxes onto a different page.

HTH,
Suprotim Agarwal

--
http://www.dotnetcurry.com
--

|||Ok cool..didn't see your earlier post. Glad you could solve it.

Report is not showing

hai friends
i deployed my report and in preview using vs.net i can see the report.
but once i deployed
the report is being generated screen is comming but it is not showing
report.i waited and waited still that report is being generated screen only
i am using evaluation copy is this the limitation of trial ver.we cannot see
the deployed report.
also how can i know how many days left in my evaluation version.I too have the same problem.
Though it works fine with an SQL db. The problem only occurs when using an
Oracle DB. I am using the 8i client. It works fine on my dev machine in
Visual Studio. It hangs when the report is run from a Report Services.
Its quite possible that both issues are related ?
"vishak" wrote:
> hai friends
> i deployed my report and in preview using vs.net i can see the report.
> but once i deployed
> the report is being generated screen is comming but it is not showing
> report.i waited and waited still that report is being generated screen only
> i am using evaluation copy is this the limitation of trial ver.we cannot see
> the deployed report.
> also how can i know how many days left in my evaluation version.|||Oracle is pretty unique and complicated. From the designer if you are using
the graphical query designer then OLEDB is used. If you use the generic
designer then a dotnet managed provider is used. I thought the managed
provider requires 9i or greater but I am not sure of that. When deployed it
uses the managed provider. I am guessing that this is where you problem is
coming from. To test the theory out, switch to generic query mode (the
button is to the right of the ...) and try executing from there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kamlesh Parmar" <KamleshParmar@.discussions.microsoft.com> wrote in message
news:0A3C89B2-BC98-4307-9CEB-201E8E6C7AA1@.microsoft.com...
> I too have the same problem.
> Though it works fine with an SQL db. The problem only occurs when using an
> Oracle DB. I am using the 8i client. It works fine on my dev machine in
> Visual Studio. It hangs when the report is run from a Report Services.
> Its quite possible that both issues are related ?
> "vishak" wrote:
> > hai friends
> > i deployed my report and in preview using vs.net i can see the report.
> > but once i deployed
> > the report is being generated screen is comming but it is not showing
> > report.i waited and waited still that report is being generated screen
only
> >
> > i am using evaluation copy is this the limitation of trial ver.we cannot
see
> > the deployed report.
> >
> > also how can i know how many days left in my evaluation version.

Report is Being Generated

I have a report with 12 parameters. They all have a default setting. When
I go to preview the report in the IDE it automatically starts to generate
the report with the user having to hit the view report button. Is there a
way to keep the report from auto generating without user interaction?I have a report with 12 parameters. They all have a default setting. When
I go to preview the report in the IDE it automatically starts to generate
the report without the user having to hit the view report button. Is there
a
way to keep the report from auto generating without user interaction?
"Chris" <cexley@.enableconsulting.com> wrote in message
news:Oak73TDdGHA.4900@.TK2MSFTNGP02.phx.gbl...
>I have a report with 12 parameters. They all have a default setting. When
>I go to preview the report in the IDE it automatically starts to generate
>the report with the user having to hit the view report button. Is there a
>way to keep the report from auto generating without user interaction?
>|||Unfortunately this is by design. If all the parameters have defaults it
immediately starts rendering. You need to have at least one parameter that
the user has to select.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Chris" <cexley@.enableconsulting.com> wrote in message
news:Oak73TDdGHA.4900@.TK2MSFTNGP02.phx.gbl...
>I have a report with 12 parameters. They all have a default setting. When
>I go to preview the report in the IDE it automatically starts to generate
>the report with the user having to hit the view report button. Is there a
>way to keep the report from auto generating without user interaction?
>|||Thanks for the response. I think it is bad design, and should be a property
(IsAutoGenerate comes to mind).
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:u7YDbYDdGHA.5048@.TK2MSFTNGP03.phx.gbl...
> Unfortunately this is by design. If all the parameters have defaults it
> immediately starts rendering. You need to have at least one parameter that
> the user has to select.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Chris" <cexley@.enableconsulting.com> wrote in message
> news:Oak73TDdGHA.4900@.TK2MSFTNGP02.phx.gbl...
>>I have a report with 12 parameters. They all have a default setting.
>>When I go to preview the report in the IDE it automatically starts to
>>generate the report with the user having to hit the view report button.
>>Is there a way to keep the report from auto generating without user
>>interaction?
>