I need to dynamically name the axes of a chart as the data plotted can be changed - Sliced. Ie. Sales dollars, Quantity, Profit etc. The dataset that is used to plot the graph does not contain the measure description (it's a generic name - MeasureModifier). There is a second data set that contains ...more >>

Hi, Could somebody please point me in the right direction in how to add a url-based image to my report. I have installed RS service pack 1. Cheers Kevin...more >>

In one of my reports I am showing another report when the user clicks on one of the items that come from the report. But it opens in the same window. Can I open the new report as a pop up in a new window so that the user does not loose the earlier report. ...more >>

The main problem in the report is that it works fine in the development environment, I mean when I run it in the VS.net editor. But when I deploy it and run it in the browser, the drilldown functionality is not working. The problem doesnot remain, after I export the report to any of the provided f...more >>

Hi, Folks. I have a "List" report which contains a "Table"-style subreport. I'd like to display the table, WITH the headers, as the subreport ONLY IF there are some elements to be displayed within the table. In many cases, there will be no data in the subreport. I'd like to suppress the ent...more >>

Hi: I have to define several style guidelines to build a set of reports with the same visual styles. I want my reports to have tables and I want the odd rows WHITE and the even rows RED (by example)... how can I do this kind of thing? About the deployment of my styles: I have to configure...more >>

Hi, My SQL syntax like follow... Select A,B,C From XYZ Where (A in (@Aparameter) or @Aparameter='') During preview the report, I enter A's value 2004 into Parameter textbox, I can get correct result.. But, when I want to enter more than one values, like 2003,2004 in A's parameter textbox...more >>

Is there any samples to download that show how to create matrix report that link to microsoft sql server 2000 analysis services? I understand that user can use the mdx query (Analysis Services) to generate a report..But is there an easy way just link to datasource (cube) that is created in analys...more >>

My report has some chinese. It can be display by IE, but when I export it as PDF, the chinese words are displayed by "?????" in PDF file. I don't know how to handle it. ...more >>

Hi eb Is there a way to use the calander component to allow user select a date parameter for a report ?? TIA Rea ...more >>

I would like to hide a header row on page one and only display it on the consecutive pages. Since I can't refer to the global page number variable, I can't think of any way to accomplish this. Basically, my end result is that I want to have a report header that contains a bold graphic and oth...more >>

Hi, When running the following query "select TIMEDIFF('2004-04-28 04:11:00', '2004-04-28 04:58:00')" from Report Server connecting to MySQL 4.1 (using MySQL ODBC 3.51) returns 00:00:00. I ran the same query from MySQL gets the correct result -00:47:00. Why is that? Your input is appreciated...more >>

I have RS Standard, and SQL Standard installed on Win2k domain controller. I did the fix in the KB to allow impersonation etc. and I can now run the sample reports when I'm logged in on the domain (but I have administrator rights). All other users get a 401 error when trying to access htttp://<s...more >>

I have a fairly simple report, one table with 5 columns. However, when I add a group to the report, the following error message occurs when previewing the report: An unexpected error occured in Report Processing. Exception of type System.StackOverflowException was thrown. I have another repo...more >>

How can I get the data to appear on the header of every page on my report. I know Report services do not allow it but it there a way to do this? Thanks....more >>

I created a report from VS.Net with 2 parameters (@site_id and @year) supplied to the stored procedure, I can preview the report fine w/i VS.net and can also run it from Report Manager. However, when try to run the report using ReportViewer control (the control came with SQL Server Reporting Servi...more >>

Hi. I created a new subscription with an associated schedule. When I look in the Report Manager in the Subscription Processing Options section I see a nice, human readable description such as "At 2:15 PM every Thu of every week, starting 7/1/2004." Is this text stored anywhere in the Subscription...more >>

HI everybody, my problem is that when i export to a pdf file i get on first page cut of info and the second page I just get a header and footer. Is there anything to do to fix this problem...more >>

Let's say I have three cascading parameters. I make the selections in P1, P2, P3. Now I change the selection in P2 in the next round. Is there a way to 'remember' the previously selected parameter value - somewhere... anywhere...??...more >>

I export the report output to PDF using WebService (using Webservice.Render). Is there a way to adjust the PDF margin at run time? Thanks....more >>

I have a report that is running extremely slowly. The Reporting Services log files seem to generate 9MB of errors each time I run the report. The error is the text below repeated over and over. Can anyone help? Thanks, Burt <Header> <Product>Microsoft SQL Server Reporting Services Ver...more >>

I have two sets of cascading parameters. P1, P2, and SP1, SP2 P2 is dependent on P1 SP2 is dependent on SP1 They are all query based for Value and Default. The whole thing works great... ! However - If I select SP1 and SP2. And then select P1 and P2. Then again go back and chan...more >>

I'm not asking a question, I want to merely post a resolution to a problem I encountered in an effort to help anyone else that has this issue. Also, hopefully MS will see this post and use it to fix future service packs. I installed SP1 on my web server and after "Installation Successful", I ...more >>

Why does this windows sevice fails in attempt to turn on? but when i access the rs manager all is fine. when i query the reportservice.asmx?wsdl all is fine. i access via a seperate app all is fine. i'm puzzled. ...more >>

We applied SP1 and now are getting the following error: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.6.51'. The expected version is 'C.0.6.43'. To continue, update the version of the report server database an...more >>

Hi, I am trying to export my report to Excel.When I do this I get some extra columns(blank though) in the Excel sheet which r not there in my report.And I see some greentips in some of my cells in excel sheet(which is a warning that a number is exported as text).Why r this due to?How can i remov...more >>

I'm trying to link a drill through report based on a text box that is derived from a "Switch" function. I only want the drill through capability if the source for the textbox is a certain field from my dataset. ex: =Switch( Parameters!SummaryBy.Value = "Division", Fields!BranchDivision.Value ...more >>

I keep getting this "the request failed with http status 401: Unauthorized." error when i access the web app from a client machine. my configuration: client - client1 asp.net app - dev1 rs server/db - dev2 sql db - dev3 i'm using nt authentication the following vb.net code is used for cr...more >>

I am encountering error while creating a report using SQL with # temporary tables. Here's a sample code using the Adventureworks database: CREATE TABLE #PRODUCTDETAILS( [WEIGHT] [FLOAT] NULL , [PRODUCTNUMBER] [NVARCHAR] (25) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AS NULL , [STANDARDPRI...more >>

Anyone know what this is and how to resolve it? Logged on this morning and the server has just stopped, service won't re-start, despite box reboot. It mentions an error log - where is this kept? Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogExcepti...more >>

I've got an online application (written in Cold Fusion) that I would like to be able to pull in a report generated in RS. Currently, I can call the report directly from the application using an HTTP "get", pass in the url string with "rs:Format=PDF", save the resulting PDF file on my server, then...more >>

Using VS.NET 2003, I created a report & data source and deployed both on my server. From within the network, I log into the report server and navigate to the folder where my report resides. When I click on the report name, I get prompted again for my UserID and password. After logging in agai...more >>

I have the need to create a report that contains four subreports. Each of the four subreports can be any one of 20-30 different reports (layouts differ). Is there a way to programatically change the name (or source) of the subreport at runtime? Would this end up creating a new rdl for each re...more >>

I have a text box which I only want to be visible if a value in a matrix is present. The matrix has row returned with the following =Fields!Activity.Value, and returns data as expected. My textbox has an expression on the visibility which is as follows:- =IIF(Fields!Activity.Value = "XXX",T...more >>

The error "The underlying connection was closed: Could not establish trust relationship with remote server." occured when any reporting service function calls if reporting service is installed with SSL(HTTPS). The code is very simple like below, Dim rsReport As New ReportingService ...more >>