I am trying to do a grand total for a report - but, would you know it, I don't think it can be done! First there isn't a report footer (only a page footer) and you can't count the number of (unique) occurences of a group header. See my example below. This example is overly simplified - I am a...more >>

I got a suggestion to use Previous method to get the value from previous row. What i am doing is as below the expression i have written is Current = Previous(ReportItems!Current.value) - Fields!P.Value + Fields!C.Value -----------------------------------------------------------------------...more >>

I have a report with the follwing specs. Product Year UnitPrice # of Units XYZ 2000 $1.10 50 $3.00 10 $2.10 20 2001 $2.3...more >>

Sometime back I posted a message asking about how to access a Report Server from within a winform. I got a message back that said the following: "What I did is incorporate the WebBrowser ActiveX object onto a win form and the set its URL to the URL that would be in a browser. So far this has ...more >>

Hi, We have a RS ReportServer webservice that is called from an ASP.NET web app, which uses Forms authentication through a custom authentication extension. We also have a webservice client that runs within a Windows service that needs to make calls to (i.e. consume) the same RS webservice. ...more >>

Hi Guys I have a report where I pass a parameter to a stored procedure that then returns a resultset to the report. Everything works well apart from when I choose my *All option. If this *All option is chosen no data is returned. If run the Dataset and enters the *All option manually it retur...more >>

I made a ASP.NEt application that runs on my local machine to display reports as PDF's. When I moved the code to a project that is in Source Safe, and points to remote servers, it Times out. I'm concerned, how does the Render method in the Source Safe project know what Report Server to look at? ...more >>

OK, I am looking for help on how to break this problem up for debugging. I am testing Email report schedules. We are working with files of type: TIF,PDF & EXCEL. I am able to schedule rendering reports to a FILE SHARE successfully. I am able to email LINKS to reports successfully. When I se...more >>

I am wondering if it is possible to pass parameters to a report at runtime, in code, as opposed to having the user select parameters from drop downs while in the View mode of the the Report. That is, for the kind of reports I do there may be numerous combinations of parameters that need to be pa...more >>

I want to put two charts, candle stick and line. Line on top of candlechart but with transparent background so I can see the data on both. Please point me to some resource if it is possible. Thanks!...more >>

Hi, I had trouble getting reporting services going. I would get the configuration error. If I restart the IIS Admin the reporting services works fine but my other aspx pages get the same configuration error. Something about Microsoft.Office.Interop.Owc. If I restart IIS Admin again...more >>

How do I fix this error: Cannot open database requested in login '-u'. Login fails. Login failed for user 'INTERN3\ASPNET'. I was trying to fix a rsFailedToDecryptConfigInformation error and did something like "rsconfig -c -s intern3 -d -u IUSR_INTERN3 -a Windows". Now, I can't view any repo...more >>

Hello, I have a strange error. When I try to add a table to the reporting services I sometimes get errors depending on the table. I have one table that I can view fine, but the other one is giving me a ton of problems. The problem occurs when I go to add the table. When I select the ...more >>

I have a need to provide a control-chart-like appearance to the user community. Basically I need to track costs over a period of months against a previous year (or some historical range) and show where the current costs are tracking above/below the corresponding historical values. I was thi...more >>

Reporting Services requires that the default website IP address is mapped to (AllUnsigned). Does this only apply to IIS 5.0? Is there a similar requirement on IIS 6 default applicaiton pool? Fuzzy...more >>

I have been running SSRS in VB 2003 but recently I installed VS 2005 beta1 and now I am unable to access the report server. I noticed that I now have asp.net version 2 instead of version 1. I think this may be the problem. In VS 2005 I do not use the web part of the program at all so I think ...more >>

Ok, I give up (again). I have a report that breaks on company number. I want to display ="Details for Company " & Fields!Company.Value in the table header (or in a textbox within the body above the table). However, I only get the value of the first company number in the dataset, even when it...more >>

I am trying to write the charts produced to a literalcontrol but it always displays the chart at the beginning of the page. How can I display it in a placeholder or panel control on the web page. Dim lit As New LiteralControl("<div>") PlaceHolder1.Controls.Add(lit) ...more >>

I'm still seeking my holy grail to figure out a way to pass a dataset, full of data to SSRS at run time. The work to build the dataset has to be done in my ASPX program. I figure I could easily create a physical table containing the data at runtime with a name made up of MyTable + Session num...more >>

Is it possible to superimpose a chart on another chart. What we are trying to find is that we have a candlestick chart and a line chart that superimposes the candlestick chart. Thanks!!...more >>

I have a query that returns full date/time, hour, and minute, and other stuff. The report needs to be grouped by various minute intervals, but I am having difficulty getting it grouped by any interval period. How do I group my data in 15 Minute Intervals. Is it similar to group by 30 Minu...more >>

I would like to pass an optional date to a stored procedure and create a report and sub-report based on this date. If the date is not passed the procedure uses the current date to retrieve the data. I want the report to be a scheduled snapshot to be produced on a daily basis, but also want t...more >>

I have the report server database installed in the same machine as teh report server. Now I want to move it to a different server for performance and scalibility, is there a way to do it? Thank you. ...more >>

In other words Can let's say a textbox have something like =(runsql(select top 1 x from y where z=!Fields.k.Value) Thanks ...more >>

After upgrading to SP1, when using the preview tab in Visual Studio, I'm receiving the following error: An error has occured during report processing. Value cannot be null. Parameter name: format The problem is, I don't have a parameter called "format." This is "not" in my code behind wh...more >>

Is it possible to get a toggle state in an expression? I'm thinking something like: =Switch( ReportItems!textbox8.ToggleState, true, RunningValue(1, Count, "table1") > 3, true, true, false) Of course, "ToggleState is not a member of ReportItem". Is there a member that will tell me if the...more >>

Does installing RS SP1 upgrade the version of sql server? We are running SP3A as a standard. I want to verify that if I install RS sp1 sql server will not be upgraded to 8.00.859 (this version contains a hotfix). We noticed our test sever contains the hotfix and are trying to figure out how ...more >>

Has anyone come up with a way to get a drop down calendar when entering date ranges for a report? TIA Ron...more >>

Hi, I have this report that uses 6 datasets. If I take the code from each data set and run it through Enterprise Manager, the results of the queries pop up in seconds. However, if I preview the report in reporting services, it takes 3 minutes or more for my results to appear. The results a...more >>

I have few reports that I want to get into a single PDF. I am clubbing all of them as subreports in a single parent report. Then I convert that report to PDF using SOAP API. I would like to mention some points : - I have properly placed rectangles (with 0 inch height and Page Break At End...more >>

I'm new to Reporting services and I would like to be able to dispay a calculated field showing the number of business days, or business hours betweeen 2 dates. Anyone have some thoughts? Or better yet, a code snippet? ...more >>

I’m trying to figure our the most elegant way (if there is one) to have one report “boilerplate” reference multiple datasources. More specifically, here’s our situation: We have a number of different customers, each with their own identical SQL Server database on our Production dom...more >>

Hi. I've experianced the problem of getting the broken image links when trying to display charts in an external browser. I used the posted workaround of extracting the images from the stream for independent display (an ugly workaround). But I am stumped how to display a report that has both...more >>

I have Custom.dll for retriving data from database. I don't want to store connection string in class. Is it possible to store in some RS config file or i have to use XML file and read from it? Thx....more >>

I want to make a report which some of fields are invisible for a particular user. i.e. for a same report, I want to hide some sensitive fields such as amount to general user while manager can view this amount fields. Does reporting service have this features ??? ...more >>