I have downloaded SP2 6 times, on 3 different servers (2 - windows 2003, 1 - windows 2000 pro) and each time I try to run the executable to extract the files, I get a "Extraction Failed" window which says the "File is corrupt". What am I doing wrong??? Some firewall problem??? I just downl...more >>

A user informed me they created their own report and put it in their 'My Reports' folder. They asked me to take a look at it but I reallized I couldn't find a way to get access to it. When searching for the .rdl file on the server, I found from another posting on here that the files are stored...more >>

I need some suggestions on how to provide column level security within RS. This there a function or Global/User that provides the roles the current user belongs to? If the roles are accessible within the code script, I thought I could pass it to an external assembly to perform validation che...more >>

I am running RS on a W2K3 server. I have a report setup with a datasource to use sql security. When I try to run the report from the server or from a client I get a login failed for user "userid" I am not sure what to check and have been toying with this for 3 days now. I would appreciate a...more >>

Hello, I am trying to get my report to render on the Report Server, but it fails to do so. I am able to see that the report is generating, but after a period of 30 or more minutes, the same image is displayed on the screen. I know, for sure, that the query that is grabbing the data takes ab...more >>

Hello, I'm trying to setup MS SQL Server 2005 June CTP. Everything seemed to be fine except Reporting Services failed to install, blow is the Setup Log with the section that has the relavent failure: CreateAspApp: start time: 11:44:01 CreateAspApp: CustomActionData: /LM/W3SVC/1/Root/...more >>

The following will return the current login user's name through the Report Services Properties Code tab: 'Get the current login user's name Dim strCurrentUser As String Dim ident As System.Security.Principal.WindowsIdentity = System.Security.Principal.WindowsIdentity.GetCur...more >>

I have many columns out to the right. The name column is the first column in the report. I wan to "freeze" the name column so that when you scroll to the right in the report the name column is still visible. From this forum i learn that freeze headers isn't available until RS 2005. Is this ...more >>

I am new to SQL Reporting Service. I have VS.Net 2003 and IIS installed on one Computer running Windows 2000 Pro (computer #1) and SQL Server Enterprise installed on a Window Server 2003 (computer #2). When I try to install SQL RS Enterprise on computer #1, the error occurs at the step in th...more >>

Is there a function to lookup a row in a dataset? Say, find the row where column x is equal to 10? Find(Fields!ProductNumber.Value, 10, "Category") -- McGeeky http://mcgeeky.blogspot.com ...more >>

Hi, I have a table with a field called Period whcih has numbers from 1 - 12. Now I want to say that if the value of the field is 1 , then the report should display january, if its 2 , Feburary and so on... Is there a way this can be done without having to create a table ? -- pmud...more >>

Is it possible to have conditional subtotals in Matrix? Let's say I wan't to show subtotals only if number of detail rows greater than 1. -- Thanks, ID...more >>

I can't adjust the layout size down from 13.875 inches. I've checked the properties of the report, and the width is no greater than 11 inches. What can I do to change the layout width for the header, body and footer? Thanks in advance...more >>

I'm unable to deploy using Visual Studio and would like to upload my files manually. I've searched the web server for the existing files and can't find them. I also searched books online. Any ideas? Thanks...more >>

Hello! I have a problem working with parameters in procedures. A procedure return a integer value and I fill a TextBox with this value. Now, I needs call a another procedure passing the value returned by first procedure (this value is on textbox). How I can make this? I need pass the te...more >>

Hi, I've tried to get this to work, and I can't! I have no problem generating the report, but its opening in my main window. I want it to open in a new window. I have a Pushbutton (asp.net) which calls the RS webservice to render the report, but how can I get the thing to open in a new wi...more >>

Is there any way to leave certain sections intact and only explode designated slices? For example, I'm charting order delivery performance. I have several different series groups (# of shipments in the following groups:Early, On Time, 1day late, 2 days late....etc). I want to keep the "Earl...more >>

Hi all, I created a Data Processing Extension for Reporting Services which accepts a XML string as the Command Text and returns a dataset according to information contained in this XML string. Here is a sample : <Extract> <Table>Users</Table> <Fields> <Field>UserID</Field> ...more >>

The site is working, all of the reports run, but all of the navigation drops the https navigation to http links which will not render the application. Does anyone know where I missed the https to configure as a secure application? ...more >>

I am new to Reporting Services and I need to kno how to add todays date to my reports. Thanks...more >>

Is it possible to have multiple scales in a chart? if not is their a formula for getting all the values in the chart to show up as big as possible? ...more >>

Hello I want to edit my visibility of a table depending on the number of rows it has. i.e if there are no rows present I want to display a message instead, so make the table invisble and make the message visible. Is this possible if so how do I do it, my gues would be to count the number of r...more >>

When my table cells have the TextAlign set to Left, some times the first part of the first character gets cut off. Letters Like 'A', 'W' and numbers like '6' and '8' all have the first few pixels on the left trimmed/cut off like the value is being pushed out of the visible are to the left. ...more >>

Morning All, Does anyone know how to pick more than one item from a pick list (drop down box.) E.g if I had the months of the year in the pick list how could I select Jan and Feb?? Any ideas greatfully recieved. Regards Munish -- Technical Data Analyst Hammersmith & W London College...more >>

As a new person to SQL RS, With the report date parameters, can you have a date control to choose from the calendar? ...more >>

My date is being returned as mm/dd/yyyy - how do I format this to be dd/mm/yyyy. My region setting are UK. Thanks ...more >>