My report service is Standard Edition and I implement custom security. When I start the reporting server, the following error are shown in the log. ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. S...more >>

Greetings all. We're trying to run SQL Reporting Services over the internet with SSL. Our reports contain sensitive data, so we want all Report Server traffic to go over HTTPS (we do NOT want to allow any HTTP access). We've got the Report Manager web application working, but with a couple o...more >>

I have a table with 4 grouping levels, both headers and footers. I also have each group collapsed using the visibility/toggle functionality. But when they are all collapsed, except for the first group, I have the totals appearing at the group header level. Now when the user expands the firs...more >>

When I try to subscript a report I got the following message: "The value provided for the StartDateTime field is not valid for its type. It cannot be converted from a string value to the type that is required. (rsElementTypeMismatch)". I have already set my regional setting to english (I had...more >>

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp I dont want to sound dumb, but the first example that they have in this report says : by the time you've finished reading this whitepaper, you should be able to discern which of thes expressions wit...more >>

How can I change the default font for reports? I need 8 pt, not 10pt be default. Thanks, Daniel Williams ...more >>

How do I tell RS whether my report should be printed landscape or portrait? It seems to default to Port, and I need to change this. Thanks, Daniel Williams ...more >>

Hello All: I've been reading through previous posts regarding the inability to display field data in the page header for all pages on a report. The posts pointed me to create a textbox in the header and set the text box value to: =Parameters!<myparam>.Value Is this the easiest way to...more >>

I am getting this error when I try to upload an rpt in the the Reports Manager web site. "The request failed with HTTP status 413: Request Entity Too Large." I can upload an rpt that is 12k but not 30k. I did get an error after install that said it could not activare the reportservice a...more >>

I am passing dates to a function (below) and sending the output to a text field. I am getting an error 'Input String Was Not in Correct Format with Dates' when I run the report. I have tried the following expressions for the text field, with the same results: =Code.determineTimePeriod("0...more >>

at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.GetI mpersonationToken(String userName, String domain, String userPwd) at Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider.Save Report(Notification notification, SubscriptionData data) Repor...more >>

I know, I know there are several problems with charts already out there. I have read them all..... 4 times. I have a report that has a page header made up of simple labels and the body of the report is made up of a chart. I am performing the following. result = rs.Render(reportPath, format,...more >>

Hello, I have created a report that includes a table within a list. The report always renders correctly and as expected when accessed through a url. The report never renders or gets emailed if rendered through a subscription. In the log file I noticed the following error "The processing of ...more >>

Hi Freinds, SQL 2000 I need to move windows and SQL accounts from an old sql 2000 server to a new SQL 2000 server. Actually I need to move all databases too. I will detach and atach DBs. But how should I move win and sql accounts to new server? Thanks in advance, Pat ...more >>

I'm calling the Render method using C#, and passing in a ParameterValues array. The problem is the array can have a variable number of parameters, depending on the report called. Is there any way to do this in C#? I have to declare ParameterValue[] parameters = new ParameterValue[n]; ahead of ...more >>

I have a query returning a parent table with mutliple child rows. I want the report to show the info from the parent table and then show all the child info and then show the next parent info. Setting the parent fields to Hide Duplicates prints the information the right way, but leaves a blan...more >>

I'm using stored procedure that executes dynamically built string to return table. Report does not see any fields on refresh...more >>

Eexisting dev site Win Server 2003 with IIS, SQL Server 2K (SP-3), RS (SP-1) running for about 2 months now gives the following error ' HTTP status 401: Unauthorized' when accessing via http://dev server/reports. I connected to the dev server via Remote Desktop and opened IIS Manager. I s...more >>

It seems that nobody has detailed knowledge on this issue. I've read other postings and found nothing useful. I had no problem accessing report manager for a long time, and then all of a sudden I get HTTP 404 error OBject Not Found. Nothing was changed in IIS, Reports virtual directory, and I'...more >>

After successfully setting up RS on a Win2k server I've been trying to get forms authentication sample working. I went through all the steps given in the MSDN article but when I get to the login page and try to register a user I get the following: An error occurred while attempting to add the...more >>

After successfully setting up RS on a Win2k server I've been trying to get forms authentication sample working. I went through all the steps given at http://msdn.microsoft.com/sql/sqlwarehouse/reportingservices/default.aspx?pull=/library/en-us/dnsql2k/html/ufairs.asp but when I get to the login...more >>

Where can I look to find information on time delays between when RS executes an SQL SP and when the data is returned to RS. I am running into an issue when a report is run through RS it takes 11 minutes to render but when I run the same SP with the same parameters through Query Analyzer it ...more >>

Hey guys, I have 3 dropdown lists in report. 1 - ID Dropdownlist 2 - Name Dropdownlist 3- Financial Dropdownlist I want to fill 2nd dropdown and 3rd dropdown based on 1st dropdown list selection Is it possible in Sql reporting services Appreciate any help Thanks...more >>

Hello all! I have a report to be rendered in PDF format. On the report is a list. I'm trying to dynamically change the sort direction of my list sorting at run time, depending upon what parameter value is passed into the report i.e. ascending or descending. Is this possible? I've tried editing...more >>

I've followed the Using Forms Authentication in Reporting Services sample at MSDN(http://localhost/Reports/Pages/UILogon.aspx?ReturnUrl=http%3a%2f%2flocalhost%2fReports%2fPages%2fFolder.aspx) and have the following problem: After I'm "authenticated" in the UILogon.aspx page, it posts back to ...more >>

Hi, When i try to run your demo using URL http://localhost/AwReporterWeb/Chapter11/Server/AwReportViewerDemo.aspx it works fine for me and i can see all reports but when I try to integrate AwReportViewerDemo method in my existing website then it gives me following error. ----------------...more >>

I have set a report to render from a snapshot (Properties>Execution). I have also set up a subscription that emails the report to me. I am receiving the report via email based on the designated schedule (SQL Agent is running). However, when I look at the report history, I only see one snaps...more >>