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 model GetUserID() function

Guys,

What is "GetUserID()" function returns when the report server, report builder and everything is using windows authentication?

http://msdn2.microsoft.com/en-us/library/ms156292.aspx

Enkh.

Just use USERID

|||

"Just use USERID" What do you mean? USERID? Is that a global variable, windows authentication username?

Enkh.

|||

More details:

USER!USERID

|||I don't really understand it. Can you please just describe it for me or someone? Is it windows authentication username or some kind of ID?sql

Report Manager Unavailable

Installed SRS 2k on a Windows 2003 sp2 machine.
SQL 2k installed, running, Report Server databased got created.
No errors during installation but two odd issues came up.
First, we can access the reportserver page via http://localhost/reportserver
but Report Manager via http://localhost/reports errors with a 404
(with report manager color scheme). It does append the /pages/
folder.aspx to the typed address.
Event viewer does show an Report Manager Event 114 which appears to
equate to "Report Manager cannot connect to the ReportServer service"
checked and the SRS service is running.
Not sure what else to look for.
Second and maybe related: http://localhost/reportserver works but
http://servername/reportserver is not recognized - it goes to an under
construction page. The RSWebApplication.config file has
<ReportServerUrl>http://SERVERNAME/ReportServer</ReportServerUrl>
I can ping localhost, servername and IP address with success.
Have uninstalled SRS, removed databases and reinstalled same issues.
Any ideas? Thanks for your help.Just in case it helps somebody down the road...
Problem was another website on the server using port 80. Change web
site report manager was using to a different port via IIS and it
worked.
http://webservername:99/reports

Report Manager error with OK button

I'm just installed SQL Reporting Services 2000 with SP2 on a Windows Server
2003 box that is fully patched.
I have the .net framework v1.1 installed and running. My issue is that when
I try to either add roles or modify anything in the site settings the OK
button does nothing. The cancel button seems to work find. However
anywhere in any screen that you see the Ok button is there..just not
clickable.
Please help.
--
Report DeveloperThis sort of thing is usually because anonymous security has been assigned
for IIS. If that is the case then everyone is the same identity when logged
in, i.e. there is no administrator. Have you done anything like that with
your site?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:FC320F8E-DAA6-4B85-93A3-93DC3F9B6DA0@.microsoft.com...
> I'm just installed SQL Reporting Services 2000 with SP2 on a Windows
> Server
> 2003 box that is fully patched.
> I have the .net framework v1.1 installed and running. My issue is that
> when
> I try to either add roles or modify anything in the site settings the OK
> button does nothing. The cancel button seems to work find. However
> anywhere in any screen that you see the Ok button is there..just not
> clickable.
> Please help.
> --
> Report Developer|||You nailed that one. At first I did have anoynmous access to the site
enabled..However I have since disabled that...
People currently in the local administrators group have the access to create
folders etc..However people who are not only see the home folder and the My
Subscriptions..
--
Report Developer
"Bruce L-C [MVP]" wrote:
> This sort of thing is usually because anonymous security has been assigned
> for IIS. If that is the case then everyone is the same identity when logged
> in, i.e. there is no administrator. Have you done anything like that with
> your site?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Matt" <Matt@.discussions.microsoft.com> wrote in message
> news:FC320F8E-DAA6-4B85-93A3-93DC3F9B6DA0@.microsoft.com...
> > I'm just installed SQL Reporting Services 2000 with SP2 on a Windows
> > Server
> > 2003 box that is fully patched.
> >
> > I have the .net framework v1.1 installed and running. My issue is that
> > when
> > I try to either add roles or modify anything in the site settings the OK
> > button does nothing. The cancel button seems to work find. However
> > anywhere in any screen that you see the Ok button is there..just not
> > clickable.
> >
> > Please help.
> > --
> > Report Developer
>
>|||It sounds like you do not have any security setup. RS uses roll based
security. This is what I do. Create a local group on the RS machine, I call
it Reports. To this group add any individual users or domain groups etc that
you want. This group is for browse only. You can have other groups for other
rights but to start off with you want to have a group that the users can
view and run reports. Then you go to the home of report managers,
properties, click on New Role assignment, group or username put in Reports
(or whatever you called the group when you created it). Check the box that
says browse.
When you do this from home all folders underneath will inherit this role. If
you have a particular folder that you don't want to have that group to have
access then you can go to that folder and modify the permission.
Hopefully that will get you in the right direction.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Matt" <Matt@.discussions.microsoft.com> wrote in message
news:F4C40FA5-D505-4906-A519-85834D382ABF@.microsoft.com...
> You nailed that one. At first I did have anoynmous access to the site
> enabled..However I have since disabled that...
> People currently in the local administrators group have the access to
create
> folders etc..However people who are not only see the home folder and the
My
> Subscriptions..
> --
> Report Developer
>
> "Bruce L-C [MVP]" wrote:
> > This sort of thing is usually because anonymous security has been
assigned
> > for IIS. If that is the case then everyone is the same identity when
logged
> > in, i.e. there is no administrator. Have you done anything like that
with
> > your site?
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Matt" <Matt@.discussions.microsoft.com> wrote in message
> > news:FC320F8E-DAA6-4B85-93A3-93DC3F9B6DA0@.microsoft.com...
> > > I'm just installed SQL Reporting Services 2000 with SP2 on a Windows
> > > Server
> > > 2003 box that is fully patched.
> > >
> > > I have the .net framework v1.1 installed and running. My issue is
that
> > > when
> > > I try to either add roles or modify anything in the site settings the
OK
> > > button does nothing. The cancel button seems to work find. However
> > > anywhere in any screen that you see the Ok button is there..just not
> > > clickable.
> > >
> > > Please help.
> > > --
> > > Report Developer
> >
> >
> >

