I like to install "Reporting Services" on a server and add the reports to that server without deploying those reports from VS.NET directly to that server. Is it e.g possible to make a "Web Setup Project" so it can be installed on a server where "Reporting Services" is installed? Or is it e.g ...more >>

Can it make it so it's always 1 page, no matter how long the report is? I looked around for a setting but I couldn't find one. ...more >>

We had RS up and running on a stand-alone box. The server was recently added to a domain, and further made a domain controller. It killed RS (I'm sure all the accounts going from local to domain might do that ;-) Anyhow, initially an uninstall would not work from the RS CD. I tried Add / Re...more >>

Hello, Today is my turn to ask a question. :) I first installed SQL 2000 Dev (3a) and then RS with SP1. Everything is working great, except foodmart example. Today I installed analysis services with Foodmart database. However still I can't see the Foodmart example report. In VS, when I cl...more >>

I have a report like this, and I would need to implement drilldown on both column group and row group, and i am running into problems: 2003 Q1 Q1_Rate Q2 Q2_Rate Q3 Q3_Rate Q4 Q4_Rate | Total Total_Rate West 10 10% 20 20% 50 50% 20 ...more >>

I have an application with three different issues. First of all, to open my report the users click on a user-specific asp.net formatted URL that contains the parameters. When the report opens, it displays the parameter names with the parameter values at the top. Is there a way to get rid of ...more >>

I'm confused. I have two variables: @StartDate and @EndDate. I have to figure out how to execute this report each day through email grabbing yesterdays data. I tried just for a test to put in GetDate () and GetDate()-1 and I got an error. I'm wondering how do I set two datetime variables for...more >>

Hi, I'm writing a DPE, which returns a multiple resultsets(datatables) from a extenal data source. I would like to map these to dataregions in the report. How do i do this? Or To make it simple, let us assume i have a stored procedure returning multiple resultsets and how do i map these resu...more >>

What is the usefulness of this exe (registered and started as a windows service only 8KB). Seems like even when I have this service off, the report manager seems to function perfectly well. The only item that was different (when the service was running vs. not) that I could easily discern was...more >>

I'm a SQL Server DBA and will be playing the role of a SQL2000 Reporting Services administrator. To tightly control the environment and keep track of all the changes, I'm considering to implement a policy that requires all changes to Reporting Services and reports be released into producti...more >>

2nd Attempt sorry... Provider=MSOLAP; Data Source=mshfsql; Initial Catalog=SLA_LIVE I receive the following error: An error has occurred during report processing. (rsProcessingAborted) Get Online Help a.. Cannot create a connection to data source 'Man_Par'. (rsErrorOpeningConnection) G...more >>

I am now trying to render a report in ASP.Net using the reporting service web service. When I use the render function I get a SOAP exception .... The permissions granted to user '"Server1\ASPNET' are insufficient for performing this operation. This same code runs fine in a windows form, but...more >>

Hi, I've a report with 2 lists (The second list into the first one) My second list contain a table its like: First list grouped on the country Second list grouped by state Table displaying the cities Now I want to fit my table in 1 page, but checking the fit in 1 page option in my ta...more >>

Hi all, I developed a VB.Net program to deploy reports on Report Server using the Report Server Web Service interface. ------Here is the code snippets that I am using------------------------------------ ..... rs = New ReportingService(ReportServerURL.Text) rs.Credentials = New System....more >>

Hi, I'm installing Reporting Services on our productions server which is a domain controller, Windows 2003. The database is on a different server, so it would be a remote install of the databases. I keep getting error messages that say 'can not create database'. I'm using sa as a sql l...more >>

Hi, How do I reset this log file? I've tried to install reporting services a couple of times but the log file still has the first date that I attempted the install. Is there a way to reset it? Thanks in Advance, Marcia...more >>

Hi, we had to rename our server running SQL server and reporting services (including IIS), and now the reporting services don't work anymore. I guess the easiest way would probably be uninstalling the reporting services and then re-installing them again, but I wanted to ask if there was anoth...more >>

I have an Installation Error - "The report server installation is not initialized. Check the documentation for more information. (rsReportServerNotActivated)" this error happens when installing the Server Components. The message appears at the end of the installation. I have tried uninstalli...more >>

There are a number of posts in this group that have asked if datasets can be joined which suggests that there is some requirement for this functionality. We are currently comparing RS to Brio which allows this. Does anyone know if this feature will be introduced in a future version? Thanks...more >>

I have a page body and a page footer in my report. The page body has a table in its data region. It seems, based on the number of rows displayed, the footer section is adjusting itself tobe shown next to thelast row of the table. That is, if I want to show 15 records in a 2 page report, then in th...more >>