Report page size when printing

I use SQL Server 2005 Reporting Services. The clients use Internet Explorer 6 or higher on Windows XP.

When i access a report by ReportServer URL, the report viewer show me this report with my default parameters selected. If i choose "PDF" format and i click "Export", my report is perfect on printing.

My problem is the button print of the ReportViewer page, if i click on it, the printed report is very too large (on two page). I presume that some settings are wrong in my report, the maximum width of the content never exceed 31 cm, i want the report in LandScape.

There are my settings for this report :

InteractiveSize : 11in; 8,5in

Margins : 1,5cm; 1,5cm; 1,5cm; 1,5cm

PageSize : 35cm; 25cm

Where's the problem when i use the print button directly into the ReportViewer ? Internet Explorer ? The printer drivers or settings ? The report settings ?

Sorry for my english...

What happens when you set InteractiveWidth to 35cm and InteractiveHeight to 25cm? InteractiveHeight/Width are used to generate soft page breaks with HTML and Excel formats.|||Same problem, i have deleted the report before deploying again with the updated report (InteractiveWidth to 35cm and InteractiveHeight to 25cm) and the report stay on 2 page in width.|||At what width does the report break across pages? This usually happens when the report body width exceeds the page width minus (left and right margins).|||ok i will change the width and height of the page. It seem's to be 27.5 X 21.5 cm, so i will reduce the width and the content will fit on one page. Thanks.

Report not rendering properly when passing prms in url

This has probably been answered before, but i cannot find the
solution.. I need to pass prms to a packlist report to pull the correct
packlist once a user is finished with a shipment in our logistics
software. Whenever i pass in the prms the report comes up, but there
are no graphics. I am also using neodynamics barcoding software and
those do not appear either.
Here is the url w/prms i am using :
http://sts-sqlsrv/ReportServer?/SCOUT+Reports/LOGISTICS/rptPacklist2&rc:Command=Render&rc:Format=HTML4.0&rc:Toolbar=True&PacklistId=060421001
Any ideas?
Thanks
JayDialDid you Deploy your graphics to the server as well?
Richard.
"JayDial" <JayDial@.gmail.com> wrote in message
news:1145889309.197930.223470@.e56g2000cwe.googlegroups.com...
> This has probably been answered before, but i cannot find the
> solution.. I need to pass prms to a packlist report to pull the correct
> packlist once a user is finished with a shipment in our logistics
> software. Whenever i pass in the prms the report comes up, but there
> are no graphics. I am also using neodynamics barcoding software and
> those do not appear either.
> Here is the url w/prms i am using :
> http://sts-sqlsrv/ReportServer?/SCOUT+Reports/LOGISTICS/rptPacklist2&rc:Command=Render&rc:Format=HTML4.0&rc:Toolbar=True&PacklistId=060421001
> Any ideas?
> Thanks
> JayDial
>|||The graphics display fine if i browse to the actual report, but not if
i provide the prms in the url.|||Next question is: does the report return a result set with the parms you've
specified? I'm thinking that if no rows are returned then your graphics may
not show up either. Does this work when you preview the report using those
parms?
Richard.
"JayDial" <JayDial@.gmail.com> wrote in message
news:1145892373.787538.120860@.y43g2000cwc.googlegroups.com...
> The graphics display fine if i browse to the actual report, but not if
> i provide the prms in the url.
>|||Hrmm, that is the strangest thing. Today i was getting a couple screen
shots for you, but now the graphics are showing up. I thought maybe it
was a problem with the original url I was using, but when i copy and
paste from the original post everything is to be expected! Thanks for
your help!
-JayDial

Report Navigation and jump url

Hi all,

I have got a report with external hyperlink.

When I put this link in TextBox properties >> Navigation >> Jump URL of my gridView : http://www.micheldegremont.com it works.

However, if I put "http://www.micheldegremont.com?id=" + Fields!ID.Value it doesn't work. I haven't not link in my report.

And if I put http://www.micheldegremont.com?id=Fields!ID.Value my report create a hyperlink to http://www.micheldegremont.com?id=Fields!ID.Value and no http://www.micheldegremont.com?id=1

Thanks for you help.

Degremont wrote:

However, if I put "http://www.micheldegremont.com?id=" + Fields!ID.Value it doesn't work. I haven't not link in my report.

Instead use "http://www.micheldegremont.com?id=" & Fields!ID.Value

HTH|||

Now it works with ="http://www.micheldegremont.com?id=" & Fields!ID.Value but only on 1 report.

Howerver, I have the same XML

