I am using Reporting Services (2005 sp2) to display data from an Analysis Services (2005 sp2) cube. I am using parameters and have a few questions in regards to the Select All option that is available in the multi-select parameters that I have. 1) Is it possible to remove the Select All fro...more >>

-- Thanks, Jim...more >>

Hello, I know this is possible -- I just dont know the best way to address it. I have a report that takes a month/year. Users enter the month/ year and then how many months to show (so entering 1/07 with 3 months would show three reports -- 1/07, 2/07, and 3/07). The report for each month...more >>

I'm trying to layout a report with the data from specific rows placed in TextBoxes, as I want to use the report for printing out details. My DataSet has 2 colums: 'QuestionID' and 'Answer', eg: QuestionID Answer ---------------------------------- 100 Some text 101 ...more >>

Hi, I want to add a new button to Report Manager toolbar and add some functionality to it. Can anyone suggest me how to do this....more >>

Thanks for your help. We are using reporting services on a server (B), but the data are on an another server (B). I have applied security for different type of report, but i would like to know how could i for one report filter data for each user. Example: I have a report on Sales USA, only pe...more >>

Hi, I'm writing a report in VB.Net 2003 for MS SQL 2005 Reporting Services, and I need to pull in the current user logged into the computer running the report so this will print on the report. Basically whoever is generating the report. Is this possible? I wasn't sure if there's a list o...more >>

