We have a server that has the report databases installed but I can't deploy my report. I get the error - The report server cannot open a connection to the report server database. A connection to the datgbase is required for all request and processing. ...more >>

we currently have rs and sql server 2000 installed on a 2003 server. We have software assurance with processor licensing. My question is can we install an instance of rs & sql server 2005 on this same server for rs 2005 alone? We want to upgrade to RS 2005, but because our erp system is in...more >>

When I click on a report, the following error occurs. How should I resolve this matter? ERROR: An error has occurred during report processing. Cannot create a connection to data source 'IPC_VISION_DEV'. For more information about this error navigate to the report server on the local ser...more >>

The RS Administrators are able to see all folders except the users. Why is it that users are unable to see their folders? Please help!...more >>

I created a report that calls a stored procedure that requires 2 parameters. when I run the report and enter values for the 2 parameters: Year and ID. I can enter various IDs (2202,1420) but the report is always using the same value (3207) with no regard to what I've entered. Under the "Re...more >>

We have a .NET web app that, at the click of a button, is supposed to print a handful of reports for a manager, directly to his/her default printer. It looks like we can do this with RSClientPrint, but I'm not super technical, and we're having problems. I'm getting an instance of object not ...more >>

I have an Item Report that lists over 50,000 items, we need to restrict using one of several different methods. Some times they will run the report with all items (no Where clause in the SQL Statement). Some times they will want to see only the items they call "common" which ar...more >>

I have a strange issue that I need help resolving. Basically, the formatting on a report that I am exporting to pdf changed when I updated my VS to the SP2 of the Reporting Services. Here's what I am trying to do and what SP2 did: I have a report that I created that makes address labels. I ma...more >>

I am being required to change the user account on my MSRS instance. We are going to use a domain level account and I have given it the rights that are specified on the books online. "The account specified is granted public and RSExecRole roles for the reportserver database, and the RSExecRol...more >>

I have a relatively complex report (2 different grouping levels) and I'm trying to get a specific sum and I'm having some problems. I have 3 columns that are involved in the sum. PW, ceded_PW and isInternal The sum I want is sum(PW) - sum(ceded_pw * -1 * (isInternal - 1)) I have also tried...more >>

I have moved the sites from the default sites to another website that all ready had a cert installed. I have changed the config files in both report manager and reportserver to point to https://website/reportserver for the url. The reportserver site works but I get an error on the reportmanage...more >>

the "View Report" button - Can it be place at a fixed position so that the user sees to press it instead of having to scroll to the right? Thanks ...more >>

What does the following error message mean? ERROR: [rsMissingDataSetName] The data set name is missing in the data region ‘DataSetName’....more >>

Hi, We have deployed our reports on a production server (Web farm + SP2). On this plateform colors of charts are totally different that in dev and test env. Also we have configured our pie charts to have labels "outside". On dev and test this work fine but on the production env la...more >>

However, I have tried on several occasions to get help with columns and no one is able to assist me in understanding how columns work in Reporting Services 2005. Could someone provide me with a basic understanding how to setup columns for mailing list? Or, is there a website, technical do...more >>

I have created a number of reports that I wish to run in the early hours of the morning so they do not choke our servers. I have based the report on a snapshot which seems to work fine as long as the parameters are fixed. Since this is a monthly report the underlying date parameters change ea...more >>

Can we use form authentication with Reporting Service? Is it more convenient to do with form authentication if I use Report Viewer in webapplication? ...more >>

Hi , I'm using the ReportViewer control on my web site . I need to implement the report bar : forward, back, refresh, pagecount, print. 1) How can I know how many page are in the report, the standard report bar display the pagecount but how can I get it ? 2) How can I implement the Print but...more >>

I can Install SQL Server 2005 (not Express) in Windows XP But I can't find Reports Virtual Directory in IIS. Can we install reporting(Sql2005) Service in XP? ...more >>

When I try and create a folder using the following syntax: folder/subfolder/anotherfolder I get the following error The item name is not valid. Item names cannot contain the following reserved characters ;?:@&=+$,\*<>|"/, and cannot consist exclusively of dots or spaces. When checking t...more >>

Yesterday, we upgraded Reporting Services to SP2 (from SP1) and SQL Server 2000 to SP4 (from SP3). Since then all email subscriptions for all reports fail with "Failure sending mail: Access is denied" reporting under Status in the Subscriptions tab. All was running well until the the service ...more >>

We are having two problems with the Report Explorer web part of RS 2000 SP2: - Using a List mode display in a zone that is narrow enough to force the report title to wrap, it still wants to scroll the list a little horizontally rather than just go vertical. For example: Report Example ...more >>

– export as CSV, XML or web archive creates an axd file. I don’t know why it does this… Exporting as different file types is not something that we set up ourselves when we create the report – SQL Reporting Services handle exporting files. I’ve had a quick look on the web and haven’...more >>

Hi, Does anyone know the maximum reports can be run at the same time in Reporting Services? I try to schedule a dozen reports (update snapshot) at the same time. When I check the execution log table, it looks to me that RS queues all reports and allows only 2 reports to be run at any given ...more >>

I have a column chart that has y-axis values that range between -100% and 100%. I'd like the y-axis to autoscale at both the maximum and minimum end, but always be sure that 0 will appear on the graph. So, basically I'd like my minimum to autoscale anywhere between 0 and -1, and my maximum to ...more >>

Hi folks - I am trying to figure out how to set up the visibility (expand/collapse) for my grouped matrix. So for example: A A1 10 A2 15 Total A 25 B B1 35 B2 30 Total B 70 I want the user to be able to click and collapse to just see this: A ...more >>

