I cached about 7 reports last night, and they all looked fine and worked real fast this morning. However, something happened today and now the caching is gone? What would delete the cache? Does the cache delete when I deploy new reports? I have all of my reports set to use a shared sch...more >>

One of my collegues reported the following behavior in SQL Server Reporting Services (am pasting the issue verbatim as reported): ===== We are using SQL Server Reporting Services with Service Pack 1 to generate some reports. There is a performance issue in generating reports. If we try to gen...more >>

When I click on a show/hide toggle button, it renders the new report in 5 seconds compared to 20 seconds for a jump to report. I'm sorting using the navagation 'jump to report' which takes 20 seconds. When I expand a table it only takes 5 seconds. Can I 'jump to URL' and put a value like &rs%...more >>

Does anyone have forms authentication working with calls from VB? We've got the custom security working through the standard interface, but can't get LogonUser calls to work from a VB.NET app. Any input would be appreciated. ...more >>

I have a large report with about 20 MDX queries. It takes around 2 min to render. If I take all the tables out except 1 and run the report, it takes around 15 seconds. So is the 1 min 45 sec all rendering tables and sorting? (Do the queries not used get run?) ...more >>

hi, tried several issues to solve this ploblem. i want to install reporting service but during the install ill get " Error 1920. Service 'ReportServer' (ReportServer) failed to start. Verify that you have sufficient privileges to start system services." But im a domain admin. doing thi...more >>

Is there a way to format currency for check print using the reporting services software? For example, instead of displaying $32,469.68, I could display "thirty-two thousand four hundred sixty-nine and 68/100 dollars". -- K. Thomas...more >>

Hopefully someone will know the answer to this one. We are trying to setup a url (reports.company.com) to point to Report Manager so that end users will not have to enter in a server name. This works initially, but the web app changes the url back to http://ServerName/Reports/Pages/Fol...more >>

Hello, I was wondering if anyone has tried to use a paramter in a c# function. I am trying to use a date parameter to return the previous month... Here's what I tried that didn't work... =datetime.parameters!startdate.addmonths(-1).tostring("MMMM") Thanks, -- Ben Sullins Our Vacati...more >>

I've imported several reports from Access that I am now trying to convert use a shared SQL data source. Several of these report show an average value for a datetime field in SQL, ex. a textbox with a value of =AVG(Fields.T1.Value) Does anyone have a workaround for RS to be able to average a t...more >>

I have a report with the subreports on the 2nd page. The subreports are 3 colums wide and the intent was for it to look like this: <Subreport 1> Pending <Invoice aaa> <Invoice bbb> <Invoice ccc> <Invoice ddd> <Invoice eee> <Invoice fff> <Subreport 2> Complete without final verification ...more >>

Hi, I need to export my reports to Excel, and I've encountered strange layout problems, as below. Problem 1: Looks ok in report, looks crazy in Excel --------------------------------------------------- I understand that data regions within table and matrices are not supported (see http://m...more >>

I have a report that Sums several columns and uses the sums of two of the columns to calculate a simple percentage. =Sum(Fields!Col1.Value)/Sum(Fields!Col2.Value) = 3781/4756 The resulting calculated percentage in the report is 76%. The actual ...more >>

I'm trying to alter the "Server Information" report to include the amount of available disk space for all drives on a syste. I've ran through the tables, but have been unable to determine if this information is even colledted. Thanks, Leslie...more >>

Greetings. I have data that is bit data type. I'd like the Y axis to display "Yes" for 1, "No" for Zero or Negative one. How can this be accomplished? Thanks in advance. -- Tim Heuer heuert at Comcast dot net...more >>

We're doing sorting by jumping to the report, and by changing some parameters, I change the sorting. All the sorting is done by the reporting services tables, not the MDX queries. It takes a long time to rerun these reports. All the MDX queries are the same. Shouldn't these queries, or the ...more >>

I get this error message while deploying report: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Invalid text, ntext, or image pointer value 0xFDFF7F5F000000000303000001000200. The statement has been terminated. This happens to all rep...more >>

