Reporting services 2005 - rezising the legend size

Hi all,I have a report with a chart.the chart has a legend.The problem is that the number of categoried the legend contains grows in time.

How to i do i make the legend rezing dynamicly so that the text doesnt go over the other?

You could consider a "table" legend layout which may be able to better accomodate the legend items.

Other than that, you could look into building a custom legend by using a table data region instead of using the built-in legend (see this article for more details: http://blogs.msdn.com/bwelcker/archive/2005/05/20/420349.aspx)

-- Robert

Reporting Services 2000 SP2 fails

I have installed SP2 successfully a number of times before, but always where the Report Server and the Report Server databases were on the same box. This is the first time trying to install the Service Pack where the Report Server is on server X and the databases are on server Y.

When I try to run the SP (on server X), I get the following message:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I am logged in using a domain account that is a local admin on both servers (and also the SQL Server startup account on server Y). It is also the account used by the Report Server to connect to the RS databases. The startup account for the Report Server service is 'NT AUTHORITY\NETWORK SERVICE'.

Hi,

Try to change the SSRS service account to a domain account, and add this account to your SSRS database server and map to your SSRS database. Also, you should add this account to the RsExecRole role.

I hope it helps.

Regards,

Janos

Reporting Services - Port Number

Hi,

I have managed to get reporting services working, my reports and reportserver sites are not under the default site but under a custom site i have created, this site has been configured for port 8089. Reporting services for the most part is working fine but several of the links and buttons which navigate to a different pages getting the port number 8089 added to the end of the link which is causing the page to not be found why are these being added and how can i stop this port from being added. If i remove the port number then the correct page is displayed.

The URL within the two config files associated with reporting services does not have the port number, i use ISA to redirect to the port 8089.

Thanks and Regards,

Hi,

Heres some info. i recieved:

Tips on Changing the port number:
Part 1: IIS Configuration
Note: IIS routes incoming URL requests to the appropriate place based upon matching the URL's Host (DNS Name or IP Address) and Port (defaults to 80) to the IIS Web Site whose identity matches or accepts these parameters of the URL. The IP address of the URL's Host, the Port, and the Host header value (when multiple Domain Names map to the same IP address / server) must match. The default configuration is for the default web site to accept all un-matched URLs requested on port 80.

A. Modifying the IIS Web Site Identity - Open the IIS Manager, select a web site object, and click Properties. The Web Site Identification is configured in the "Web Site" tab of the Web Site Properties dialog.
- If a server hosts more than one domain name then create a new web site specifying a host header that matches a domain name
- If a port besides 80 required in the URL then configure the TCP port(s) of the web site to match the port required. From a client, the URL will require the port to be specified as follows: http://host:port/path

B. Modifying the SQL Server Reporting Services - Report Manager URL / path and Report Server Web Service URL / Path. These are assumed to be "/Reports" and "/ReportServer" respectively, but they can be changed or even created manually.
- The Report manager always uses the Report Server Web Service, so if http://host:port/<report server> does not work then http://host:port/<report manager> will not work.
- The Report manager must be configured to reference the correct URL to the Report Server Web Service (see part 2 below).

- The following two web sites describe how to create or move these virtual directories:
KB Article 867872 You receive a 1603 error message or a 25619 error message when you try to install SQL Server 2000 Reporting Services
<http://support.microsoft.com/?id=867872>
Moving Reporting Services' Virtual Directories
<http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk>

Part 2: SQL Server Reporting Services Configuration
- The RsWebApplication.Config file in the ReportManager folder contains a Configuration\UI\ReportServerUrl tag whose value is the URL to the <report server> web site. This value needs to be configured to match the URL to the <report server> virtual directory specified above.

Also if you are doing port redirection in ISA, try turning this off after going through the above steps as the two may be conflicting with each other.

sql

Reporting Services - Page Number Mismatch

I have seen this issue posted a few times in the forum, but have not
any replies or solutions...
In Report Viewer, the report is listed as having 10 pages both in the
Report Viewer navigation bar and in my footer (="Page " &
Globals!PageNumber & " of " & Globals!TotalPages).
When the report is printed; however, it prints as 19 pages with the
footer stating "Page xx of 19"
Both the interactive size and page size are set at 11in, 8.5in.
It seems especially problematic when the report contains a matrix.
Any way of getting these numbers to synch?
Thanks!Were you able to figure this out?
I have the same problem. We export the reports to pdf. None of the
three (HTML, Print Preview, pdf) has the same number of pages. Does the
Interactive size do anything?
JJodon wrote:
> I have seen this issue posted a few times in the forum, but have not
> any replies or solutions...
> In Report Viewer, the report is listed as having 10 pages both in the
> Report Viewer navigation bar and in my footer (="Page " &
> Globals!PageNumber & " of " & Globals!TotalPages).
> When the report is printed; however, it prints as 19 pages with the
> footer stating "Page xx of 19"
> Both the interactive size and page size are set at 11in, 8.5in.
> It seems especially problematic when the report contains a matrix.
> Any way of getting these numbers to synch?
> Thanks!

Reporting services

How to reset the page number for each group in a table on the report?

Thank you in advance.

Please check the following blog article: http://blogs.msdn.com/chrishays/archive/2006/01/05/ResetPageNumberOnGroup.aspx

-- Robert

|||

Thank you. This was very helpful.

Is it possible to know how many pages are in the group to print page number and out of these many pages in a group?

Reporting PWA HTML data?

We are using the SQL Reporting services to report on PWA workspaces.
(Project Server 2007)
A number of workspaces have data items stored as multi-line Rich Text
- which becomes embedded HTML when stored to the database.
The problem is that when it is included in any SQLRS reports it looks
*awful* because the html tags are just embedded within the text,
rather than formatted.
I've seen a couple of posts on SQLRS which basically say 'tough luck
until SQL2008' which isnt very encouraging :(
Is this really true - is there really no way to format html within
SQLRS reports?
Seems like a pretty critical ommission.
Crystal reports can do this stuff standing on its head :)
Any ideas on how to format HTML text within a SQLRS report? (built in
functions, add-ins etc)
Thanks
Al BlakeAl
Certainly this post would be better placed on the dev group, but you might
even consider asking the question in the appropriate SQL group.
--
Gary L. Chefetz, MVP
MSProjectExperts
For Project Server Consulting: http://www.msprojectexperts.com
For Project Server FAQS: http://www.projectserverexperts.com
"scubaal" <al@.blakes.net> wrote in message
news:e0323a2a-37d7-4a85-b1c6-59d7ed10d65d@.s13g2000prd.googlegroups.com...
> We are using the SQL Reporting services to report on PWA workspaces.
> (Project Server 2007)
> A number of workspaces have data items stored as multi-line Rich Text
> - which becomes embedded HTML when stored to the database.
> The problem is that when it is included in any SQLRS reports it looks
> *awful* because the html tags are just embedded within the text,
> rather than formatted.
> I've seen a couple of posts on SQLRS which basically say 'tough luck
> until SQL2008' which isnt very encouraging :(
> Is this really true - is there really no way to format html within
> SQLRS reports?
> Seems like a pretty critical ommission.
> Crystal reports can do this stuff standing on its head :)
> Any ideas on how to format HTML text within a SQLRS report? (built in
> functions, add-ins etc)
> Thanks
> Al Blake|||2008 will definitely have support for rich text. Not sure exactly what that
means though. For instance, does it mean you can have html from the database
and show that in a field? I don't know, but I sure hope to. I'm going to
investigate some out of my own curiosity on this.
But, for today, the only option is to strip HTML tags and convert the html
to straight text. Not sure if that will do it for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"scubaal" <al@.blakes.net> wrote in message
news:e0323a2a-37d7-4a85-b1c6-59d7ed10d65d@.s13g2000prd.googlegroups.com...
> We are using the SQL Reporting services to report on PWA workspaces.
> (Project Server 2007)
> A number of workspaces have data items stored as multi-line Rich Text
> - which becomes embedded HTML when stored to the database.
> The problem is that when it is included in any SQLRS reports it looks
> *awful* because the html tags are just embedded within the text,
> rather than formatted.
> I've seen a couple of posts on SQLRS which basically say 'tough luck
> until SQL2008' which isnt very encouraging :(
> Is this really true - is there really no way to format html within
> SQLRS reports?
> Seems like a pretty critical ommission.
> Crystal reports can do this stuff standing on its head :)
> Any ideas on how to format HTML text within a SQLRS report? (built in
> functions, add-ins etc)
> Thanks
> Al Blake