Installed Service Pack 2 and now don't have a chart control in the report items toolbox...more >>

Hi, I cannot install MSRS , I get this error , yellow !!! "IIS is either not insalled or not configured for a server component installation" I have run aspnet_regiis, but still not use. I have IIS running perfect with other apps, WSS, etc., on W2003Svr Default web site http://localhos...more >>

Help!! I am trying to install Reporting Services onto our Windows Server 2003 machine which has SQL Server Developer Edition 8.00.760(SP3) installed. I keep getting the message "Thid edition of the Report Server Database is not supported on the edition of SQL Server 2000 you have chosen. ...more >>

Hi, I have a DataSet that returns only one row. I need to use that row on the page header; however the designer gives me this error: The value expression for the textbox 'FullName' refers to a field. Fields cannot be used in page headers or footers. Is there any workaround for my req...more >>

I have a text box on my report that gets populated from the database with a comment. If there is no comment entered then I don't want the textbox to display and the space that it takes up to close up. ie: its for a letter so very important that this gap disappears. any help would be grea...more >>

I am having trouble getting answers to this......Are there any converters other than RDL Generator from Hitachi or rpttoSQL that will convert rpt files to rdl files? Those of you that have migrated from Crystal to MSRS, could you please enlighten me on how you accomplished this? Thanks...more >>

HI, I have a matrix and data should look like this The row groups are Office(Mayor)and county(A and B)and votecount(Total). The Column groups are Party and Candidate. Then I have a subtotal on office group. Any suggestions how can I achieve this in my report? Mayor De...more >>

Is there a way to install SP2 of Reporting Services without rebooting? The Reporting Services installation is on a mission critical box and rebooting would cause issues. Is there a route, such as shutting down reporting services that would allow SP2 to take full effect? OR -- what brought...more >>

I have the following statement being used in the Jump to command. = "javascript:void(window.open('" & http://domainname/ReferralForm.aspx?ReferralID= "& Fields!REF_ID.Value & ','_blank'))" When I try to preview the report, I get the following error in the task list The hyperlink expre...more >>

here is a picture of my report http://www.rakbiz.com/download/ktla.jpg I am trying to figure out a way to print just the 4 records below the 9:19 block, any ideas on how to go about this...I have not seen anything that seemed like it would work... Thanks for your help! -R...more >>

We have a situation where we are going to have our IIS server with two NIC cards. One for the internet and one for the intranet. We are planning to have our SQL Server connected to the IIS server via the intranet. My question is.... if a user on the internet requests a report and we render ...more >>

I need a parameter with the following options: current week last week current month current quarter I have a dataset with today, monday of current week, current quarter number and current month number, but i'm at a loss as to how to tie this in with my report and how to put it into a pa...more >>

I wish I could set a global value on my project so this one value could be used by each of my reports. Is it possible? ...more >>

I have a report which has the hidden/drilldown feature enabled when the report is opened. The problem, visually, that I am having, is that the next group's spaces are visible both on the rendered web page and the preview pane in the Visual Studio. Does anyone know of a way to "collapse" the ...more >>

I have a report that groups information by employee. When the report is first rendered on the server (i.e. HTML format) the data flows over to a 2nd page for this person. The 2nd page does not have the header defined so there is no way to tell which employee this is for. One if the solutions i...more >>

Recently as part of the process of upgrading to RS SP2 I followed the normal procedure to export my crypto keys. Unfortunately instead of providing me with the key file, it gave me an "External component has thrown an exception" message on the console. At the same time the RS service shut itse...more >>

How can I determine what version of service pack for reporting services is installed on our servers? I would deeply appreciate step by step instructions. TIA......more >>