I want to be able to display my matrix subtotal in Red if it < 0 and Black if it is >= 0. I can do it at the detail level, but not in the subtotal. Thanks...more >>

Hi, periodically, our Reporting Service seems to fall over with respect to Subscriptions (visiting subscriptions reveal they are in a state of pending). We then restart the SQL Agent and the reporting services service which seems to resolve the problem until it falls over again. Sometimes t...more >>

Hi Is there any advantage to using stored procs over writing the query directly in query designer? Currently we pretty much have one stored proc for each report and are in the process of rewriting many of the reports and I was wondering if there were any best practices some could suggest...more >>

If so, how would I go about getting the data from the other server...It is not friendly towards two data sources. Thanks, Trint ...more >>

I need to remove some user directories but cannot. All of them were created with NT AUTHORITY\SYSTEM. Even as an Admin with all rights, the server will not let me remove them. Is there another way around this? ...more >>

I have what should be a pretty simple question. I have a report that has two parameters. Both can be NULL. I have set them both to allow blank values and allow null values. When I run the report, one parameter (@Year) hows the NULL box already checked, but the other parameters (@Prod) does ...more >>

Hi, All. I have a windows 2000 server machine with SQL Enterprise 2000 edition and reporting service enterprise edition on it. The Report Mangaer application and the Report Server Web service are both working. and i have a web application that makes calls against the reporting service AP...more >>

I'm trying to apply the green-bar effect to the detail rows in my report but the alternating colours are not being applied correctly. The report uses a table with 3 nested groups defined. For discussion purposes I'll call them Group A, B and C. Group A is the outermost group, Group B is nested...more >>

We are setting up a Reporting Server and are categorizing our reports by departments and applications within the departments. I have a long list of these categorizations which are in the follwing format: Dept1 App1 Rept1 Dept1 App2 Rept1 Dept2 App1 Rept1 Dept2 App3 Rept1 Dept3 App2 Rept1 ...more >>

Hi, i've a stacked column chart and the values are show overlapped. I've tried auto and all positions, but its always overlapped, someone know how to avoid this ? Thanks in advance...more >>

I have installed RS on a machine and have deployed several reports. Now when I go into Report Manager, there is no security settings on the properties tab - This means I am not allowed to add/edit roles or any security functions at all. Under the properties tab, i only see a general settings...more >>

I have a report that is formatted to output in landscape format. I have published this report to the report server and when running the report and exporting to PDF format, I can change the print settings to print landscape, yet Acrobat Reader renders in portrait and subsequently prints in por...more >>

Is it possible to use one dataset to reference fields from another dataset for Reporting Services? Here's the example for ASP: Dataset 1: SELECT CUST_ID, EMP_ID, SALES_ID FROM CUSTOMER, EMPLOYEE, SALES WHERE CUSTOMER.CUST_ID = '3232' ORDER BY CUST_ID The second query will display ...more >>

Is it possible to have a Chart control within a table. I am trying to create a report which displays some information about a School and has a bar chart to display the pupil age ranges for each school....more >>

Hi, I am using graphical report to display data. If the values are negative ( i.e less than 0) then the graph is not displaying the series values. If the values are positive then the graph is displaying series values. I need to display the series values even though they are negative. How to ...more >>

I have two fields Date entered|Date left and i need to calculate the difference in days between the two fields to look like this Date entered|Date left|Total days taken I am trying to use the datediff command like =datediff(d,Fields!dateentered.value,Fields!date_left.value) But t...more >>

Hello, I works with the reporting services and is thereby reports to providing. Now the question arises whether one can count into the reporting services (in the report designer) also on text fields. Super would be nice if me one help could....more >>

Hi. I need to display a date with his serial week number of the year (from 1-52 weeks). I wrote a class method that will receive this date and will return the corresponding week number, and made a dll file out of it. I added this dll as a reference to my report using Report->Report Prop...more >>