How do I set the line width (weight) of lines with a line chart. Lines always seem several pixels wide. Also, when selecting "Numeric or time-scale values" on the X-axis of a line chart the labels appear vertically in the Chart Properties dialog box but appear horizontally when the report ...more >>

Is it possible to use a SELECT statement as the expression in an IIF function? I Cannot get it to work. i.e. IIF((SELECT COUNT(column) FROM table WHERE column = Fields!Variable.Value) > 0, "BAD","GOOD") -- Thanks in advance GH...more >>

I'm hitting sysjobschedules to get the next job to run, but I need to know if and how many jobs are currently running. What table would I hit for that? -- Thanks, CGW...more >>

I have this query: SELECT * FROM PMA_Employee left outer JOIN PMA_EmployeeAllergies ON PMA_Employee.EmployeeID = PMA_EmployeeAllergies.EmployeeID Note, that here are two fields with EmployeeID name. When I try to create report in VS, I get this error: ...more >>

Group... I have a requirement to add a custom button to an ASPX 'View PDF'. When the user clicks this button a specific SSRS report will be returned (Open/Save) as a pdf. I need to be able to do this without using the MS Sample Report Viewer control (which has the 'Select a format, Export' op...more >>

I have a report whcih displays information about a servers hardware configuration. Unfortunatley the vendors application whcih collects and stores this information, add spcaing between vaules in the form of [-] and [+]. I'd like to remove this in the final rendering of the report for displ...more >>

I have been successful in using a Template for my Reports, however if I decide to change my template after a few reports have been created the old reports do not 'automatically' pick up the changes to the Template. Is there a way to 'Refer' to a template as opposed to 'Using' a template? Wil...more >>

I am new to reporting services and have created a few reports. I have noticed that I can cache or create a snapshot of the reports. I currently use a Crystal Command line tool to run crystal reports around 4:00 am, and I would like to do the same for some of my reports. What is the diff...more >>

I had to reinstall RS. While reinstalling Reporting Services I received an error. I am at the point of specifying the report server database and I tried to use the default, "ReportServer", which is the same as I used before. The error = "A database with the specified name(ReportServer) alre...more >>

I'm working on a report that could potentially require 13 or so datasets in order to get the specific fields that I need for each section of the report. The SQL table is structured as follows: select year, branch, measure, jan, feb, mar from tblBPM_BP I was trying to bring all of...more >>

I have a reporting page with many charts. Is there a way to create the chart with 2 Y-axis? I looked around but no luck. Thanks. -Joseph...more >>

Hi: We are deploying SRS to report off of our DB2 DB running on AS400's. I have deployed to the Reporting Server a shared data source (SDS) that points to our develpment database. I have just deployed a shared data source that points to our SQA database. If I deploy reports that were ori...more >>

When i try to pass the hidden parameter p1 to my report i get the below error.if you have come across such error please suggest the way around "The report parameter 'p1' is read-only and cannot be modified" ...more >>

=iif( Fields!SomeCol.IsMissing , TRUE, FALSE) does not seem to work in visibility expression of table properties. any ideas for using expressions to hide a table with a null dataset would be great. tia mike ...more >>

For example I have a database with employees with their cities. I need that the report ask the user which CITY to show on the report? -- LUIS ESTEBAN VALENCIA MICROSOFT DCE 2. MIEMBRO ACTIVO DE ALIANZADEV ...more >>

We have been creating reports using SSRS but would like our users to request reports through a custom interface NOT the standard SSRS interface. So as far as I know there are 3 ways of presenting SSRS reports to users: 1) Report Manager 2) Reports through URL 3) SSRS Web Services 1 and 2 are s...more >>

How would I indentify duplicate Records ? Eg. Bob has qualification A and B Steve has qualification A and C Dan has qualification c and b Nash has qualification A Employees with duplicate values are Bob and Nash - how do I do this in SQL?...more >>

Hi I am still a novice to SQL Queries. What I need to do is Have a list of employees that are in a company defined by the parameter @company, and that do not have a hire date defined for @company, although they may have hire dates defined for other companies....more >>

I have a report which is based on a start and end date that are passed as parameters at run time. This works fine. However, in the report is a link to another report, which needs to run based on the same date parameters. However, the following happens... Report 1 runs fine with date paramet...more >>

Does anyone know what the message " Exception of type Microsoft.ReportingServices.ReportProcessing.aw was thrown." means? I searched the Knowledge base and couldn't find anything. I kept getting this error when I try and view the report I am working on in Visual Studio.Net. I made some changes...more >>

Is there a way to change data coming from all caps from the database into Title Case in SQL Reporting Services or in the SQL itself, there are going to be multiple but random numbers of words, its for an address field example (data comes in like): 12 PARKER ROAD ...more >>

I am re-writing our existing Crystal Reports in RS, all of the SP's already exist for the reports, so I am trying to use what we already have and create clones in reporting services - I have a datetime field that is being returned from the sp, and I need to have a high level of grouping in the...more >>

Sometimes when I run a web report created with the MS SQL Reporting Services causes this error. It seems that some components are missing to be load. 1. Report is activated from MS Explorer browser through an ASP.Net C# form 2. Report runs a stored procedure in the Informix DB(Provider=Ifxoled...more >>

i am using mailto: protocol in jump to URL. if i hard code the value (xyz@microsoft.com), it works fine. But if i try to use mailto:Fields!email.Value, it throws out an error to me saying "Invalid URI" Has anyone faced such kind of problem or has a solution for it? -- Thanks! Ashish...more >>

I've installed the Reporting Services on a Windows 2003 server - which is already running Windows Sharepoint Services. I've read the help - which refers to a 'side by side' help topic in the set-up documentation (which I cannot find). This message appears when I open the 'report manager' page....more >>

When I print my reporting services reports off, they print out almost like screen shots. For a long report, only the 1st page is printed and you get the scroll bars getting printed out as well. I have tried exporting out as a web archive and then printing, which is better. But this will me...more >>

I have 70 reports which all have company logo. If the name of logo is changed, I have to modify this 70 times and upload to report server 70 times. Do you have any suggestion that can minimize those tedious work load ??? Can report service allow to include HTML file which can be located in ...more >>