Is there a way to run the same report with different parameter values? I have 159 different parameter values (In other words - 159 reports to save). I have already written a VB.NET application (with reporting services web service) to automate the saving of these reports (by way of pdf files)...more >>

I have a report where I'm grouping based on week number, and I need to translate the week number to the starting Monday of that week. This is the format expression that I'm using =Month(DateAdd(DateInterval.Day,((Fields!Week.Value-1)*7),DateValue("January 1, " & Year(Now()))))& "/" & Day...more >>

Hi All, I'm experiencing the error referenced in the following link to MS Support http://support.microsoft.com/Default.aspx?kbid=922656 I implemented the workaround but I'm still getting the error. Actually when I started I was receiving "error message 1" and then when I updated my RSWeb...more >>

When trying to apply SQL Server Credentials "Create a Grants Rights Script" is red with "X" - Task Failed: System.Management.ManagementException: Invalid namespace at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode) at System.Management.Manageme...more >>

I'm new to SSRS and need info on integrating SSRS controls into WPF. Any guidance will be appreciated. Thanks,...more >>

I have a group that I'd like to sum, but when I use =Sum(Fields!BF_Child.Value,"table1_Details_Group") I get the sum of all rows, even ones that are hidden. How do I sum only rows that show up on the report, not the entire dataSet?...more >>

I am trying make a sum(first(Field.Value)) but reporting services generated the following error "Aggregate functions cannot be nested inside other aggregate functions reporting", how i can make this operation? ...more >>

I am using the rsscripter tool to migrate my reports from the dev machine to the acceptance machine. I am getting a compile error: Running script "GlobalReportsLibrary\GLOBAL\rpt_100_PutAway.rdl.rss" The specified script failed to compile with the following errors: C:\tempreports> "C:\WINNT...more >>

Hello, I´ve created a subreport to add it to my main report. When I open the main report, the subreport is correct with all the parameters I´ve passed from main to subreport. The problem comes when I add a chart in the subreport. It shows an error message like "Error: Subreport could not...more >>

I have an application with a parameter that has a single value drop down list from a query. My dataset has a union with "0","All". I set the default to non-queried, value "0". I go to preview and BI displays the label correctly as "All". When I deploy the app and view it in the web browser the d...more >>

Hi all When I export my reports to excel, all cells are set to "General" number style. Users wanted to show numbers as "Number", but I didn't found the way to set the cell output style. Any idea? Thanks in advance. ...more >>

Hi Folks, I have a dataset in Reporting Services which points to an stored procedure. This SP returns all data. Then the data is filtered in the dataset based on the report parameters is choosen. 1. Will the dataset be refreshed every time i hit the View Report button or will it get refre...more >>

I've created a subscription (Trigger = TimedSubscription) but when the SQL Agent job runs I don't get any error messages in the logfiles or event log. Also the "Last Run" column is alway blank. Any ideas how I can trouble shoot my subscriptions?...more >>

I'm trying to get a sum of values from a group with the following expression. =SUM(Fields!BF_Child.Value, "table1_Details_Group"). When I try to run it I get the following error. [rsInvalidAggregateScope] The Value expression for the textbox ‘textbox7’ has a scope parameter that is n...more >>

During SP2 set up there was a problem with KB921896 that didn't get applied. Now reporting services doesn't work. I have forms auth but when trying to go to the login page is would say that "machine\user" cannot log in. also, the config tool throws errors and exits automatically. any ideas?...more >>

I am developing a new report in VS 2005 with Reporting Services 2005 installed. I go to preview the report, and I get this: "The definition of report blah is invalid. An internal error occurred on the report server. See the error log for more details." I have been looking everywhere for th...more >>

I have a dataset that is based on a dynamic pivot stored procedure. There is at least one column name that I know will be in the dataset, the key column, but the rest of the columns are dependent on the data in the underlying table. Once I have the dataset, how can I put it in the layout giv...more >>

