In my reports, italic characters are changed to normal style when exported to pdf. Is there a way to prevent this style change? Not : SP1 is installed. Thanks......more >>

Inside a group i have a text box name totalvalue whose value is calculated from database field. Outside the group i am trying to calculate the sum(ReportItems!totalvalue.value,"Group3"). I am getting error saying aggregate function can use on report items when item is on page header or footer. H...more >>

I have been assigned to create a new report subscription form. I have done everything but prompt the user for values. So there are a bunch of reports with varied parameters. Some of these parameters are hard-coded lists and others are DataSetReference. How do I provide the subscriber with an...more >>

In my report I am using a group footer as a "line" to separate groups. I have coloured the background of the group footer row. In the VS designer I have reduced the row height to 0.03125in. When previewing my report in VS the report generates as expected. When running the report in the rep...more >>

Is there a way to track which users are accessing specific reports? If this is not possible, is there a way to just find out how many times a report is ran?...more >>

I am serving up reports using the web service using the render method. The reports have images on them. The following scenarios work ..Net application and Reporting Services are all on the same workstation. Images show up and everything works well. ..Net application on same workstation and...more >>

Hi Guys I am creating a report that is looking at the last 8 weeks sales, the problem I have is that we are now in Week 3 in the new year and when I populate a prameter for week 3 the query only returs the sales for the last 3 weeks (Which is correct). How can I get around this problem? ...more >>

I asked the following a few days ago. Am I asking the wrong group? I am attempting to put a couple of Oracle 8i views in a report project I am building. When I attempt to build the connection I have two drivers to choose from one is the Microsoft OLE DB provider for Oracle and the other is "Or...more >>

Hi Eralper, Thank you for the quick reply. But I think I am confused now as how or where to write those statements. The way I have been using reporting server is to create a dataset, create a datasource in the dataset (or use a shared datasource), either write text query or exec SP ther...more >>

When I try to create a new subscription no 'Report Server Email Delivery Method' shows up. 'Report Server Email' does exist in RSReportServer.config and is configured with a value for <smtpserver> and a value for <from>. What is required for 'Report Server Email' to show up? ...more >>

I have a report in Reporting Services that I want the users to be able to scroll up and down with the column headers fixed, just like freezing a window in Excel. I'd like to have the far left remain fixed as well, but that's not as important as the headers. Does anyone know how to do that?...more >>

Is there any way by which we can force to repeat the column headers to repeat if the page changes. Like in EXCEL where we can mention those rows that need to be repeat with the new pages. Thanks ...more >>

In my department we are trying to benefit from the RS: we create a lot of reports for the Marketing, and generally supply them through an Excel spresdsheet: 1. Ad hoc reports with data which won't be updated. 2. Reports connected to views which are updated once they are oppened by the user (=th...more >>

RS is creating log files twice daily containing the error below. Please advise. Thanks. ReportingServicesService!schedule!fc8!12/29/2004-09:50:10:: Unhandled exception caught in Scheduling maintenance thread: System.Data.SqlClient.SqlException: The specified @name ('7CBFF7AD-981A-4B1C-B...more >>

I have created a parameter for a report that is based on a recordset of clients. I am able to view the records for each client, but I don't have an option to view all clients. How do I add an 'all' option within the recordset? And, how would I set my report initially to use this 'all' ...more >>

I've asked this before but it seems like know one can help me out or something. So hopefully someone can fill me in. I'm trying to do some calculation with 2 textboxes. One textbox have the field from a local dataset and another textbox has an embedded subreport. I can't seem to take tex...more >>

How to create a Not Schared Data Source using Reporting Service Web Service? Thanks ...more >>

Prior to installing a system at a customer site, the server is built at our offices whilst it is connected to our own LAN and logged into our domain/active directory. The server is installed with Win2k Server, SQL 2000 and Reporting Services. When moving the system into the customers own d...more >>

I created a chart using some calculated fields, the calculations are working correctly (I manually checked the math), but the Y axis values are way off. The highest field value generated was 18,544 but the scale on the chart was showing 500,000 with the bar reaching nearly to the top. I could ...more >>

All, In the RS log I'm getting: w3wp!runningjobs!1804!1/12/2005-10:52:55:: w WARN: Thread pool pressure: turning off threads w3wp!runningjobs!1dc4!1/12/2005-10:53:25:: i INFO: RunningJobContext.IsClientConnected; found orphaned request Reports are rendered in html, csv and xml just fin...more >>

Hi All, I have A Report inwhich Data is Populated from a stored procedure, When I add a new record in the database that value is not replicated immediately in the reports.It does replicate after i close the browser and reopen it. Cant Understand where Im going wrong?? Can any1 help m...more >>

I have some data grouped with by a number, On the group footer I have the sum(col1) and sum(col2) displayed in textbox1, textbox2 etc. Additionally I need to include sum(col1) - sum(col2) in textbox3. When I tried to use (ReportItems!textbox1.value) - (ReportItems!textbox2.value) It gived a...more >>

Hello, I have a matrix rendering problem that drives me crazy. Can't figure out what it is for a couple of days. The problem is illlustrated below - note that starting from "Min Value" all matrix rows are shifted down. "Max Time" row shows minimum values, "Max Value" row shows time of maxim...more >>

What do I need to do to eliminate the document maps (Drill downs showing on Left side of the report). I do not remember adding and have checked the NAVIGATION properties of all the matrices in my report. Thanks ...more >>

I've placed a logo I'd like on my reports at the path http://<servername>/reports/images/logo.gif I've also performed the instructions as per the article "Configuring an Account for Unattended Report Process" in the RS BOL. I've also re-started IIS, several times yet I still cannot get the ...more >>

Hi ! Does anyone know, how to connect to a Hyperion Essbase database to create a new report ? TIA Kalle...more >>