I am having problems setting up RS 2000. The problem is that the users can not process any reports, only the Administrator can. Using SQL Server 2000 Standard, IIS 6, and Windows Server 2003. Any assistance is appreciated. Fabian Here is the error message: Reporting Services Error ...more >>

Does the 2005 management studio work with SQL 2000 Reporting services or just version 2005? If it does work, how would I connect to a report server?...more >>

I need to place on my report "Page # of #". How do I do this as Im unsure of the number of pages my report will be. Also have a problem with getting my header details for each report to show on every page. Have a Name for report, then the start and end dates and a logo. Haven't put them ...more >>

Hello, I am experiencing some funky (yes, that is a technical term) behavior with SSRS 2005 Report Builder. I have a model setup with some of the fields set to have their DiscourageGrouping property equal to True and some with it to False. It seems that only SOMETIMES, when I add the fiel...more >>

SQL Server 2005. Per MS docs, SSIS should be in the list of available Types for a Data Source, but it's not there. SSIS is enabled on the server, and SSIS extension is not commented in rsreportserver.config. Any ideas? -- Thanks, Leo...more >>

Expert Needed, Is it possible to pass credentials from a .NET application into MS reporting services? For example we want to filter our data for our reports based on the user's login into the .NET app. Thank you in advance. Rich ...more >>

We setting up an intratnet site that is generating PDF output from Reporting Services 2005. The WWW Server for the applications is on ServerA The SQL Server & Reporting Services are on ServerB From ServerA we are generating a HTTP request to the Reporting Services to generate the report. T...more >>

I need to navigate to a drilldown report with multivalued parameters. I need to deal with: a) Passing a single value from "parent report" to a "child report" multivalued parameter (mvpar): I tried e.g. Fields!Division.Value and Fields!Division.Uniquename to no avail. b) Passing multiple val...more >>

Hello all: I need to open a new RS report from an existing RS report when the user selects a distinct week # field. I realize I right click the field / Properties / Advanced / Navigation I believe I need to use the jump to URL. I suspect I need a java script to create the new window with th...more >>

I want to control the names of available rendering formats displayed to user (e.g., "Default (HTML)" intead of "web page for IE 5.0 or later"). BOL has a great example (well, except it is bad XML) : <Render> <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRen...more >>

Is it possible to create reports in SQL Server 2005 Reporting Services against OLAP cubes based on Analysis Services 2000? Any limitations? Any things I should know about? I've tried to upload a report made in the SQL Server 2005 Business Intelligence Management Studio to a 2000 edition Report...more >>

I am running SQL Server 2000 Developer Edition on my desktop with Win XP SP2. I am developing a database for distribution to a customer. Everything works OK. Now, I need my database to print a report using data from the db. I just installed Visual Basic.net 2003 and am now installing Rep...more >>

The report subscription is returning the following error message. How should I resolve this issue? However, according to the Job executed, the process was successful but the report manager is displaying the following. ERROR: Failure sending mail: The report server has encountered a conf...more >>

I am trying to create a data driven subscription. However, on the Subscriptions tab for the reports the New Data-Driven Subscription selection is not present. Only the New Subscription selection is present. I can create regular subscriptions but need to create a data driven subscription. ...more >>

I am creating a bar chart which contains a category for days of the week and various values for data. I need to add a total bar that sums values for the week. Total is not available from the dataset and the category, which is a field from the dataset doesn't have a value for total either. Has ...more >>

Hi, Is it possible to configure Reporting Services 2005 so that the same report will apply different data filters depending on the user running the report ? i.e A German user will only see German data and an English user will only see English data even if they enter a parameter for 'All Eu...more >>

Hi, I found that the standard CSV output format of RS 2000 doesn't create the ASCII format, which leads to the issue that EXCEL doesn't show the information in the different columns (everything is stored in the first column). I know it's possible to call the renderer via URL its Format=CSV...more >>

Can I create a report using RS, and than, using the Office Excel Add-In for SQL Analysis(or ant other way) to import that report (not export using the RS), and refresh the data? The only thing I found regarding Excel Add-In and RS is the Add-In's ability to expose(using the Functions) repor...more >>

I am getting the following error when attempting to do the Forms Authentication Sample: I get the error when I run the http://localhost/Reports/ url. Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web r...more >>

How can I get the list of reports that a user has only view reports access ? the user is in windows server 2003 active directory. reporting services 2000 is being used. within the intranet there is a portal. in the portal I want to list the available reports to the user that he can access....more >>

Hi, We are rolling out an SSRS 2005 reporting Proof of Concept; the executive sponsors are happy with one major exception that could be a deal killer - the way it auto-scrolls when you click a + sign to drill down. It makes the page looks like it's jumping and one loses context. Is there a w...more >>

I created a report that uses data from an external SQL Server database. I specified Windows Authentication. My NT account has full rights on the external SQL server. When I run a report with ''localhost'' in the URL, it works fine. However, when I use the actual server name, it first prompts m...more >>

Hi, Anyone have a link to any instructions on how to customize the RS Home page? I'd like the change the bolded 'Home' text with our company's name. Thanks Jerry ...more >>

I have a snapshot scheduled to be generated daily with a subscription attached to email the result. This morning the snapshot was generated but the email wasn't sent. The only anomoly I could find was the following message in the Reporting Services log. However, there was no system event ...more >>

Hi, I would like to know how can I deploy a report model programatically in SQL server 2005? Or if there is any other way to distribute report models. Thanks in advance, Nirav...more >>

Does RS have any function that would enable me to convert multiple rows into a comma-delimited string? My report is very long due to multiple instances of a child record that is represented by a single word. If I could append the column values it would significantly compress the report. Exampl...more >>

