After installation of ReportingService (dev edition), I get a note that the server is not activated. I try to activate via command below and get an exception about unable to connect to the database. I've attached the log file as well. One of the messages said to look for MDAC version, th...more >>

I want to have Bar or Pie charts on a webpage with ASP.NET page populated from a database.. We have Reporting server,olap etc.. Can i get our reporting server to populate a chart on the asp.net page? The webpage would be containg other things plus the Bar or pie charts.. Is this possible? Than...more >>

I'm running into a problem with reading a config file with my own custom entries in it from within a delivery extension. I've tried putting it in the ReportServer web.config and RSReportServer.config, and my code doesn't seem to be able to find it. When I use the configuration file .Net ...more >>

Hi Is it possible to restrict the rendering formats available to the user in the dropdown within the Report Manager? Thanks, Mark ...more >>

How can I make the total in the bottom row of a matrix report bold? Thanks, James. ...more >>

My report contains a date-time parameter. When the report is run it displays both the date and time portions in my date drop down box e.g. 01/01/2004 12:00:00 AM. How would I change this to only display the 01/01/2004 ? Note: I want to maintain system localized date format....more >>

Trying to test a data-driving subscription for 5 records for a specific report. Run report interactively successfully in report services. Can't figure out why e-mail is not being sent (set my e-mail address for all 5). Status showing "Done: 5 processed of 5; 5 errors". Verified SMTPServer info...more >>

I've posted a couple of times with problems after setup. Is there somewhere else I should look for assistance in setting up RS when I can't get either the Report Server or Report Manager working? Thanks. ...more >>

I am beginning to wonder if the behavior I am running into is a possible limitation of Reporting Services. This is related to exporting a report to ..pdf that contains an embedded image. I have seen some discussion on this, but have been unable to glean a solution from the existing threads. ...more >>

Does this mean that when I am building a report I can specify that I want a parameter to be able to (theoretically) accept multiple values? I am developing a custom front end for parameters that utilizes the web service and I noticed this property. Here is the definition from books online: ...more >>

Trying to take the result from a report on RS exported as XML via URLSyntax Ex. http://servername/ReportServer?/folder/reportName&customerName=customerName&rs:Command=Render&rs:Format=XML This example renders a XML-document, trying to use Microsoft.XMLHTTP, ASP to get the data from server. ...more >>

I've notice a couple other posts about this issue, but could not seem to find any responses/resolutions. I have a table with multiple groups. In HTML the document map hierarchy looks fine. In PDF there is no hierarchy. Thanks for any help with this. Example - HTML: - Sex - Male ...more >>

I am evaluating Sql Reporting Services. to see or use the report on the report server, does each client using the site need visual studio, or only the developer needs visual studio. Any response is greatly appreciated. Thanks snbat...more >>

Hi, Is there any way to add a dataset field in Page Header or Footer Thanks Ponnu ...more >>

Hi all- A few of my table cells are set to toggle visibility when a certain cell is expanded/collapsed. My table cells are all bordered, and when the cell loses visibility, the border goes with it. I remember solving this problem quite a while ago with putting the cell contents into a textb...more >>

I'm receiving the error "The permisssions granted to <user> are insufficient for performing this action" when I attempt to deploy to a remote Report Server. I have a new user setup with the correct roles, however i'm unable to change the user Visual Studio attempts to deploy with. Any ideas?...more >>

Is there an (easy) way to use a dataset returned by invoking a web service as a datasource in a report? I.E. when I run the report, can it query http://blah/getdata.asmx, which returns a dataset, either in table or XML form....more >>

I would like to install RS on my intranet box on a non-default website and use host-headers to hit the site. Is this possible even though RS books online says to set the IP address for the site to "all unassigned"? TIA, Berry ...more >>

Hi All, I would like a SIMPLE way to retrieve just the "Current_Execution_Status" value from the following stored procedure into a local variable so that I may evaluate it and process accordingly. I've found some stuff on the web but the scripting is like a couple hundred lines... Does it...more >>

Hi, I've a report with some queries : 1. CLient infos (which return the client name and other text info) 2. Orders 3. Historical sales My query 1 and 2 are displayed in top of my report. My historical sales is displayed in 3 charts I want to group these charts in 1 page (specially when ...more >>

Hola Comunidad, Tengo instalado Reporting Services y Intento enviar un reporte por medio de una suscripcion (Correo electronico) pero me sale el siguiente error "1", Tengo el SMTP instalado y me funciona por que en la configuracion del Outlook entran y salen mensajes servidor2.blanquita2.loca...more >>

Does anybody know how to change the color of the chart items? I dont want to use the default palette that the reporting have. I want to change the color of the bars and the pie chart. ...more >>

Hi, Is there a way to automaticaly update my rdl file?? I have 12 reports to maintain and i modify theme often, is there a way that when I put my new rdl file on the server, rs autoupdate file... because I have to enter in the 12 report and click modify...update...browse...ok Francis ...more >>

I want to set the fill color of a pie chart with my database ex: I have different department in my database, in each department, I have a column named color like: Dept color dept1 Moccasin dept2 Salmon .... ... I try to put Fields!Color.Value in the fill color property but it d...more >>

For some reason no data is returned. Thanks for your help. ="SELECT REFTABLEID, REFRECID, NAME, NOTES, REFCOMPANYID, CREATEDDATE, CustName, Accountnum, DATAAREAID, DIMENSION, DIMENSION2_, DIMENSION3_, DIMENSION4_, DIMENSION5_ FROM Vw_Notes_Report" & IIF(Parameters!Cust.Value = " ALL", " W...more >>

We have a report that's rendered to a printable form over 1000 times in a span of 2 hours. We're in the process of replacing the server because this workload has been hammering the machine and running the RS services out of memory. I've added a metering component (the page that redirects users...more >>

Hello everyone, I have a matrix report that is grouped on 4 fields. I need the report to display data for every line and not hide data for a group. i.e Currently: Apex Merlot 750ml 375ml 1.5L I need: Apex Merlot 750ml Apex Merlot 375ml Apex M...more >>

What am I doing wrong here? I am trying to programmatcially run a report that uses an Oracle stored procedure where the Oracle credentials would be prompted if I ran interactively. The program (C#) compiles OK but I get an 'Object reference not set to an instance of an object' error when assig...more >>

I am continually seeing an issue where I write a query with some calculations in it and when I put that same query in reporting services those calculated fields do not display in the report. I get a warning saying those particular fields is not part of the result set. I can usually get aroun...more >>

Hi everyone from Spain, I am designing a lot of reports for the same application. I don't want to apply the report style at design time (with Report Designer), because any change in the style (for example, to change the font) will be to change all the reports (one by one). Which options off...more >>

Hi, Can someone show me how to set reportviewer parameters. I am using visual studio with the reportviewer component provided with reporting services samples. I understand that I have to set ServerURL and ReportPath properties, but do not have a clue how to pass parameters to the reportview...more >>

Hi Is it possible to connect to an existing project of reports? cause i have made some reports on my workstation, deployed them on the server and now some of the others from the office wants to connect to the reports and tweak them a bit. How do we do that? /Christian...more >>

Hi, Is there anyone out there that has had this problem. All my renderings from the report server work except for MS Excel for all of my reports. The report contains the following about 5 times: "This is a multi-part message in MIME format. ------=_NextPart_01C35DB7.4B204430 Content...more >>