How do I embed a barcode in my report without using 3rd party software? Thanks Smitty ...more >>

When using Grouping in a report, is there a way to force a group to start on the next page if the group will not fit on the current page? I believe in Access or Crystal Reports there is an option called keep together that provides this functionality. Thanks. ...more >>

I have a web based application that allows users to apply for employment via the web. Once the appllcaition is submitted I want to send the details to HR via email using SSRS 2005. I'm not very familiar with rs.exe utility which is the tool I think I need to use. I would appreciate it if an...more >>

I just finished editing a report in reporting services...I want to upload the report but the menu isnt available to me when I go to http://localhost/reports. Also when I log into the reporting services engine using sql server 2005 studio I try to right click any node to get the properties, ...more >>

I am experiencening the folowing problem with RS SP2. My reports do not render all of the time, sometimes they run fine in a few seconds other times they simply do not run. These are small reports with only a few hundred records in the dataset. They are using store procedures to generate th...more >>

How can I enumerate only those servers running reporting services in c#. I can get a list of all SQL Server instances on the local network using: SmoApplication.EnumAvailableSqlServers(false) How can i filter this list to include only those instances where Reporting Services is running? ...more >>

Hi everyone, I created a calculated field (=Fields!RUN_RATE.Value / Fields!STANDARD.Value) this field gives me my % of Standard field. I want to be able to display anything over 200%. I tried filtering it as a group filter, but when it runs it first shows everythin ok, I put my dates (paramete...more >>

Hi, all, Suppose I have a set of .NET business classes to return data. How can I use them as a data source for an SSRS report? (this is for ssrs2005) As far as I can tell, the only way is to create an XML web service that calls the .NET classes, and then define that XML web service as ...more >>

Anyone know how to include in a report a text box with a function that shows the time/date of the most recent cache? This is a cached report, no history, with an expiration interval of 60 mins. I see no functions that would display the time of the most recent cache (when the snapshot was tak...more >>

Currently I am using a SUM(IIF(field = "A",1,0)) and if no records have "A" the textbox displays 0. However, if the dataset is empty, the textbox remains blank. My customer would like it to display a 0 in the textbox for an empty dataset, or by default if possible. Anyone know what I can m...more >>

I need to display a description field in a textbox on my report based on the value of another field. There are about 20 values -- the iif seems to be limited to 3 values? Example: Iif (fieldvalue="0360","Return Check", fieldvalue ="0960","Hotel Tax" which continues for ...more >>

I've got an internal Reporting Server and I can access the reports directly there with no problem. I can generate a report with the WinForm without a problem as well. What I'm trying to do is to use a second, public web server that has an ASPX page containing the reportviewer control that ...more >>

Hi All, I'm trying to run a report in MRS that I've created and get the following when I debug or try to run the report: Error 1 [rsUnexpectedCompilerError] An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC42206] Maximum number of warnings ...more >>

Sorry for the double post. I have the following expression for a field and I need it to not report NAN or Infinity when it is run. I have tried and tried to get the IIF statement to do this and can't get it right. Anyone want to try and tackle this? John =FormatPercent(((Sum(Fields!Re...more >>

I have the following expression for a field: ...more >>

I have put following expression in a textbox. ="My name is " + First(Fields!Brok_Name.Value, "myDataset") I just want to Bold the Field value and not the word "My name is ". I also want to justify the text Alignment, how can I ? I am using Sql Server Reporting Service 2005. Any idea ...more >>

I want to show Date Ranges as Headings on top of report, for this, I have created a blank parameter and named it "heading". The Parameter's Default Value is Blank. I have also set the above parameter in expression of a textbox but when I pass any string from ASP.Net at runtime, nothing appe...more >>

How can I hide columns of table dynamically through code ? I am using Sql Server Reporting Service 2005. Best Regards, Luqman ...more >>

Is there any documentation available on building a report model other than the SQL Books Online? The subject is usually given about 3-5 pages max in any Reporting Services book. I'd like to see a whole book on the subject, with lots of examples. -- LehrSJ...more >>

I have created a matrix report in RS 2005 which works fine in the VS development environment. When I run it from the Report Services server, the Report Viewer displays the full matrix grid, but only to a certain width. As a result, most of the columns don't appear. It usually chops off the...more >>

My company had decreed that all documents, emails, etc should use the Verdana font type. Report Svcs default is Ariel. Does anyone know where I would go to change the default fontfamily type to Verdana from Ariel so that i dont have to go into every property of every item in every report to ch...more >>

I am working on new reports. I am deploying reports to production SQL/RS = box but a database for new reports is a local on my computer. When I try = to run new report I am getting: a.. a.. a.. a.. a.. a.. a.. a.. a.. a.. a.. a.. a.. a.. a.. a.. a.. a.. = a.. a.. a.. a.. a.. a.. a.. a.. a.. a.. ...more >>

SSRS 2005 I would like to perform validation on the user entered parameter values. If the value does not pass the validation, would like to suppress the report generation. I have successfully added a hidden paramenter and added a non-queried function to validate the parameter in question....more >>

Hi experts Does it exist a "speedometer" chart that I can use in my reports in RS? If not, how do I build one or where can I download it? Lars...more >>

Hi experts, I am working on SQL server 2005 reporting services and i am getting a problem. I am developing a report in which i am taking two parameters one is FromDate and second is ToDate and i have changed thier Data type as Date Time. So it is giving callender control in reports. And de...more >>

Hello I'm testing Report Server MS SQL Server 2005! I' working against a ORACLE 10g Database HR-Schema! Dataset Satements works great, I can see a nice report SELECT LAST_NAME, FIRST_NAME, EMPLOYEE_ID, HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, SALARY + SALARY * NVL(COMMISSION_P...more >>

Hi all, I have question regarding reporting service installation. Do I need to install reporting service server software and client software respectively? Thanks. ...more >>

Hi All, I am wondering is someone can point me in the right direction, I updated to the latest service pack on my Report Server Production Machine and now when I attempt to deloy a report I get the following message The Item '/Data Sources' already exists I have tried everything I can thin...more >>

Is it possible to use an expression to manage a sort. I want to be able to display in say the following order Product A Product C Product B id's wont work as they are numbered all over the place. Thanks in advance...more >>

I have a work order/invoice report that I have written. The report contains several subreports. I have a need to have the subreports to not grow beyond a certain size. I have not found a way to do this as the size of the subreport is variable. Can this be accomplished, I have been able to do t...more >>

I have a report that has 6 columns and won't print in potrait mode. I have set the page width to 8.5in and the page height to 5in. If I set the page height to 11in it prints OK (but I need to limit the height to 5in. Also, can I use this report as the report source for a subreport control? ...more >>

Can someone please explain what is this? That happend when I clicked on a plus sign to collapse a node in the repport. Server Error in '/Reports' Application. -------------------------------------------------------------------------------- Execution '2ns4uy45lycd42r4fhindozx' cannot be found...more >>

Hello, all. I have a report whose email subscription runs every hour, Monday - Friday. My problem is I'd only like to get the report between the hours 8am - 5pm. I created the report yesterday and checked my email this morning to find the report ran **every** hour since 5pm yesterday. How ...more >>

In order to have a backup of the rdl files for reporting, does exist a manner to extract the rdl files inside RS starting from published reports? In other terms, is it possible to revert the report publishing process in order to have the rdl files? Many thanks...more >>

how to set the color of the bar in a chart that display the series of data.it mean that a chart will have bar with 3 or 4 colors.PLZ tell how can i set my own color of these bar ...more >>

Hi group Finally I got it installed... ;0) when I try to access the http://server/reports/ I get the following error Cannot use 'partitionResolver' unless the mode is StateServer' or SQLServer I tryid to give it a seperate appPool... I have a sharepoint on theres as well anyone th...more >>

I have a subreport on a SRS report. When I run the subreport by itself, there is no problem. But when I run the main report it always generates a blank page as page one. Any help pinpointing the problem would be greatly appreciated! Thanks, Bob...more >>

I've got most of my first stab at using Reporting Services. I am using the Report Viewer control in VS 2005. When I point it at a report based on standard TSQL it runs. My next query is based on Analysis Services. It runs via the URL when I login as an Administrator but I get the following err...more >>

Hi, I'm trying to set up an integration between Sharepoint and Reporting Services. I've followed the instructions provided by Microsoft to the letter, and am getting an error message when I try to "Grant Database Access" from within the Sharepoint Central Admin tool. I have everything set ...more >>

I install SQL Reporting Services and successfully complete the Reporting Services Configuration dialogs. On going to http://localhost/reports I receive : The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh butto...more >>

I am having an issue where I can't get any reports to run no matter how simple (eliminating the possibility of it being a session timeout problem). I constantly get an execution not found error as soon as the report starts to run. It seems to make no difference where I run any report from or...more >>

I am in desperate need of help. We have just set up SQL Server (2005, SP2) with RS on a Windows 2003 server. None of us have ever deployed RS before. To make matters worse, all of our network operations have been outsourced, so we do not have control of the machine and the people who do d...more >>

I have configured my report server. I can connect to it via Management Studio and via http://localhost/reports however when I try to connect via http://servername/reports I get a Windows style password box. What user is it expecting? Regards, Chris. ...more >>

Hello, I want to concatenate a string like =Parameters!Para1.Label + ": " + Parameters!Para1.Value + ", " + Parameters!Para2.Label + ": " + Parameters!Para2.Value + ", " + Parameters!Para3.Label + ": " + Parameters!Para3.Value + ", " + ... But this should be universal for all reports and uni...more >>

Hi Group Absolute newbie in reporting services... Have a server with a SQL 2005 Standard Installation (version 9.00.1399.06) - and now I've been asked to check if reporting services are installed - How can I see this - and if its not there how do I install it ? ...more >>

I am looking for specific documentation on how to restore a mission critical Report Services environment in the event of a catastrophic failure. Thanx in advance, Greg ...more >>