Report Manager default open to sub folder

Hello, when I log onto Report Manager web server using Windows Authentication, I need this user to be directed to a default sub folder.

For example: if I have folder A and sub folder 1 and 2. I need to be able to log in and be directed to sub folder 1. I was able to set up view role and access folder A. But then I need to click on folder 1 to view / create my reports.

You can specify the folder path on the URL, so if you want someone to start in Folder1, have them use this URL:

http://localhost/Reports/Pages/Folder.aspx?ItemPath=%2fFolder1

Regards.

Report Manager Config Issue

Greetings,

*Microsoft Windows Server 2003

*MSSQL Server 2005 (with reporting services installed)

I have found a configuration issue after setting up the virtual directorties for the report service and report manager.

The reporting virtual directories are assigned to a non default website and the assigned site has a defined IP Address other than the machines assigned IP.

The Reporting Services Configuration Manager Created the virtual directories properly but there seems to be a problem with it reconizing a non-default IP Address for the site the reporting services directories are created under. Because I get -

"The report server is not responding. Verify that the report server is running and can be accessed from this computer."

When I open C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\RSWebApplication.config I see the following -

<UI>

<ReportServerUrl></ReportServerURL>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>

</UI>

I tried

<ReportServerUrl>http://<Site IP Address>/</ReportServerURL>

<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>

and

<ReportServerUrl>http://<Site IP Address>/ReportServer</ReportServerURL>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

Still no luck - any suggestions?

Nevermind Figured it out -

<ReportServerUrl>http://<Site IP Address>/ReportServer</ReportServerURL>

<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

Works - just did not recycle the application pools in IIS. By the way if you are configuring the manager for a non-default IP address be carefull. For some reason the report manager does not like a <ReportServerVirtualDirectory> value if <ReportServerURL> is supplied.

Report Manager