Hi, Has anyone tried to limit access to Report Designer only? We have report developers that can't have access to Integration Services, Analysis Services, Report Models, etc. What files or directories can we remove to limit their access? Thanks for your help!...more >>

Hi, I've created two seperate folders under the RS Home page - 1. Accounting 2. Human Resources. I've set the approiate Windows group permissions for each folder. When I have someone from HR connect to RS, the user gets the home page without the Human Resources folder. Do I need to gra...more >>

Hi all, I have a Visual Studio 2003 Reporting Service project that connects to a MySQL 4.1 database using an ODBC connection. I have been playing around with the dataset for a while, and I have this query in the SQL pane of the Data tab: SELECT id, boardFirstName, boardLastName, A...more >>

How do I pass Device Information Settings when exporting a report to Excel? The documentation explains how to do this by URL, and by using the Render method, but I would like to continue to use the Export link on the default toolbar. I need to specify the RemoveSpace setting - I'm hoping thi...more >>

Can you create Generic Report Templates with Reporting Services? My problem is I need to create report templates that will be influenced by external data. A report template would be generic and the external data would influence the data to display. There would be some logic involved to r...more >>

I'm running SQL Server 2005 RTM on my laptop (Dell Latitude D810) but cannot connect to Reporting Services Server. When I try to connect to it using SQL Server Management Studio (using windows authentication) I get the following Error message... TITLE: Connect to Server ------------------...more >>

Hi, I'm using SQL Server 2005 Reporting Services and Visual Studio 2005. I'm just wondering if I can add parameters to a report with the Report Builder or is this facility only available in the VS2005 report editor? If it's possible what are the steps I need to follow? Alternatively...more >>

New to Reporting Services. I have written a stored procedure which I call from a report built with RS. Certain parameters being passed to the procedure does not materialize a record set, therefore, the report comes up blank, with no labels etc. What I need to do is detect an empty record set,...more >>

How can a report access the Request.ServerVariables collection? What we are trying to do is customize a piece of the report (through an if statement) depending on one of the values in the ServerVariables collection, and if we create a custom assembly, it doesn't have access to the Request obj...more >>

What value does report parameter take when it is empty, that is if nothing filled in the report parameter value? I tried with <Select a Value> but its not accepting it. Regards, Navin.D...more >>

I have this very weird problem arising when I try to use the following function in Reporting Services 2000: IIf ( 4=4 , 0 , 4/0) - Displays #Error IIf ( 4=4 , 0 , 4/1) - Displays 0 Can somone please explain why this occurs and any work around for it. In the Actual scenario I'm doing somethi...more >>

Hi, when I switch my reportserver virtual folder to the ASp.net2.0 I receive this error: "Failed to load expression host assembly" this error appears only when I try to render a report, I can list reports or I can access the webservice without any error. any solution? thanks. Jer...more >>

I'm trying to create some reports based on an OLAP cube. Creating a simple MDX based report is a breeze with the new report builder, but I haven't figured out how to optimize things. Like using descendants instead of where etc. If I just add a pre-made MDX statement, I loose the Fields in the ...more >>

First, let me say that I am trying to use Server Reports with the Winform Report Viewer. This is a technique I used heavily in Crystal. It allowed me to build the reports against the development servers (Web & SQL), and copy the report files to one or more production servers, where the con...more >>

Has anyone used Reporting Services with a map of USA with the States outlined? Here's what I am trying to do ... I have data that counts inventory at each Store across the USA. I want to sum the Store data by State. And then display that information in a USA States map .... changing the color...more >>

Hello, I'm new to Reporting Services 2005, so I'm not sure if what I'm asking is possible. What I need to do is replace a certain value in a report with an image. For example, the values in a given column will either be -1, 0 or 1. What I need to do is replace that value with a specific gra...more >>

When I open reports from the ReportManager, the parameter list and the reporting toolbar seem to be missing the normal style, and I get an "unable to connect to the remote server The attempted operation is not supported for the type of object referenced" error. I can successfully execute ...more >>

Hi, i want to publish some reports with Reporting Services for my customers, but RS need windows authentication and my customers dont will be in the active directory, how can i use impersonate with RS? Thanks...more >>

Hello, I'm having trouble finding a site with basic introduction to SQL Reporting Services. I'm using the VS.nET reporting services IDE to build some reports and I have a few questions. How do I SUM two "report items" on my report? Like textbox12.value + textbox13.value. I know how to do...more >>

Hello: I have a report successfully running on SQL RS 2000. This report uses a custom assembly developed using VS 2003 to evaluate a report expression. The assembly has references to Microsoft.ReportingServices.Processing.dll in SQL RS 2000. Now I am trying to migrate this report to SQL RS ...more >>

I have a query that returns 71,000 rows. When I run it in query analyzer it takes 11 seconds to execute and return all records. In reporting services I came up with a report designed just to have the data eported to excel. It seems to just take forever and then time out. Has anyone exper...more >>

how can i format a phone number to be displayed as follows in the report (678) 444-4444 Thanks! ...more >>

Hi, I'm trying to reference a custom assembly from an RDLC in a web application and, eventually, managed to get it to work. It required signing the assembly and deploying it to the GAC before the ReportViewer control could find and load the assembly, with ExecuteReportInCurrentAppDomain() a...more >>

I have a report with only two parameters input by user @startdate and @enddate. On my Subreport I use the same parameters. How can I make the subreport run by taking the user input on the main report and passing it to the subreport so it can run too. Any help is appreciated. Thanks...more >>