Hi, My server is currently running Reporting Services. I want to upgrade it to reporting services sp1 or sp2. I wanna know after upgrading it to sp1, will I will be able to view my older reports which is created using reporting services? ...more >>

I have a report that consists of a single table that has a detail row and two levels of grouping. Each group contains a SUM formula to aggregate a single column in the table. When this report is rendered to Excel the sum is replaced with the result of the formula. Is there any trick to get Rep...more >>

hi all, i'm using matrix control to produce a report. is it possible to render 1 page of report for each month according to the start date and end date entered by user? the dates are displayed as columns in the matrix, eg. dates: 27 feb 2006 - 03 march 2006 page1 -----------------------...more >>

I have a stored proc that calls on a view in sql server. The view is actually my Active Directory LDAP query. I have already created a linked server and account for my user name jkim. I have a report that polls data from this stored proc. After I set the datasource which uses an account "sq...more >>

We've got a SQL Server db with tables and views than are the basis for fact tables and dimensions in a group of Analysis Server cubes. We need to build some reports based on this data. Should we use MDX and have the cubes be the data source for the Reports, or our SQL Server db? Pros and Cons?...more >>

Hi, My sql 2000 reporting services (sp2) running on windows 2003 (no sp) occassionally gets the following errors in the system even viewer: ==================== The ReportServer service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken i...more >>

Hi, Example. I have two searchable parameters in my report. (Skills) and (Last Name). I would like to have the choice of searching by either one or both parameters. When I just put in a value for (Skills), error comes up "need to enter value for (Last Name)". In the report parameters setup box,...more >>

I am attempting to add columns dynamically and i have that working. The problem is I cannot collapse the columns if the columns in between are not selected. For example if they want to see column 1 and column 6 only, there is blank space between the 2 columns. How do I collapse columns 2-5 and...more >>

I have been trying to use the XML export along with an XSL file to try and generate WordML files from reporting services, and so far have had no real success. I have tried using the XSLT Inference Tool and following the VERY limited documentation that exists for it, but it just does not want t...more >>

I am trying to do some date manipulation in the data set based on a report parameter . The parameter is called RDate and is a datetime type. DATEADD(DateInterval.month, DATEDIFF(DateInterval.month, RenewalDate, @RDate), Month) When I "run" the dataset, I get this message: "Syntax error or...more >>

Greetings, In an attempt to avoid hardcoding of server / database names in Reporting Services Reports, I'm attempting to use a UDL for all of the Datasets. I already have a datasource established, using the Data Link properties box, which I then employ for each dataset, but I'm uncertain h...more >>

Hi, I created a test procedure as below. However, when I execute the proc, I get the message stating: Procedure test_sp expects parameter @fldofc which was not supplied. In the Parameters tab I have made the assignment properly. Also, I added them to the Report Parameters in the main menu....more >>

OK, I am trying to pass a comma and quote delimited string to a query, Example: Select * from myUsers where Userid IN(?) When I manually type in something like ('1234','4567','2345','9933') for the parameter directly into the query I get the expected results. However, when I type the EXA...more >>

Hi, Which is the best way to insert a document into a report, which is also rendered with the report? Writing a custom report item? Rendering as image? But how to do a page break? Is there a commercial solution available? Thanks Eric...more >>

Hi, I am trying to install reporting services client tools onto my desktop PC. It appears that reporting services enterprise edition have been installed on here before but there is nothing listed in add/remove programs for RS. An excerpt of the install log is below, I am not sure what is set...more >>

Hi, is it possible to a) have a read receipt when sending out an email and b) know when the recipient has accessed the report? Cheers ...more >>

I need to install SQL2000 Reporting Services on w2k3SE R2 x64 (for MS MOM2k5SP1) but it requires Visual Studio .NET 2003 that requires FrontPage Server Extensions 2002. But there is no such component in x64 version of Windows Server 2003. Is it possible to install SQL2000 Reporting Services on...more >>

Hello, How can I put background images into a report? ...more >>

Hi, I am new using Reporting Services and I have a need to create charts dynamically depending on information from a parameter. I can have anywhere from 1 to about 30 graphs that will need to be dynamically created. Can this be done using the report builder? Is there any documentation on the ...more >>

Is there any log in SQL RS 2000 which has an entry when a report is deleted?...more >>