I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
running for several months and quit running day before yesterday(?). I
have reinstalled, etc. and it appears to be running (there are no errors in
the logs). I re-deployed the reports from VS (no errors) and can see report
entries in the Report Server database. I have run rsconfigure to connect
using the SA account. The database name and folders are the defaults.
The issue: When I display Report Manager, no reports display and no errors.
Just the page header.
What can be causing this?check your security settings.
your anonymous and or integrated security are screwed up. that's why you
can't see anything at all.
"TACIR" wrote:
> I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
> running for several months and quit running day before yesterday(?). I
> have reinstalled, etc. and it appears to be running (there are no errors in
> the logs). I re-deployed the reports from VS (no errors) and can see report
> entries in the Report Server database. I have run rsconfigure to connect
> using the SA account. The database name and folders are the defaults.
> The issue: When I display Report Manager, no reports display and no errors.
> Just the page header.
> What can be causing this?
>|||I set Anonymous (& Integrated Windows) on Report Server and Reports. Then
Report Server didn't work - without Anonymous it displays the directories and
reports ok. Reports still didn't display any of the reports.
"letuce dance" wrote:
> check your security settings.
> your anonymous and or integrated security are screwed up. that's why you
> can't see anything at all.
> "TACIR" wrote:
> > I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
> > running for several months and quit running day before yesterday(?). I
> > have reinstalled, etc. and it appears to be running (there are no errors in
> > the logs). I re-deployed the reports from VS (no errors) and can see report
> > entries in the Report Server database. I have run rsconfigure to connect
> > using the SA account. The database name and folders are the defaults.
> > The issue: When I display Report Manager, no reports display and no errors.
> > Just the page header.
> > What can be causing this?
> >
> >|||It's kind of goofy.
turn anonymous off.
then go into properties tab on the report manager interface
setup a user machinename\iusr_machinename as the browser,content manager, my
reports, publisher
then you can turn anonymous back on if you want.
this way you will be able use anonymous access to your reporting server.
Not very secure because everybody will be able to access it; but if it's for
development what the heck.
like I said it's kinda goofy but if you think about what's going on and why
it makes sense once you understand things.
"TACIR" wrote:
> I set Anonymous (& Integrated Windows) on Report Server and Reports. Then
> Report Server didn't work - without Anonymous it displays the directories and
> reports ok. Reports still didn't display any of the reports.
> "letuce dance" wrote:
> > check your security settings.
> >
> > your anonymous and or integrated security are screwed up. that's why you
> > can't see anything at all.
> >
> > "TACIR" wrote:
> >
> > > I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
> > > running for several months and quit running day before yesterday(?). I
> > > have reinstalled, etc. and it appears to be running (there are no errors in
> > > the logs). I re-deployed the reports from VS (no errors) and can see report
> > > entries in the Report Server database. I have run rsconfigure to connect
> > > using the SA account. The database name and folders are the defaults.
> > > The issue: When I display Report Manager, no reports display and no errors.
> > > Just the page header.
> > > What can be causing this?
> > >
> > >|||But - how do I get a report manager interface to work with' On I-Explorer
all it shows is the Home page header. Do you know the default that is used?
Guess I should be able to do it in the Web.config file but don't know the
syntax.
Since Report Server shows the reports, Report Manager is not getting
connecting to Report Server somehow.
I have Authentication = Windows and Impersonation = False in both Web.config
files.
"Everyone" has Windows Full Control on the Reporting Services directory.
"letuce dance" wrote:
> It's kind of goofy.
> turn anonymous off.
> then go into properties tab on the report manager interface
> setup a user machinename\iusr_machinename as the browser,content manager, my
> reports, publisher
> then you can turn anonymous back on if you want.
> this way you will be able use anonymous access to your reporting server.
> Not very secure because everybody will be able to access it; but if it's for
> development what the heck.
> like I said it's kinda goofy but if you think about what's going on and why
> it makes sense once you understand things.
> "TACIR" wrote:
> > I set Anonymous (& Integrated Windows) on Report Server and Reports. Then
> > Report Server didn't work - without Anonymous it displays the directories and
> > reports ok. Reports still didn't display any of the reports.
> >
> > "letuce dance" wrote:
> >
> > > check your security settings.
> > >
> > > your anonymous and or integrated security are screwed up. that's why you
> > > can't see anything at all.
> > >
> > > "TACIR" wrote:
> > >
> > > > I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
> > > > running for several months and quit running day before yesterday(?). I
> > > > have reinstalled, etc. and it appears to be running (there are no errors in
> > > > the logs). I re-deployed the reports from VS (no errors) and can see report
> > > > entries in the Report Server database. I have run rsconfigure to connect
> > > > using the SA account. The database name and folders are the defaults.
> > > > The issue: When I display Report Manager, no reports display and no errors.
> > > > Just the page header.
> > > > What can be causing this?
> > > >
> > > >|||Well this all started with applying the latest Windows security (10/15/2005)
updates.
1. Removed the updates
2. Uninstalled/reinstalled Reporting Services - after working through
several errors finally deleted the entry from the Key table in Reporting
Services database.
3. Ran RSConfigure, RsActivate
4. Redeployed the DataSource and everything worked again.
Applied the Windows security updates again. Reporting Services broke again.
1. Deleted the entries from the Key table
2. Ran RSconfigure, RSActivate
3. Redeployed the DataSource and everything worked again.
"TACIR" wrote:
> But - how do I get a report manager interface to work with' On I-Explorer
> all it shows is the Home page header. Do you know the default that is used?
> Guess I should be able to do it in the Web.config file but don't know the
> syntax.
> Since Report Server shows the reports, Report Manager is not getting
> connecting to Report Server somehow.
> I have Authentication = Windows and Impersonation = False in both Web.config
> files.
> "Everyone" has Windows Full Control on the Reporting Services directory.
> "letuce dance" wrote:
> > It's kind of goofy.
> >
> > turn anonymous off.
> >
> > then go into properties tab on the report manager interface
> >
> > setup a user machinename\iusr_machinename as the browser,content manager, my
> > reports, publisher
> >
> > then you can turn anonymous back on if you want.
> >
> > this way you will be able use anonymous access to your reporting server.
> > Not very secure because everybody will be able to access it; but if it's for
> > development what the heck.
> >
> > like I said it's kinda goofy but if you think about what's going on and why
> > it makes sense once you understand things.
> > "TACIR" wrote:
> >
> > > I set Anonymous (& Integrated Windows) on Report Server and Reports. Then
> > > Report Server didn't work - without Anonymous it displays the directories and
> > > reports ok. Reports still didn't display any of the reports.
> > >
> > > "letuce dance" wrote:
> > >
> > > > check your security settings.
> > > >
> > > > your anonymous and or integrated security are screwed up. that's why you
> > > > can't see anything at all.
> > > >
> > > > "TACIR" wrote:
> > > >
> > > > > I have Reporting Services SP2 installed on Windows XP Pro with SP2. It was
> > > > > running for several months and quit running day before yesterday(?). I
> > > > > have reinstalled, etc. and it appears to be running (there are no errors in
> > > > > the logs). I re-deployed the reports from VS (no errors) and can see report
> > > > > entries in the Report Server database. I have run rsconfigure to connect
> > > > > using the SA account. The database name and folders are the defaults.
> > > > > The issue: When I display Report Manager, no reports display and no errors.
> > > > > Just the page header.
> > > > > What can be causing this?
> > > > >
> > > > >