Hello everyone, I'm having trouble writing an IF...Then...Else expression. I'm still new at vb so all help available is helpful. So far this is what I have. =IF [Sum(Fields!HRS.Value) * 14.04] > [Sum(Fields!AMT_EARNED.Value)] THEN [Sum(Fields!HRS.Value) * 14.04] - [Sum(Fields!AMT_EARNED.Valu...more >>

I have a report (stored procedure) that I have set up in SQL 2005 Reporting Services. In a web app, I put a Reportviewer control on the page, and call the report. After a lot of trial & error, it appears to work. Sort of. What happens is when I open it on that tab (I am using AJAX Tab ...more >>

Hi everyone, my server windows 2003 sql server 2005 reporting services when I go to http://server/reports it works fine when I open Reporting Services Configuration the Web Service Identity is red The ASP.NET Service Account is blank and I can't type in the box. I have 2 virtual di...more >>

We have a report that runs every 15 minutes and saves the results to a file share that is referenced by a web site. Is there a way to prevent the previous report from being over written if the report has an error?...more >>

My ISP has me licensed for a production SQL Server 2005 database, yet they cannot provide me with the client tools that I need, specifically SQL Server Management Studio and SQL Server Business Intelligence Development Studio. If I purchase SQL Server 2005 Developer Edition will it have these...more >>

Hello Recently this one report errors as below when running on any machine except the actual server hosting the reporting services. a.. An error has occurred during report processing. a.. Cannot create a connection to data source 'databasename. a.. For more information about this ...more >>

Dear all I like to implement a parameter in SSRS SP2, that accepts values like 10001-10005 as postal code. This should be translated to 10001, 10002,10003, 10004, 10005. I tried to realize this with the following code: Function SplittingCodes(ByVal s As String) As String Dim...more >>

Hi, Can you set up a report so that you can dynamically sort columns. ie. When viewing a report you click on a header of a column and sort by this column. If so can you point me to an example Thanks in Advance ...more >>

I have a couple subreports that are in cells of a table. Whenever I run the main report, the page width automatically becomes wider than what I had it set, and I am assuming that it is probably because the subreports expand the width of the table. I went into the subreports to ensure appropriate...more >>

Hi. Like some others here, I'm struggling to get a production install of RS2005 (SP2). RS is installed on a dedicated W2K3 (SP2) server. The database is on a separate SQL 2005 (SP2) server. With the help of some posts here I finally am able to browse to Report Manager and also deploy repor...more >>

We need to implement SQL Server 2005 Report Builder using our own security model. We use application level authentication, in which a user ID and password is verified against a record in the sql server database. So, we don't use Windows Authentication. The problem is that we need to implement ...more >>

hi all, i have been trying to Deploy my report and it keeps giving me this error. When i go to IIS and browse on reports the Reporting Services page comes on fine. And typing http://localhost/Reports renders the Reporting Services page too. The problem is when i try to deploy, i keep getting ...more >>

I am having difficulty with a report that snakes correctly when it is run by itself but when placed onto another report as a subreport no longer snakes. The main report has one page of fixed info (it's essentially a cover page for the report) then the subreport follows. Help! Robert ...more >>

I have a report that has one Parameter. Open the Parameter and you get 1500 records. how to I serch the Parameter?????? There is not auto-complete on a Parameter. ...more >>

Any idea how come selecting a matrix and changing the font size does not affect all of the text? It seems like I have to select each row and to make this type of change. Do other people have this same problem? TIA Dean ...more >>

I am experiencing issues with SQL Server Reporting Services 2000 when rendering Excel (.xls) output on a Mac. The Mac is running Excel 2004 for the Mac and appears to download the .xls file successfully, but just hangs when attempting to open the file. All other reporting services format...more >>

i'd like to schedule some reports to run just before midnight on the last day of each month. it doesn't appear that the RS interface allows me to create just one schedule that would do that (i end up creating 3 schedules: 1 for months ending 30th, 1 for months ending 31st, 1 for February). ...more >>

If the user connect to the report directy via http://localhost/reports, there is no problem but if the user connects via an aspx called parameter.aspx the user gets the following error message. If I make this user a local admin there is no problem. the aspx page works fine, no problem, the r...more >>

I'm using VS 2005, SQL 2005 reporting services. SQL reporting services is working, and I have it both on my local computer, as well as on a server. I've created a report in the SQL Business Intelligence development studio that works in that environment. I've uploaded the same report to ...more >>

I have sales data that has Store, Department, Sales, Returns, Return_Rate, and Month. How do I get the Sales, Returns, and Return_Rate to appear under the Monthly column? Grouped under the Store and Department? The fields want to go to the left? Thanks...more >>

I would like to use the same report for different business units and each business unit has their own SQL server db (for security reasons). I would like to have a Business Unit parameter that would change the connection to the appropriate database. Any suggestions on how to do this? Is it e...more >>

DevStudio 2003, SQL 2005 I have a report with three parameters - Store Number, Location Number and Report Period. Store Number and Report Period are based on queries while Location Number is entered by the user. All are used to filter the dataset being returned from a stored procedure. B...more >>

I've been building reporting services reports for the last 6 months, and we just got our reporting services server last week. I've started deploying my reports to the reporting server, and I'm disappointed in the speed of the reports in a VB.Net windows application. I'm running the reports in ...more >>

Hi, I'm trying to use mdx query in reporting services with a parameters. But I am getting an error telling me my token is invalid my query string is this: SELECT NON EMPTY { [Measures].[Executions] } ON COLUMNS, NON EMPTY { Members("[Dates].[All Dates].[" + @Year + "]." + "[June]") } DIMEN...more >>

Howdy, I'm generating a series of RDL reports using Python and Cheetah. It seems to work great with one, huge problem: when I go to view the reports in Visual Studio or when they're deployed, the report elements overlap or are out of order. Is there any non-absolute way to position elements...more >>

Hello, Generally when using the Report Wizard with MS SQL 2005 it wants to present the data horizontally, like this: Item 1 Item2 Item3 Item4 Item5 Value1a Value2a Value3a Value4a Value5a Value1b Value2b Value3b Value4b Value5b .... and so fo...more >>

Hi, I'm using RS 2003, and I'm having very strange results with borders on the table object. In order to get a grid-type table, I went in and turned on all the borders for the rows and cells (what a pain). The grid looks fine in the view, but when I print the report, the data doesn't pr...more >>

I created reports and deployed but i am not able to see on IE my RS folders I used this path and also i used instead of localhost i used my machine name; http://localhost/reports$SQL2005/Pages/Folder.aspx I checked IIS and RS, it's running. Also i stoped and start again. It still not workin...more >>

I have an image in my page header which is defined by a url in a hidden textbox in the body. My report is long and I've not included any hard page breaking. It automatically creates a new page with header and footer in the report viewer. My problem is that the image is blank on the 2nd and ...more >>

So this is probably a simple problem but I can't figure it out. I want to setup a table that stores each parameter in it's own column. This way the user can store their settings for use later. One parameter is multi-value and I'm trying to insert it into a varchar() column but it's not work...more >>

When I am looking at a dataset and use the "!" execute button I get the pop up dialog box for parameters. How must I enter my values if i want it to test multi-value selection? I've tried ABC, DEF 'ABC,DEF' 'ABC','DEF' "ABC","DEF" ABC;DEF 'ABC';'DEF' I can't get it to work. Can...more >>

Greetings! I have a situation that has stumped me and my co-workers. We are trying to create an ad-hoc reporting environment for Application users (users with only an application log in, no AD or SQL Server logins) and provide user-level security. Further, we really have to use Shared Dat...more >>

I'm stumped, i've notice a couple have had this issue on this group, have anyone had success in solving it. Basically when I attempt to deploy to a remote server I'm propted to login to SRS located at http://<servername>/reports no amount of credentials sent work. I've checked IIS and ...more >>

I have a vb.net winform application and have a report present an sql2005 query whose results are stored in a dataset. I have two problems with the report. 1. If I have any null values in my fields, than the entire row will be missing from the report. In order to get the data to show, I n...more >>

I am writing a report is SRS 2005. The report is a quote report with a two row header. Row 1 has the product description, row 2 has a memo field. Here's my question--is it possible to somehow join these two rows so SRS will not break the page between these two rows? Grouping doesn't do it. ...more >>

The subject pretty much says it all. I am trying to schedule a report for delivery every monring via emil -- normally this is pretty easy, however I cannot seem to find a way to do it with reports built using the ReportBuilder. I can run the report without issue, howevever when I try to sc...more >>

Hi, I am developing a web application on windows XP. A page within my application needs to access to SSRS running on the same machine. Once the web application tries to consume the SSRS web services, I receive the following error: System.Web.Services.Protocols.SoapException: The permissi...more >>

Hi, I am looking for a tool/application that can be used by users to select and filter reports. The report list and field list would be pulled from a database along with field type, and query to use to populate drop down list filters. User would select the report they want from a drop d...more >>

Hi, I am running SQL Server 2000 SP4 on Windows Server 2003 and IIS Server 6.0 on the same machine. I have a SQL Server 2000 installation CD. I don't find Reporting Services included in that CD. From where can I get the Reporting Services component? Thanks in advance....more >>

When exporting a report, the file name is defaulted to the name of the RDL file for the report. Is there any way to change that to default to a value in a textbox in the report? Stephanie...more >>

How can I set today as default parameter into a report? I need to set this value as default because it's necessary for allowing users to subscribe to the report....more >>

Hi, I want to display numeric information by month in a column chart. The data does not have records for every month. I can't seem to display all months along the x axis while still using month names instead of month numbers. My current chart setup is as follows: Data > Category group ...more >>

Hi all, I'd like to get a report on the reports that are deployed. It would tell me things like this: Report Name DataSourceName Connection String Stored Procedures Called ...more >>