Does anyone have a simpler method for this ? I want to get the last Day of the Current Month, so my thinking is to take one day away from the first day of next month...it works but is perhaps not very elegant. =cdate(format(DATEADD("d",-1,cdate("01/" & format(System.DateTime.Now.AddMonth...more >>

Hi All M a newbie in RS 2005 .. I need to integrate my RS 2005 Reports into the web applications .... say ASP.NET or made using C# ... without using the web-services ... there's a way using URL access and one more using Visual Basic 2005 ... All my queries are stored as stored procedure and ...more >>

Hi All I was wondering if there is any way of viewing reports created in reporting services over the web without having to use Sharepoint. I do not want the usual reports server view. I would like as close to the Sharepoint Report Viewer web part as possible. Many Thanks...more >>

Hi, I am trying to display data on a new page when one field contains specific data. Once this data is read I wish for any following information to be displayed on the next page. Any help would be much appreciated. Ivan ...more >>

I can't found how can I do the following, would you give me suggestion? Thanks! If I want to show report like this Code Description Amount Balance XXX XXXXX 123.45 123.45 XXX XXXXX 4.25 ...more >>

Help please! I have written a report and it works great on the local machine, I have just deployed it to the server but when I go to the browser and run the report I get an error: "Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError...more >>

Hi Experts, Can anyone tell me how to specify an expression to be mentioned in the "Jump to Report" in the Navigation tab. I basically dont want the hyperlink for some values. = iif( Fields!ItemCount.Value = 0, "", "Detail") this is the expression which I have currently given. I dont wa...more >>

Hello I'm new to reporting services (2000) How do I dynamically populate a matrix column (or table) using the parameters entered by users? Example: A user enters a date range to filter the dataset. Parameters are Start Date and End Date. Then I want to be able to display in the report ...more >>

Hi, I have a DataTable within my report which can be invisible based on a expression value for the tables' hidden property. The Visible/Invisible section works very fine with printable reports. The problem is that invisible data appears in XML data. That means SQL RS actually sen...more >>

I have couple of questions. Hope you all can help me I am using sql server 2005 and VS studio Net 2003 1. When i export the report to pdf format, all chinese language cannot be displayed. Any ideas? Sure if i print it directly, all chinese can be shown. 2. for margin setting, i have set t...more >>

Rendering in Excel does not honor my page layouts (landscape, 8.5x14, etc.) - every report comes out 8.5x11 portrait. PDF works fine, as does printing from the HTML default. Any input is appreciated. Scott...more >>

When I export reports with charts to PDF, the server really takes a beating and the resulting PDF file can get quite large. We would like to reduce the resolution of the chart images that are being embedded in the PDF and/or reduce the resolution of the PDF itself. The help topic "Designin...more >>

Hi, I have a Table in my report and I chose "AttributeNormal" for DataElementStyle property of the all text boxes within the table's detail row. The problem is that SQL RS doesn't output text boxes with null values. Is there anyway to force SQL RS to output null textboxes as blank at...more >>

Is there a "lite" version of Visual Studio 2005 or 2003 that works with Reporting Services for SQL Server 2000? Thank you in advance. Rich ...more >>

I have a multi-column report that I had working fine as of Friday night. It is basically a two-column report of bar-codes to be read by a scanner, with some identifying information under each entry. I then added a Header that picked up a data field using the recommended method I found in o...more >>

Report Builder doesn't play to well with Custom authentication does it? If i'm wrong let me know, otherwise, time to start getting creative again. ...more >>

I am trying to display a field in a report that sometimes contains html stored as text. I want to be able to strip out the html tags so I can display the text only in the report. ...more >>

If I want to upgrade my SQL server 2000 RS box to 2005, is there anything I should be aware of, is there a document laying out instructions? I am also upgrading from VS2003 to VS2005, is there anything in my report solution files that I should be aware of? Just looking for info on upgrarding...more >>

Can someone please tell me how I can return the Nth item in a dataset I can get the first element out like so: =First(Fields!ID_Month___Year_Jul_.Value, "ds_Set") But how to get the Nth element Many thanks P.S I'm using RS2005 ...more >>

Is this possible?? I want to install SSRS 2005 on a separate server and then point it to create reports from a SQL Server 2000 database...more >>

I can publish reports to http://myserver/ReportServer just fine, but when I try to view them through http://myserver/Reports, nothing is there...no folders, no reports, not even the ability to access the security. Can you help me? ...more >>

I think the report model concept is great and it works well for the report builder. Can a report model or a data source view be used as a datasource for ordinary reports? We have a large number of reports built upon complex relational queries (join join join join...), but pretty much the same ...more >>

Hi, I have a two parter based on matrix reports I am trying to develop a report which displays data for weekdays as columns and Servers as rows. The range of the dates is selectable by the user so is not fixed. We track start / end times for each server as it starts / ends backups and th...more >>

Hi We are having a problem with authentication on our reporting server. If the user connecting is using IE version 5.0 they get a not authorised to view page error (see below). It works fine for this same user if they use a machine with ie 5.5 or greater. Other users also have the same prob...more >>

Hi, I am planning to use Microsoft Reporting Service with Oracle as my database. Is this a possibility? What are the pros and cons. Also Oracle is going to return me a huge volume of rows max in millions, can Microsoft Reporting Service handle this? What is the best alternative. I am aware th...more >>

I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003 64bit SP1 Enterprise Edition. Reporting Services Configuration Manager indicate that everything is ok, green checks except Encryption Keys and Execution Account. Reporting Services databases, ReportServer and Rep...more >>

Does anyone have an example of calling the render method on the _serverreport_ class including passing in parameters? TIA, Ed ...more >>

Hi, I have a report which contains almost 30 pages. The report is rendered using webservice interface of reporting service. At present, all the report data is fetched at once from the reporting server. This is making my report quite slow. Also many times it happens that out of 30 pages, use...more >>

HI, Is it possible to create a sceduled delivery of a report through C#? For example, if I wanted to send User1 a Report1 at 4PM, and I had to do this in my C# application, can this be done, and how? Please, I need to be sure. Regards, PM...more >>

I wasn't able to find sufficient information on sending parameter values through URL string. Does anyone know how to do this? Do I need to use predefined parameters? Thank you. ...more >>