I want my report to launch with one Report Parameter that calls a dataset (stored procedure that needs to execute with query parameter read from the querystring. My procedures works fine from within VS.Net Here's the code I use to I launch my report from my ASPX page: http://tawldevt/Rep...more >>

I have two parameters for my report, one for choosing column to sort and the other for choosing direction(Ascending or Descending). In my tables property i use "=Fields(Parameters!MySortVariable.Value).Value" in Sort on: Expression. But how do I use my variable for direction? (I can't put an e...more >>

Multiple Questions on deploying a bulk insertion script file for inserting reports into reporting services. The script provided by MSDN PublishReports is really straight forward with some exceptions or at least for me. How can I ensure that the Data connection that is added in the script get...more >>

We have installed SP2 and client-side printing from the browser is working fine for our users on XP/IE6. However, we have some users with NT4/IE6 on their machines. They are able to view reports, but when they click the Print icon, nothing happens (no error, no prompt, nothing). Is the Ac...more >>

Hi I am trying to create a file share subscription for a report. I have specified a valid unc path for the file. When the schedule is run ny SQL Agent, it returns the following error: "Failure writing file Depth Distribution : The Report Server has encountered a configuration error; mor...more >>

If anyone can offer some suggestions for fixing this, I would be really grateful. I have a web page that shows reports a user can select. The rendering format I use is PDF. When the user chooses to view the report for the first time, they get an Adobe error message saying "There was an erro...more >>

Good day, I have a table in SQL that I am reporting on. It contains a few different fields. One of them is the running total for the month. What I need is a report that shows both this running total field as well as each days value. Each days values can be calculated by taking day 1's runni...more >>

Hi when I run a report in the "preview" tab the report run well whereas running it via the "play" button or writing the URL i get the follow error: "An error has occurred during report processing. (rsProcessingAborted) Get Online Help Query execution failed for data set 'DataSet1'. (rsErrorEx...more >>

Hi all, I have some dates in a recordset in english format dd/mm/yyyy If the date returned is 1st Jan of any year then i just want the year to be displayed. i.e date returned = 1/1/2000 i just want to display the year so... (yyyy) if the date is 1/3/2000 then return the whole date I...more >>

Hi, There is a problem with subscription scheduling in RS: My settings: -Monthly Schedule -Months: Jan Apr Jul Oct -On calendar day(s): 1 Despite this settings RS sent this report on 1 May TIA, Kamel ...more >>

HI, I've installed MS SQL Server 2000 Reporting Services evaluation on my workstation with XP in order to try the reports made for Navision. I keep getting an error during the System Prerequisites Check: 'ASP.NET is not installed or is not registrered with your web server'. I've both AS...more >>

Hi! We are currently using a different third party tool to print out pdf-files generated from SQL Server 2000 Reporting Services. We are a fairly large international cooperation and have a centralized citrix it environment with different band width to different places in the world. This makes...more >>

I have installed RS on a Windows 2003 Server. However, we prefer to use VB .NET on a Windows 2000 workstation as Report Designer. We would like to know what component of Reporting Services has to be installed on that Windows 2000 workstation after installing VB.NET ? Thanks...more >>

Hi, How can I have a report header (not page header) for my report ? Thanks, Alan ...more >>

Hi I've seen someone make a post about this before, but I'm having exactly the same problem. When logged in as an administrator for the domain Client Side Printing works fine. When logged in as a standard domain user the ActiveX component installs, the print dialogue is displayed but ...more >>

Hi, I have a HTML tags inside on of my dataset's fields. Is there anyway that I have the contents of the field rendered on the report? Can I at least extract the pure text from the HTML tags and show them on the report? Thank you, Alan ...more >>

Hello, I hope someone can help me, but I am getting this error only after I installed the beta 2 of .Net 2. The message is: a.. Failed to load expression host assembly. Details: StrongName cannot have an empty string for the assembly name. (rsProcessingError) Get Online Help Has anyo...more >>

Hi, Which reporting tools of the market today support RDL I mean if I make a report in RDL which reporting tools will be able to understand the report that is made in RDL and render it? This is extreamly important for us to know. We need to decided on, in which format should our own reports b...more >>