Hello, Thanks for reviewing my question. I am new to reporting services and experimented with a couple of reports. I have the following data in a table: # name slot 1 A1 1 1 B1 2 1 C1 3 2 A2 1 2 B2 2 2 C2 3 I would like to output in this f...more >>

I'm new to reporting services, My company is trying to evaluate the service to see if we can use it to replace some legacy reports. I'm able to get most of it done but there is one problem I haven't been able to solve in the last several days. Select Table1.columnA, Table1.columnB, Table1.co...more >>

I have three parameters for a financial rpt. Division name, "From" date, and "To" date. I want the "From" and "to" date parameters to be on the same line, with the division name on top. How do I make this happen? Thanks in advance! carl...more >>

How can I have my report sorted by multiple columns? I can set columns for sorting but they only work one at a time. Thanks ...more >>

Hello. We are trying this out (Eval). We have Oracle 10.2g database and Sql Server 2000 database. Of course they are in two different server machines. We want to know if Reporting Services for SQL can connect to SQL Server 2000 and to Oracle Database simultaneously? The evaluation versi...more >>

I have a popup window which shows the report. I don't want user to modify the parameter of the displayed report. how can i hide the parameter list. I am familiar with rc:ToolBar = false while invoking the report how can i disable parameter from being changed thx ...more >>

Hi, Is there any way to establish a relationship between multiple datasets generated at the report level? For example is it possible to run two queries and reference the columns to do in memory joins? The client we are working for has a poor data structure and unfortunately our hands ar...more >>

I am trying to use a ReportViewer control in a VS 2005 web application project (not Website project). When I try to create a new report (local), I can't seem to find any method to create a datasource. I would like to use an existing class object. The examples I have found state that the class ...more >>

I am attempting to install Microsoft TFS, but it is failing when setting up Report Services. In looking at the SQL Server 2005 with SP2 Report Configuration tool, I see that "Web Service Identity" is red. ALL of the fields associated with it appear to be blank. I used the drop down to set Re...more >>

I have a set of dates they are non contiguous. Like for instance -----StartDate--------End_date--------Title------ 1/05/2003 2/15/2004 Superintendant 2/30/2005 5/25/2006 Manager 12/1/1987 1/01/2003 Superintendant what I need to do is gra...more >>

I write the following expression for a textbox: =IIF(IsNothing(Fields!modifiedon.Value),"",Fields!modifiedon.Value.ToLocalTime()) If the value is not null, it works perfectly. If it is null, I would expect nothing to print but instead I get #Error on the report where the empty string shou...more >>

I know that it's possible to get () around negatives in Reporting Services, but I have yet to find a way to have it display 0 as a - (hyphen). I've found that I can use an IIF but that means that the - will be a string and not actually representative of 0 when exported to Excel. Anyone have a ...more >>

I've got a puzzler here. I have a report with 4 different dropdown lists for parameters. One of them is Department Id. For some users, I want them to be able to only run the report against their own department id but still be able to select any of the values for the other parameters. Other...more >>

I'm getting the "Report Server has not been congured for use with ASP.NET 2.0" when I open the report server web site using VS 2005. This is on Windows 2003 and the SSRS 2005. Any idea how I can resolve this? Thanks, Gilgamesh ...more >>

IN SQL RS 2005, Trying to have a paramater upon item selection ( say New York) open another hidden Parameter LIST (City ,List of 4 to select from) for another selection before viewing the report. Anyway to do this easily in Report services ! Signed AEM -- Auggie - Central ...more >>

Running RS2000 on Windows 2003 I published a new report today (copied from an existing report, used same data source calling different stored procedure, changed parameters, etc.). It worked fine when run locally. However, when published and run within Report Manager I get the following ...more >>

We would like to keep our SQL Server 2000 databases and use Reporting Services 2005. Is it needed to have an instance of SQL Server 2005 on one of the machines or can we do without? Thanks. ...more >>

