Hello, I've been using reporting services on and off for about 6 months and I have only recently encountered this error. I have a relatively simple report (no sub reports or objects nested in table cells, etc) that apparently runs fine that I can export to any other format with no problems...more >>

Hi I've about had it trying to mix WSS and report server so I'd like to create a new virtual server and put report server on it. Do I have to reinstall the whole thing or can I just move it? TIA Bill ...more >>

I'm trying to install the Dev version of Reporting Services (RS) on one box and have it use an Sql Server 2000 (w/SP3) instance on another box. Both the RS and SqlServer boxes are Windows 2000 Servers. Neither are part of a "windows domain"---neither will they ever be. We only connect to Sq...more >>

What I'm wanting to do is create a report which allows you to sort by a few different columns, and also choose if you want it sorted ASC or DESC. Basically, I'll have two parameters.... 1) OrderBy (a number of different columns) 2) OrderDirection (ASC or DESC) and I'll want to do a SELE...more >>

Hi, Help, I am having trouble getting SQL Server 2000 Reporting Services to work on my laptop computer. I have gotten it to work in office/development environments several times, so it's not just beginner cluelessness. Installing onto Windows XP professional, 384 MB RAM, SQL Server 2000 Deve...more >>

I have structure like this: A1 B1 C11 C12 C13 B2 C21 C22 A2 Currently, I set up so at C level, it will appear only if its value > 0. I would like to have a drilldown structure so when I click on A level, B level will appear but no...more >>

I have a textbox with the following expression: =IIF(INSTR( Fields!EvaluationRelatedInfo.Value ,"01$" ) > 0,SUBSTR( Fields!EvaluationRelatedInfo.Value,(INSTR( Fields!EvaluationRelatedInfo.Value ,"01$" )+3),INSTR( Fields!EvaluationRelatedInfo.Value ,"01#" )-INSTR( Fields!EvaluationRelatedInf...more >>

I have couple of reports on email subscription. These are exception reports that get delivered if there are records in the report. The question is that an empty report gets delivered if there are no records. Is there any way to stop email delivery on a subscription when no data is returned in ...more >>

Hello, What I am trying to accomplish is that user clicks on a link and the report renders on a new web page. I do not want anything other than the report, that is I would like to hide the sections for parameters and export/zoom etc. options. Is there a parameter I can pass to the report...more >>

Is there a way to extend the report manager interface so that we can = copy reports from one folder to another instead of moving them? We have = several locations that are defined by folders with shared datasource for = each location in their folder. When we create a report it would be nice = to...more >>

I cant install the reports seerver on the same machine than the database server. What can I do? I need database on one server and pages on another server. I just cant open web server service on the database server. Please helpme. Thanks -- LUIS ESTEBAN VALENCIA MICROSOFT DCE 3. MIE...more >>

Hi all. i have developed report to print statistics of each department. i can view each dept at a time passing report parameter is there any way that i can get a report with all departments at a time in single report one after the other. Thanks Vamsi ...more >>

Does anyone know when sp2 is coming out ? We are really desperate to start using it, because of the printing improvements -- it is too risky to start using the beta for a production site in the meantime ? Thanks, Craig...more >>

I have been using reporting services for about 1 1/2 months, developing reports in VS2003. I have noticed that my changes don't get saved within the IDE (I have to go out to notepad and edit the XML), as well as locking up when changing the SQL statement in the report enviroment data windo...more >>

I have a report containing a subreport. The subreport needs a key field called billno. Works great. However, I also need to pull the main report by date range. As soon as I add the parameters @BEG and @END in the main report and dataset, I get: The report parameter ‘MOPS_BILLNO2’ has...more >>

I'd like to force a subscription to run in an adhoc fashion using the web service provided. Is this possible? If not, does anyone know a work around to make this happen?...more >>

I recently installed Reporting Services on a web server, Managed to get https://<secureServerName>/reportserver to load correctly but am unable to get reports to display the home page. After authentication I get a 401 error Authorization Required. Does anyone know how to correct this issue?...more >>

I have a resource domain and a user domain in my facility. The user = domain uses an outside secure SMTP server for email. Is there a way to = set the RS to use this server and pass the auth credentials needed? I = have tried to configure the IIS SMTP server to deliver the reports but I = can't ...more >>

I have my email set up and it works fine when I email the link, however when I try to include the report in the email I get the following error message. Failure sending mail: An internal error occurred on the report server. See the error log for more details. Is this a set up issue? Thanks....more >>

I have been creating subscriptions for several different reports and I am noticing that for most of the reports I can create the subscription fine, but then there are some where my subscription will time our while I am trying to create it. What could be causing this? Is there a timeout setti...more >>

I have a report that consists of a chart and a subreport. The chart is a bar graph, and I would like the users to be able to click on bars in the bar graph in order to change the content of the subreport. The subreport takes a parameter that is the data value of the bar graph. I can mak...more >>

I tried to ask this question a couple of days ago but I don’t think it came out right so I didn’t get the response I was hoping for. I’ll try to word my question better this time. I want to sum totals based on group levels. (i.e. total by group and grand total) For example - My dat...more >>

Is it possible to schedule the delivery of a report (to a file share say) for each possible value of a parameter? So, if I have a report that accepts a value for parameter @color and shows the corresponding tshirts in that color, and there are 3 possible values for @color (red, green, blue), c...more >>

Hi, I have a report which contains 3 different charts. What I need to do is have all 3 of the chart names in the Document and only 1 chart showing at a time. The users can then click on a different chart name in the Document Map to view a different chart. Is this possible and any suggest...more >>

Hi, I need to save a report on the server after redering it in PDF Format, so that I can mail it to that particular user. How to do this. Thanks Kiran ...more >>