Report 1 (it's work)

<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="AddressID">
<rd:DefaultName>AddressID</rd:DefaultName>
<ZIndex>1</ZIndex>
<Action>
<Hyperlink>="http://www.micheldegremont.com?id=" &amp; Fields!ID.Value</Hyperlink>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!AddressID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>

But on report 2 , it doesn't work

<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="noteFraisID">
<rd:DefaultName>noteFraisID</rd:DefaultName>
<ZIndex>7</ZIndex>
<Action>
<Hyperlink>="http://www.micheldegremont.com?id=" &amp; Fields!ID.Value</Hyperlink>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!noteFraisID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
....

sql

Report Manager: SHow only reports, not the stuff above?

Is it possible to add parameters to the URL for the Report Manager, to get
rid of the stuff over the available reports? Like what shows up in the RS
Web Part "Report Explorer". We're trying to view RS reports through a
HummingBird portal, and are trying out different ways of viewing RS reports.
All help appreciated!
Kaisa M. Lindahl"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:OwfmzIqwFHA.720@.TK2MSFTNGP10.phx.gbl...
> Is it possible to add parameters to the URL for the Report Manager, to get
> rid of the stuff over the available reports? Like what shows up in the RS
> Web Part "Report Explorer". We're trying to view RS reports through a
> HummingBird portal, and are trying out different ways of viewing RS
> reports.
> All help appreciated!
> Kaisa M. Lindahl
I figured it out. With Reporting Services sp 2, there's a new ListMode:
WebPartList.
So if you add ViewMode=WebPartList to your URL, you will get a nice list,
web part style.
http://localhost/Reports/Pages/Folder.aspx?ItemPath=/&viewmode=webpartlist
This means that all reports are opened in a new window, without the
navigation pane on top. Could be usefull for some scenarios.
Kaisa M. Lindahl

Report Manager help URL set to http, not https

We have an SSL cert in place on our production platform and for some reason
the help link in report manager is calling the help page through http, not
https and subsequently the call fails.
Does anyone know if it is possible to change the link to https somewhere in
the config files?
All other links work OK.
Thanks
DarrenHi Darren,
I have the same problem...
Did you manage to find a resolution?
Cant seem to find one on the newsgroups.
Many Thanks
Alex Young
"Darren" wrote:
> We have an SSL cert in place on our production platform and for some reason
> the help link in report manager is calling the help page through http, not
> https and subsequently the call fails.
> Does anyone know if it is possible to change the link to https somewhere in
> the config files?
> All other links work OK.
> Thanks
> Darren|||This is a known issue in RS. There is unfortunately no work around.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Alex Young" <Alex Young@.discussions.microsoft.com> wrote in message
news:86358E44-48A6-4549-B059-1EE867CD647B@.microsoft.com...
> Hi Darren,
> I have the same problem...
> Did you manage to find a resolution?
> Cant seem to find one on the newsgroups.
> Many Thanks
> Alex Young
> "Darren" wrote:
>> We have an SSL cert in place on our production platform and for some
>> reason
>> the help link in report manager is calling the help page through http,
>> not
>> https and subsequently the call fails.
>> Does anyone know if it is possible to change the link to https somewhere
>> in
>> the config files?
>> All other links work OK.
>> Thanks
>> Darren|||Thanks for this. In the end I got the firewall config changed to allow http
as well as https.
Darren
"Daniel Reib [MSFT]" wrote:
> This is a known issue in RS. There is unfortunately no work around.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Alex Young" <Alex Young@.discussions.microsoft.com> wrote in message
> news:86358E44-48A6-4549-B059-1EE867CD647B@.microsoft.com...
> > Hi Darren,
> >
> > I have the same problem...
> >
> > Did you manage to find a resolution?
> >
> > Cant seem to find one on the newsgroups.
> >
> > Many Thanks
> >
> > Alex Young
> >
> > "Darren" wrote:
> >
> >> We have an SSL cert in place on our production platform and for some
> >> reason
> >> the help link in report manager is calling the help page through http,
> >> not
> >> https and subsequently the call fails.
> >>
> >> Does anyone know if it is possible to change the link to https somewhere
> >> in
> >> the config files?
> >> All other links work OK.
> >>
> >> Thanks
> >> Darren
>
>|||Is this a known issue only with the "Help" link OR also with links such as
"Home", "My Subscriptions" etc in Report Manager?
"Daniel Reib [MSFT]" wrote:
> This is a known issue in RS. There is unfortunately no work around.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Alex Young" <Alex Young@.discussions.microsoft.com> wrote in message
> news:86358E44-48A6-4549-B059-1EE867CD647B@.microsoft.com...
> > Hi Darren,
> >
> > I have the same problem...
> >
> > Did you manage to find a resolution?
> >
> > Cant seem to find one on the newsgroups.
> >
> > Many Thanks
> >
> > Alex Young
> >
> > "Darren" wrote:
> >
> >> We have an SSL cert in place on our production platform and for some
> >> reason
> >> the help link in report manager is calling the help page through http,
> >> not
> >> https and subsequently the call fails.
> >>
> >> Does anyone know if it is possible to change the link to https somewhere
> >> in
> >> the config files?
> >> All other links work OK.
> >>
> >> Thanks
> >> Darren
>
>|||Just with the help link.
-Mo|||Alex and Darren,
Sorry to disagree with Daniel Reib. There is a work around.
1) Access the IIS Manager
2) Go to the Default Web Site. Find the 'Reports' virtual directory and
expand
3) Locate the folders that have a sub folder â'helpâ'.
4) Right click and select properties
5) Go to the Directory Security tab, click the â'Editâ' button under Secure
communications
6) Uncheck the checkbox for â'Require secure channel (SSL)â'.
7) All the sub folders with that contain a help file donâ't require
SSL â'deâ', â'enâ', â'esâ', â'frâ', â'itâ', â'jaâ', â'koâ'.
Your Help link should work. The Help files really don't require SSL anyway.
Cheers!