I have a number of Matrix reports that all run fine on my server that is not patched with repoorting service SP1. However, when I run these reports on a server with SP1 loaded, I get the error message "An unexpected error occured in Report Processing" when I click on a tag to expand a hidden item. ...more >>

I have been looking at the forms authentication sample that creates a custom login page. After looking at the licencing am I right in saying that this can only be implemented using SQL server enterprise edition as standard edition does not have the security extension API. If this is the case is ther...more >>

Hello, Has anyone here used Reporting Services with Sybase ASE, through OLEBD??? I'm having trouble passing parameters values to the report, it says that the "given type name is unrecognized", when I pass a string parameter. Can anyone here help me about this, at least tell me if this tool f...more >>

What is the 'supported' way to find out which Windows/SQL login has been configured for RS to use when it connects to the report server database? RSconfig.exe doesn't seem to have a read-only option. Linchi ...more >>

Microsoft gang, I have the following query. if I use @Shipping instead of @CustomerShipTo as a parameter name, at the preview stage, I receive @StartDate not defined error. SELECT ProductType,Product, SUM(TotalCases) as TotalCases, UnitofMeasure, DatePart(yyyy, DDate) as YDate, Date...more >>

We have a "Master" report that contains several sub-reports. Some of these sub-reports we need to print in landscape orientation. We have been unable to figure out how to set the page orientation for sub-reports. We also looked to see if we could create "sections" (like MS Word) where we could ...more >>

Hi, I'm implementing a custom security extension for Reporting Services, based on the forms authentication sample, and am having a couple of problems with authentication. Here's some background on my set-up. - We intend to expose reports to our customers over the internet. Since we a...more >>

Hi; I just installed RS and it seemed to go ok. But when I try to access the Report Manager at localhost\reports, I get the following error: Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the spec...more >>

We tried setting rs:ParameterLanguage=en-US in the URL so international users dates would stay in the MM/DD/YYYY format but it isn't working. We have SP1 installed. Has anyone used this parameter successfully and if so do you have any suggestions??? Please help, our customers in the UK would ...more >>

Hi, i want to use a different Stylesheet in the HTML Viewer via URL access. I copied the existing stylsheet of the "\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\Styles" path and named it TestStyle.css. now i call the report like this: http://server/ReportServer/ReportService...more >>

Can you tell me more about Reporting Services' use of the in-memory cache? I am pretty sure I have an issue where a report export pdf is coming from in-memory cache and I need to go back and generate a new one. I have monitored the 'Total Memory Cache Hits' in Perfomance Monitor and I see that whe...more >>

Hello All, I was wondering if it's possible to customize the Report Manager pages within Reporting Services. I'd like the Report Manager to reflect the layout of our company web site. If so, is there thorough documentation on how to do it? Thanks in advance, Frank ...more >>

I am logged on as a user with administrative privileges to my machine, to the machine housing the report server database, and to the the web server, yet when I go to Report Manager, I do not have access to the Home folder, only one lower folder, and no Site Settings for anything. How do I...more >>

Hi, i would like to know how i can let a user have the option to enter in 1 or 2 parameters. EG. select * from customer where ContractSigned = @Parm1 and ContractReceived = @Parm2 i would like the user to have the option to enter in either the signed date, received date or even both. I have ...more >>

We have reports available on the web that take begin and end dates in US format (i.e. 08/02/2004 for August 2, 2004). When our international customers try to render the report the dates get converted to the date setting they have on their local IE, so the date then looks like 02/08/2004 for Aug...more >>

I have a report with 4 parameters 2 of them are dropdown menus, one contains groups that populate the other dropdown box with computer names. The report works great but I would like to have an ALL function in the computer name dropdown box. From poking around here I was able to plug a UNION ...more >>

Anybody has found a way of presenting the user with a popup calendar?...more >>

Bruce, I am not sure if you read my reponse to your question in the old thread. So I am re-posting here the answer I got from the ActivePDF's support team. BTW, are there any plans at Microsoft to fix this? Thanks. Regards, Alexander Korygin. ------------------------------------------...more >>

Hi Guys Problem I have a value in a report parameter. This Value needs to be displaied in the page header on the report. I wish to hide this parameter so that the user cannot see the parameter apart from as a value on the actual report. I know that once the report is deployed I can on the Rep...more >>

hello i have a single folder with all of my reports, and several folders with linked reports. when i update a report, the linked report does NOT update. i have to delete it and recreate it. this is clearly a bug? please help dushan bilbija ...more >>

hello i've been receiving the following error on my report server: "The server you are attempting to access has exceeded its Client Access License limit" i have 45 licenses and less than 10 people accessing the report server. so... what's going on? i have the latest service pack installed...more >>

Hi, I have seen the examples of creating a Subscription via code. I actually wish to create a data driven subscription. Can someone point me to an example of this or post me an example? many thanks Matt ...more >>

I am using a string for the querystring of a report, and I am passing in parameters to substitute values. However, one of the parameters is over 1200 characters long and when I run the report from the designer it executes, but when I run it from report manager it doesn't run the report, and I don't...more >>

I am creating a summary report using lists (and lists within lists), because the data cannot be nicely displayed in a table. I have some textboxes with a visibility equation, and some with visibility set to TRUE in the same list. If all textboxes are visible, everything lines up correctly. Howeve...more >>

I am trying to deploy the sample reports from Reporting Services my development PC to the Reportserver. When I do this I get the Reporting Services Login prompt. I am using a user that has access to http://servername/reportserver and http://servername/reports and who is an administrator on the serve...more >>

i have a report with 2 fields(name,zipcode). After exporting to excel, it generates Alerts for Zipcode Field. some of the Zipcode field values like this (34213,23423,123123-1234,34311-1212) In zipcode filed after exporting to excel, Iam getting alerts on 34213,23423 but not on 123123-1234.?...more >>

Hi, I have a report in RS that give me information about a number of persons, one page pr. person. Does anybody have suggestions on how I can set up an e-mail to each person, where the page with the person's data is attached to the e-mail? (If there are 20 people, 20 e-mails shall be generated ...more >>

We are thinking of using SQL Server’s Reporting Services to generate and deliver “WebTrends” style reports on our Intranet and Internet sites (e.g. number of hits per page, most popular pages etc). As there would be a lot of work in coding all of the necessary reports, we were wondering if som...more >>

I have deployed RS to a windows 2000 SP 4 server box. This same box runs the sql server and also an exchange server. When I try to browse the report server I get an error saying that there is an internal error. rsInternalError and when I look at the logs there is an error that says The user pr...more >>

Hi, I don't know if this is possible. I have a matrix with one row group and one column group. Within the column group are three static columns.The rowgroup has subtotals enabled. What I want is that one of the three static columns is hidden in the report but shown in the subtotal. Can this be...more >>

I have developed a Windows Forms Control that renders ReportingService reports as a metafile, This way the reports can be shown on as 'Crystal Reports' does in the wysiwyg way. But when the reports contain some hundered pages (and that happens often) the rendering of one page takes up to 3 seconds. ...more >>

My report has 6 parameters. 3 Of them are defined with default values. How can I via the webservice method use these default values? I am building the parameters dynamically. You can see that the first 3 parameters are filled in depending on the value selected in a dropdown box. With the last 3 I wa...more >>