Report in Report Manager (server) does not look the same way that it looks in the Visual Studio

I am using SSRS 2005 and my server is a Microsoft Windows Server 2003 Enterprise Edition Service Pack 1.

Most of the differences between VS and Report Manager are formatting differences. Borders won't show up, scrolling does not work etc. Is there something i need to upgrade on the server.

Last thing but not the least. Everytime i change something in regards to the parameters i need to delete the report from the report manager and deploy in order for the change to appear on the Report Manager. Is there a fix for this?

Could somebody please help me with these?

1. differences in rendering between design-time and run-time -- the renderer used in Report Designer is quite different than the renderer used in Report Manager. The Designer renderer is GDI-based, whereas the Report Manager renderer is HTML-based. There are many differences between these renderers, including handling of overlapping items, borders, and pagination.

2. changes to parameters made at design-time require deletion and republishing -- this is an artifact of our "server wins" philosophy. Since you can change parameter characteristics in the Report Server after a report has been published 9and therefore which may conflict with the characteristics stored in the RDL), it is indeterminate which version of the parameters a user expects to be persisted -- do you expect customizations made after publishing to dominate, or does republishing dominate? We chose to go with the server's version of parameters. Note that if we chose the other way, you would lose server-based parameter customizations everytime you republished an RDL. Admittedly it it would be nice to give users control over this, like with an RDL-based design-time option to choose which parameter collection dominates, or a publish-time option so you could choose one or the other at publish time.

