Does Microsoft plan to develop another report designer (or buy one from someone else) instead of designing in visual studio ? /Michael V. ...more >>

I am attempting to create a stacked bar chart that shows only data points greater than 25% and less than 75%. I do this by setting the color of the first and last bars (in the stack) equivilent to the background color. Another requirement is to display a vertical line showing both the aver...more >>

Hi, After I have upgraded my server, RS stop working . a.. The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content and then restart the service. Check t...more >>

Hi: I have a complicated access query which is select from another complicated query that is select from another complicated query. Now I am trying to creat a dataset based on the first query. Is there anyway I can create a temp view or dataset so my query can select from. reg...more >>

I am running a Windows 2003 Enterprise server with IIS installed, and I have created a default website on it at port 80. I have followed all the preq requirements. (IIS, ASP.NET, Framework 1.1, etc.) However everytime I try to install the reporting services, I receive the following erro...more >>

Hi I am trying to export the report in pdf file with version 5.0. In pdf file , it leaves the blank pages in between. At the same time returns half of the information on one page and continues half on another page. For some data, it gives acsii characters in the pdf file and when in the ...more >>

Hello, I am having two tables ... SendMails (SendMailID,sender,subject) Data is 1, 'Sender1','Subject1' 2, 'Sender2','Subject2' 3, 'Sender3','Subject3' RecMails(RecMailId,Recieved,Subject) Data is 4, 'Rec1','Subject4' 5, 'Rec2','Subject5' 6, 'Rec3','Subject6' I want in the R...more >>

Hello, I apologize if this has been posted. I did a search and didn't find it so here it goes. I have been using RS for about 2 months now and are ready to put into production. On the production box we checked to use SSL during installation. Now when we try to deploy/upload any .rds or ...more >>

I am running MOM 2005 and every time I run a report using SQL Server 2000 Reporting Services, the following day I get this error in the System Event Log (ID 7031): "The ReportServer service terminated unexpectedly. It has done this 1 time(s). The following corrective action will be taken in...more >>

Hi, For the past few months I have been developing reports using SQL Server only, but just recently I was assigned to a new client who needs reports created using a Oracle database. I have never used Oracle before in any fashion, so I was wondering about connections to the Oracle database,...more >>

I am new to reporting services and am having problem with publishing reports to a folder I am using subscriptions to run the report daily at a particular time and save the report in pdf format to a folder on another system in the network.I have reporting services installed on my sytem but th...more >>

I am creating a report that will show the resolution rate for our helpdesk. I would like to create something that says if this group opened it and they closed it then count that request as one that the helpdesk closed. But If the helpdesk opened it and did not close it then count the request ...more >>

Hi, i have a table and a group in it.. i need to have subtotal column.. Im using the cost filed for grouping ... i need to sum this filed and show it... it seems that when i use the sum function alone,it sums all the cost values ignoring the group example Project Reg ot ...more >>

Hello all.:-) Does anyone know of a Report Designer program that I can download? Free would be good.:-) I just need to create and edit reports and really don't want to go the full MSDN route. Thanks much, John ...more >>

hi, Our custom web app uses the web service/SOAP interface for most work with reports, but we want to use a "fancy" viewer (like the ReportViewer) to display the reports. In other words, we'd like to mix SOAP and URL access, but we are using forms authentication and this poses a problem for ...more >>

I am trying to use the jump to url function to open a report from a report. The report i am jumping to has a parameter that needs entering. The code i am using is this http://reportserver/Report.aspx?ItemPath=Jump to report&rs:Command=Render&Parameter=Undefined But when i click to jump t...more >>

Is there a way to hide subtotals based on a parameter value? -- Is that a cursor in your code!...more >>

Hi, I want to reuse parts of my last report in a new one - is it possible to create some kind of "libraries" (or templates) in Reporting Services? Thanks. ...more >>

Hi, I was thinking of putting sql server express 2005 on dev server and then putting on sql server reporting services 2005. First can I do this? Will RS2005 run on top of express 2005? Also if I want to create asp.net apps using reporting services 2005 do I have to use VS 2005 in order to...more >>

Could somebody please tell me how to do this? I've created a report with the wizard that lists Managers. You toggle a Manager and a detail section of employees opens for that Manager. I want to put a row of column names at the top of the detail section when it's opened (not showing when the ...more >>

I have two charts for a report page, I just introduced second one next to the first already there and it seems like the new one is going to the right most side of the page after the matrix below it finishes. I need it to be placed next to the previous one but cant seem to understand what seems...more >>

Hi, my report is like below.... empid date reghours overtime 1 1/1/2000 4 5 and i want to it to be like empid date reghours overtime 1 1/1/2000 4 1...more >>

Getting error when try to open report project: The application for D:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\WinfundsReports.rptproj is not installed. Make surethe application for the project type (.rptproj) is installed. Everything had been working fine f...more >>