The ReportServerService is running at 99% CPU and using 1 GB of memory on Windows Server 2003. When we restart the service or the server, ReportServerService starts running away again. This server was working OK in the past - this problem just recently started. Does anyone have any idea w...more >>

roper startup file for Business Intelligence Development Studio 2005? My SQLServer 2005 installation went smoothly, incl. Reporting Services. However, staretu icon for BI Studio refers to DISTRIB.EXE, and I just see a brief DOS window flashing by when I try to start it. Thanks for any hel...more >>

I have a calculation to determine percentage. When the two values that are evaluated are the same the report displays Infinity as the answer rather than 100%. Anyone have any ideas how to have it read 100%? ...more >>

Hi All, Has anyone used the "Jump to Report" to pull up any one report from a selection of 7 other sub-reports. I am trying to pull up a specific detail report from 7 sub-reports using an individual pin # and the "report type" from the main report. These sub-report types are grouped fro...more >>

Hola amig@s, llevo dos horas intentando que CR me haga caso a la hora de hacer el tipico report en que hay una serie de datos que van en la seccion de detalle agrupados por un valor determinado que tambien se muestra como cabecera del grupo. El caso es que como logicamente hay unos grupos con ...more >>

Hi! We have an image that is used in most reports for most applications. For maintenance reasons, we prefer to have one image that is shared among all of the reports. To accomplish this, I created an Images folder off the Home folder in Report Manager and added the image to that folder. But no...more >>

Hello. I need to do a calculation using 2 fields from a different dataset. I tried something like Value = (Fields!y.Value, "scope") /(Fields!x.Value, "scope"), but I got the error. How can I do that? Thanks in advance for assistance Chieko ...more >>

Hi Is there a way to insert a page break into a matrix based on a grouping? I've found this option for tables.... ...more >>

I am New to reporting services and do not know most of it but the first hurdle that i have encountered is of how to use a fields in a header/footer section. the requirement that i have reports forces me to use fields but RS does not allow it. I was wondering if there is any workaround for th...more >>

In Crystal Reports, I can change text color based on the report content. For example, if the column total_amount < 0, I can change the text to red color. Does anybody know how to do the same thing in Reporting Service? Thanks a lot....more >>

Hello! Can a hidden Toggle Item be opened directly from the Document Map? So that you don't actually have to open the toggle item in the report. If it's not implemented yet, will it be implemented in the next version? Thanks, Anton...more >>

Hello, I would like to keep my connection from RS to database open all the time.. I noticed that when I try to render a report for the first time (called from .aspx page ) it takes a few seconds before it actually executes. Each report rendered shortly after comes back in no time. I understan...more >>

Hi, to save space I'd like to "hide" the page header in the Webfrontend but in the export (excel, pdf) etc. should it be available. I played around with "PrintOnFirstpage" but unfortuntaley you can't have a expression on this property. Is there a easy workaround to do so?!? Could I call the...more >>

Hi, a lot of my users were asking me to have the possibilty of a freeze pane (similar to excel) in the RS web reports because often the reports are to long to see the column haeders. Especially when you have drilldowns it would help. Has somebody tried to implement such feature by DLL...more >>

Hi, I'm having a problem authenticating my calls to the webservice. My ReportServer is on a box that is outside of my domain. I'm trying to access the web service from my development PC inside the domain. On the ReportServer box, I have created a local user and given that user admin r...more >>

hi, I would like to use the generated dataset in rdl file to generate charts(third party component) if needed, As of now just the report is displayed with out any graph. In order to achieve this i have to capture the dataset (mdx query) through custom code or any other means which will al...more >>

This is my sql query Select * from RefnrTable where (refnr = @refnr) In report parameters, i don't want a prompt. I want to hardkode the value right in the textbox(i have a lot of textboxes as i use as headline for my tables) . How can i do that or is it a other solotion for this?...more >>

Hi, Is it possible to embedd Report designer into applications as an activeX control? Regds, Sapnil...more >>

Anyone ... Am I missing something regarding the matrix control? I have set up a report with title information. I drag in and fill a matrix with the report data and for some reason when I preview the report it looks as if it widens the report to the right and even takes one of the text box...more >>