|||You mean there is no way i can reproduce my params changes in the report manager with out deleting the report itself. Everytime i do that it deletes all the subscriptions on my report. Isn't there any work around?|||

Go ahead and republish the RDL, but don't bother making changes to the parameter properties in Report Designer -- just make them directly in the Report Manager or Management Studio UI.

If you need to change the # or name of the parameters, that will have to be done in Report Designer.

Report in Report Manager (server) does not look the same way that it looks in the Visual Stu

I am using SSRS 2005 and my server is a Microsoft Windows Server 2003 Enterprise Edition Service Pack 1.

Most of the differences between VS and Report Manager are formatting differences. Borders won't show up, scrolling does not work etc. Is there something i need to upgrade on the server.

Last thing but not the least. Everytime i change something in regards to the parameters i need to delete the report from the report manager and deploy in order for the change to appear on the Report Manager. Is there a fix for this?

Could somebody please help me with these?

1. differences in rendering between design-time and run-time -- the renderer used in Report Designer is quite different than the renderer used in Report Manager. The Designer renderer is GDI-based, whereas the Report Manager renderer is HTML-based. There are many differences between these renderers, including handling of overlapping items, borders, and pagination.

2. changes to parameters made at design-time require deletion and republishing -- this is an artifact of our "server wins" philosophy. Since you can change parameter characteristics in the Report Server after a report has been published 9and therefore which may conflict with the characteristics stored in the RDL), it is indeterminate which version of the parameters a user expects to be persisted -- do you expect customizations made after publishing to dominate, or does republishing dominate? We chose to go with the server's version of parameters. Note that if we chose the other way, you would lose server-based parameter customizations everytime you republished an RDL. Admittedly it it would be nice to give users control over this, like with an RDL-based design-time option to choose which parameter collection dominates, or a publish-time option so you could choose one or the other at publish time.

|||You mean there is no way i can reproduce my params changes in the report manager with out deleting the report itself. Everytime i do that it deletes all the subscriptions on my report. Isn't there any work around?|||

Go ahead and republish the RDL, but don't bother making changes to the parameter properties in Report Designer -- just make them directly in the Report Manager or Management Studio UI.

If you need to change the # or name of the parameters, that will have to be done in Report Designer.

Report Generator in VS.NET

We have a SQL server 2000 w/ Reporting services installed. I have a laptop
I use for development running Windows XP, w/ VS.Net enterprise installed.
[I know if you intall Reporting services on a Sql server with VS.net
installed you get the Business Intelligent Project types and, therefore,
have access to the Report generator. ]
My question is : Do I have to go to the Sql server and use VS.Net on the
server to use the report generator or is there some way to install and use
report generator from my laptop?
ThxThat's normal. Reporting Services is actually implemented as a Web Service
you can drive from anywhere.
Just run the RS installer on your laptop to get the VS.Net addin, and then
specify the Url of your server.
Or you can use the web front-end by pointing your browser at
http://<server>/Reports
brian
"adrian m" <nospam@.nospam.com> wrote in message
news:e8Q2ZkrbEHA.904@.TK2MSFTNGP09.phx.gbl...
> We have a SQL server 2000 w/ Reporting services installed. I have a
laptop
> I use for development running Windows XP, w/ VS.Net enterprise installed.
> [I know if you intall Reporting services on a Sql server with VS.net
> installed you get the Business Intelligent Project types and, therefore,
> have access to the Report generator. ]
> My question is : Do I have to go to the Sql server and use VS.Net on the
> server to use the report generator or is there some way to install and use
> report generator from my laptop?
> Thx
>