How do i pass parameters from reporting services to ASP.NET thru URL? and how do i retrieve the parameters values from the URL using ASP.NET? And also vice versa. that means how do i pass parameters from ASP.NET to reporting services and how do i retrieve the parameters values using reporti...more >>

I have a column on a report listing a contact. I want to click on the contact and bring up my email program. I entered ="mailto:" & email variable in the Jump to URL field. I get an error Invalid URI: the hostname could not be parsed. Although it does work if I hard code the address like =mailto...more >>

i am currently doing a system where user can submit their suggestions to us and part of my system is using Reporting Services and i need some guide on my problem. When user submit their suggestions, the date of submission will be auto input into SQL Server database and if the suggestions is...more >>

I have to generate a 2-part report like this: part 1: A summary (just a table) with each row being a row in the dataset. This could be 500 or so rows. part 2: A detail where each page is equal to a row in the dataset (same dataset). The trick part is this. The summary MUST be on letter-s...more >>

Question: why .Net Data provider does not work with Reporting Service. I have created sample .Net Data Provider as recommented: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpcontemplatefiles.asp I added string name and version number and added assembly into G...more >>

Hi all, I have a .net dll that finds if a user is a member of domain group. This dll is used inside Reporting Services to restrict report printing. The code is: <DirectoryServicesPermission(SecurityAction.Assert, PermissionAccess:=DirectoryServicesPermissionAccess.Browse, unrestricted:=Tru...more >>

is it possible to include the data results from the query into the .rdl? then rather than re-run the query each time, the viewer could see the report with data and then be given the option to refresh? would i have to extend the schema for rdl to do this? will...more >>

I've got two reports that are almost identical. They both allow clicking on the column headers to sort the report so there is a parameter called SortBy which appears as a drop-down list of fields that are available for sorting. Both reports have the same default value defined for this parame...more >>

I would like to use a stored procedure with parameters which creates and executes dynamic sql as a source for a report. I get an error, though, stating "could not generate a list of fields for the query". I tried adding the fields manually to the report definition and matching them with the...more >>

Shouldn't reporting services setup create ReportServer database automatically? The setup fails at the very end with this message: SQL Server failed to execute command for server configuration. The error was: Database 'ReportServer' does not exist. Check sysdatabases. ... Thanks, -Stan...more >>

I have several reports using the same database with the same credentials (using a specific Username and Password). All display fine, except for one that gives me the following Reporting Services Error: An error has occurred during report processing. (rsProcessingAborted) Get Online Help C...more >>

Hi, We are using the Reporting Services Web Service, in order to expose some reports in our Web Application, right now I am trying to enable exporting the report to the available formats in Reporting Services, and altough everything seems to be working fine, when I try to render as Web Arch...more >>

Hi, I have created a report that when visualized on HTML 4.0, shows me 7 pages and in PDF, 27. Does anyone know how to adjust the visualization on HTML in order that the pages break are the same as in PDF? Is this a RS bug or is there an especific configuration for it? Thanks, Marcelo...more >>

I am installing RS to a fresh server. I have Windows Server 2003, SQL Server 2000 SP3 installed, as well as IIS. I have the default website up and running but it is not networked yet. During the installation, I get an error message saying "This edition of Report Server is not supported on...more >>

On one particular server, when installing Reporting Services I keep getting "Failure Compiling WMI registration file" What is the problem and how can I resolve it. Thank you. -- ...more >>

We have company logo stored as an "embedded image" in the rdl file. When the report is deployed to the production server, the logo is not displayed in the Report Manager. What all steps are required to deploy reports with embedded images? pls. help. Thanks ...more >>

I have a report timeout issue when I view the reports from report manager. According to execution logs my report ran in about 8 minutes. However, during the execution the report manager times out after the first minute and displays action canceled. (The task bar changes from long report link to...more >>

I have a little custom code block that looks like this: Dim Public polCount as integer = 0 Function addPolicies(count as integer) As integer polCount = polCount + count Return count End Function The idea is, every time a certain cell is loaded, it calls the addPolicies() function, whi...more >>

Is anyone out there using MDX query and XML/A for sql server reporting , If So................. Pls tell me how ur manage to do it.....?? ...more >>

Hello, I have a report that runs ok at the report manager. However, when I try to export it to excel I receive the following error message. Any ideas? Thank you. CD Reporting Services Error ---------------------------------------------------------------------------- ---- a.. Exc...more >>

I got this error when trying to subsribe a report "Failure sending mail: An error has occurred during report processing. ", I checked the RSReportServer.config file, SMTP server is correct, and everything else looks good, does any one know how to fix it? Thanks. Carol --- Posted using Wimdow...more >>

I have code in my detail row that <=IIf((RowNumber (nothing) Mod 2), "White", "WhiteSmoke")> that should cause the rows to alternate colors. However, it always skips the first row. So I have 2 white rows and then it starts alternating. Has anyone else seen this, and what is the fix?...more >>

Hello, Is it possible (if so, how?) to use the system colors (Windows colors in ie) for matrix elements? For instance, can the system's 'active title bar" color be used as the background color for a textbox in a matrix? Thanks, Marc....more >>

Hello All, I need to find out the best practices approach for user configuration in SQL Reporting Services. I have teams of developers, who would be using VS.NET development and deploying using VS.NET. Whats the best approach I could take for development...Ideally I would like each team of use...more >>