Hello, I am using the following to try to find date ranges and do some work. Here is the statement =iif(fields!mbr_join_date.value = "7/01/2003", mbt_code, "Not Grandfathered") I have looked at the query result and I see alot of dates that are this date but it's not putting the MBT_Code in f...more >>

Hi! I'm having some problems with creating a report, feels like it should be fairly easy to solve but somehow I can't find the solution. An example of my data (simplified) for a client: Row1: Portfolio1, Stock1 Row2: Portfolio1, Stock2 Row3: Portfolio2, Stock3 Row4: Portfolio3, Stock1 ...more >>

Hi kids: I'm sure this is an easy one, sorry for posting a knob question.... Whenever I attempt to deploy a report, I get prompted for a login. I don't remember setting SSRS to run as anyting except Local System, and the configuration tool bears that out. When I click "deploy" on my (very...more >>

I created a report parameter that selects vendors when running the report. When I run the report, I would like an option to select all vendors for the report. How can I do this? I have to select each vendor one by one....more >>

Hi there, I am facing the following situation: A ASP.Net web site is showing a report using the reportviewer control. That works fine. For exporting (expecially PDF) I am not using the toolbar of this control, because I need to set an additional parameter to tell the report that he has rend...more >>

Hello there, I got following problem, I have some charts in my report and I need to export reports to excel, all charts are being converted into images, which is fine, but the quality of this conversion is not good and for example axis labels are barely readable, while for example exporting to ...more >>

hi there, i have question..i have a table which i fill with data form a database... Col1 Col2 Col3 ------------------------------------------------ =Fields!.. =Fields!... =Fields! Col1 is filled with some text and has like 15 rows, and Col2 and Col3 are its...more >>

Is this not possible? Jeppe Jespersen Denmark ...more >>

Guys, I need your help here. I'd deployed a report(SQL 2005, VS2005) it is working on my local server, but when I publish it in my production server, all the hyperlinks aren't working anymore, what could be the reason? (Both SQL 2005 already installed SP2) I've checked the tags in local server...more >>

what should i do first to start creating RS application. After when i install ssrs and iis and connected to SQL Server 2000 Database, Do i need to first create a new RS project or i need go to Reporting Services Configuration? Thanks....more >>

I am trying to create a report that will append a calculated row of percentages to the end of a group of test results. The results are grouped by 'Category A' and have different subcategories. But overall, I want to generate percentages for each column in 'Category A'. The columns of Category...more >>

Hello, I have a question regarding passing parameters in the URL to launch a report. I am able to pass parameters successfully most of the time. However, in some instances a portion of one parameter is a caret and this seems to "break" launching the desired report. Does anyone know how to ...more >>

I am using SQL Reporting services 2000 for stored procs /views in Oracle database. On uploading to the report server I get this error System.Data.OracleClient requires Oracle client software version 8.1.7 or greater Can anybody help with suggestions? ...more >>

We have a little dilemma with our DBA staff regarding reporting services and using a general account, we call RSAdmin, for executing stored procs in the background and bringing back the results via Reporting Services. Our DBA is suggesting that we stay away from a general account like this ...more >>

Hi I have developed a report using microsoft reporting services with certain fields. In my report the user enters name (which is a parameter) and the report is displayed Inside my report. I have a field studentID which should be a link which when clicked should take me...more >>

I there a way I can print a report without viewing it first? ...more >>

Hello, I am creating a profit and loss statement in SQL Server reporting Services. This single report creates a one page P&L for each loction in the company. Some of the calculations are based on the Sales of each location (i.e. percentages etc.). I'd like to reference the sales total for ...more >>

Is it possible to have a cached version of a report expire after 20 seconds? Everything that I have seen only allows 1 minute as the smallest time interval. I am working on a "real-time" report that needs to be refreshed a few times every minute and our server is being over-taxed with all the...more >>