I have a customer that wants to use Reporting Services on Sql 2000. I have looked over RS 2000 and been having a horrible time getting the trial to run through one report creation (going on 2 days now). I am wondering if RS 2005 over SQL 2000 is/will be available soon ... as that would see...more >>

Using RS 2003, SP2. I have a bunch of reports and several report servers. All of the reports use shared data sources, each report server uses a different data source (one goes to a production database, another to a test database, etc). What I want to do is put a TextBox on the report and ha...more >>

Hi! I have added parameter fields for Start Date and End Date selection on a report using Reporting Services. They are behaving like independant fields. How do I tie them together so they behave like a between 2 date selection. Also when I preview the report, it looks like it goes throug...more >>

I have a matrix report that has an embedded Pie chart on the Rows box for the Matirx. This produces a Pie for each row that shows up on the report. Everything shows up fine but I want to show a percent on the Pie rather than showing the hours calculation. I have figured out how to do this f...more >>

Do anyone know what the following error messages mean? ERROR: [rsOverlappingReportItems] The line ‘line1’ and the textbox ‘textbox2’ overlap. Overlapping report items are not supported in all renderers. [rsReportItemOutsideContainer] The textbox ‘textbox1’ extends beyond the r...more >>

Hi, I just installed reporting service on a new box and it contains SQL server 2000 also. But, when I get into the manager screen, the options such as New folder, Upload files etc are all disabled. The hyperlink appears but nothing happens when i click on them.. Any suggestions? Thanks in a...more >>

Hi, I am trying to get a link out of a report to open another web browser with the HTML rs:target=_blank as part of the string parameter that is passed in...but it still opens the link in the same window. ?How does one open a link out of a report so that it will open a new window? THANKS!...more >>

Hello all, Hopefully this is an easy question.:-) I have a server setup on a notebook that gets around all over for demos and classes... Just tried to setup Reporting Services for app we need to demo. It works great as long as it has network access. Stops working when network access is remo...more >>

I've got a parameter that I am populating from sql, but I'd like to be able to add some functionality that does something like check for permissions of the logged in user and use one dataset over another. Is there anwyay I can achieve this or simulated it in any way? Thanks in advance W...more >>

Hi Group, I posted this problem two days ago, but it went unanswered, so here I am, giving it another try - it's really important for us ! Reformulation : We have a report that we can run in ReportManager. It takes about 15-20 second to generate, but it displays the html on the screen. It ...more >>

Does anyone know any alternatives to Visual Studio for creating reports in reporting services? I have tested on 3 different machines and formatted my HDD 2x and still cannot get this app to hold stable for more then an hour or so.... Visual Studio .Net is by far the most unstable MS app I...more >>

Has anyone experienced this? One of our users cannot see the Document Map icon on any report he views. Clearly this is an issue with his browser or O/S or how his system is configured, as everyone else can see the icon (and the map!). Any pointers to what might be causing this greatly appr...more >>

--Hello All , I am having a problem generating data models with SQL Reporting services 2005 from the web .I installed and configured 2005 Reporting services , created few reports and gave access to the users to view the reports from the browser .Everything goes well till this point . Bu...more >>

I keep getting a "Logon Failed" beside my subscription in the GUI when it Runs. SQL Server Agent is running. SMTP is setup right in the RSServer config file. My DataSource is setup to use "Credentials stored securely in the report server" And this is a user we created to access both the da...more >>

When I try to access the reports site using http://myserver/reports I get the following error The request failed with HTTP status 401: Unauthorized. Is there any error happening with respect to web service level?? If so how can I track that service?? ...more >>

I am having a lot of difficulties in grouping totals. Could someone please help! EXAMPLE: Group1 123 Group2 456 Group3 789 ...more >>

Hi, I've got a report that I invoke from within Javascript using a direct URL hit to the report. When the report generates it asks to either "Open" or "Save" the PDF file. When I click on Open it opens Acrobat Reader to view the file. I need the report to open within the same browser as the...more >>

I need to run RSCONFIG and change the account used for reporting services. The password I need to use has the character | (it looks like two sideways minus sings one on top of the other) When rsconfig runs, I get the error "the rest of the statement is not recognized" and the text after that c...more >>

I have the following data: Name Note Type John Needs 2 more credits Schedule APPT. John Needs 2 more credits Phone Call John Needs 2 more credits Office Visit Jane Final Check List Phone C...more >>

I have a report setup against an analysis service cube. It runs fine. Users choose a date from the parameter list and then it pulls out the data nicely. I need to programatically have it select a parameter for yesterday's date. Somebody suggested setting a default script for the parameter ...more >>

Hi there I am wanting to dynamically set the background colour of a textbox by using a colour value passed from the data. How would i go about this? thanks, Jennifer ...more >>

I have a drill down report which I have specified in the action with the second report name and also specified the parameters to pass to that report. I am using store procedure for the reports. When click on the first report to open the second report, it comes back with an error saying "Proced...more >>

Hello, I am deploying reports via the web service. I create a folder, then create a data source. Once I create a report, I make a reference to the data source created and change the reports invalid data source to the reference. When I did this with a data source with credentials stored o...more >>

I need to have MSSRS send emails to external email addresses. Our Exchange Server requires email to be authenticated. I am using SMTPAuthenticate value of 2. My MSSRS server is in a different domain than my Exchange Mail server. Currently I am testing before deployment into the field and my s...more >>