Is it possible to customize the Reporting Services Report Manager interface? What I am wanting to do is display the reports in a tree view. ...more >>

Hi I have a report that has a chart also. When I try to render the report the chart that is supposed to be displayed as a picture does not show up and there is some junk text right after the chart area. Can anyone please tell me what can be wrong here. The chart shows up perfectly in ...more >>

Hi, i have just using the images as project, but strange thing happen... when i preview the project, it's alright, and if i export from the preview, i can see the pictures, but if i open the report using http:// or right clicking the solution and click run, , the picture doesn't show up... and...more >>

OK, I have done 1000s of excel charts. Paste in the data, select the data, insert chart and it works. I am trying to do a simple line chart in RS and can't figure it out after two hours. Maybe it is time to quir coding! My query returns the following: Product, Month1, Month2, Month3, Month4...more >>

I'm going crazy. In Crystal Reports I was able to use variables to hold calculated values. In Reporting Services I see no equivalent. I need to write several formulas, setting x to the result of one formula, y to the result of another, and then z to a calculation based on x and y, and so on. ...more >>

I'm going crazy. In Crystal Reports I was able to use variables to hold calculated values. In Reporting Services I see no equivalent. I need to write several formulas, setting x to the result of one formula, y to the result of another, and then z to a calculation based on x and y, and so on. ...more >>

This works: =Previous(Fields!Jobs.Value) The following variants get this error: "The value expression for the textbox 'textbox17' has an incorrect number of parameters for the function 'Previous'." =Previous(Fields!Jobs.Value,"scope") =Previous(Fields!Jobs.Value,Nothing,"scope"...more >>

Hi, My Report manager was working fine, but today i am getting the following error. "Unable to communicate with report server. Please verify that the report server is operational" Please let me know what is the reason for not communicating report server with SQl server? Thanks Hussain...more >>

Hello, I would appreciate some help into my problem with the install of SP1 on my Win2K machine. The popup error says:"SQL setup failed to connect to te database service for server configuration." And in the error logs:"[Resource Error] We were unable to load the resource: IDS_PROPERTI...more >>

Is it possible to send a DataSet to a Custom code from the report. I am planning to use .net dll's in my report as a custom code. Thanks...more >>

I have a matrix with a row grouping of project and a column grouping of project manager. I am summing the gross margin, labor cost, and gross profit. Is there a way to only display the gross profit initially, but supply a drill down on that field to display the sum of the other two fields ...more >>

Hi, I am new to sql reporting services. I have just installed sql reporting service sp1. We have our own web app which uses forms authentication. I have a page where i use reportviewer control (which came along with samples)...to run a report...there is a separate physical report server and on ...more >>

Is there any way to set the width of a line to 100% ? I'm building reports that have a horizontal line seperator between tables and I want the line to span 100% of the report viewer window. Right now the line falls short of the end of the window and if I extend it longer, it creates a horizontal ...more >>

There seems to be a concept I'm not grasping. I don't understand why I can't get a simple sum... I have a singe table report based on a single dataset and all I want to do is summarize some financials at 4 group levels. I get both of these errors for every Sum expression in a report: "A va...more >>

How do I display check boxes in parameters.. I want the user to be able to select multiple options that can be passed into the Query.. please help. For example, Select * from branch where branchregion in ('NORTHEAST','SOUTHWEST',' SOUTHEAST').. RK ...more >>

After installing SP1 Report Manager can't communicate with Report Server. Error says... Unable to communicate with report server. Please verify that the report server is operational. The report server service is running. I rebooted after installing sp1. Any ideas? Thanks, Gary ...more >>

I'm creating a deployment capability and am running into an issue with SetCacheOptions. According to the documentation, you can turn off caching by passing in "false" and a value of null for the the expiration definition. So I'm doing the following: if (report_.ExecutionSettings == Execution...more >>

I know you can do alternating row colors by doing something like this: =iif(RowNumber(Nothing) Mod 2, "PaleGreen", "White") But how does one do alternating row colors at the group level? The above expression if placed on the group often colors several adjacent rows the same color....more >>

We can't print reports anymore from our asp.net application after installing SP1. No other changes were made. Screen says "Reporting Services Error" "The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in th...more >>

I created a report and gave a column a parameter in the data definition. When I do a preview it gives a textbox to enter the parameter. Works fine. I don't like the name of the parameter and change it in the data definition. Now when I do a preview, I get two textboxes for parameters, one for th...more >>

I am getting the following error when attempting to run RSActivate to add a server to a web farm: Failure starting the web service: The local NT service is not activated The log file contains the following entries: w3wp!crypto!7c8!08/17/2004-10:30:11:: i INFO: Initializing crypto ...more >>

Hi, We would like to switch from Crystal Report to Reporting Services but we are using CSS in our existing report's templates. Does anybody know if RS is compatible with CSS ? Thanks, Gerard ...more >>

Hi I have a report that has a chart also. When I try to render the report the chart that is supposed to be displayed as a picture does not show up and there is some junk text after the chart. Can anyone please tell me what can be wrong here. The chart shows up perfectly in the preview...more >>

Hi Guys, We are using in our application , the "Report Viewer" Component which comes as part of the Reporting services Samples . We are having a problem when viewing the data in "Report Viewer" as explained below. There is a Group Expression on the List in the Report and the option "Insert ...more >>

How do I pass a long parameter value to a report? This would be longer than the 2038 character limit of a URL . Do I need to use SOAP? Is there a limit with that? Is SOAP something I have to install seperately? Or should it already be installed with .NET 2003 and reporting service? I a...more >>

Hi, Is there anyway to change the default font on a report so that I do not have to keep changing it for each control that I drop on the report??? I have looked all over for this and cannot seem to find it. Thanks, David Bows ...more >>

Hi guys, I am very new to Reporting Services, so please bear with me here. I am curious about how we can configure the database server, database name, and login data using data from a properties file so that when Reporting Services and the Report Server start up, they have all the data they n...more >>

How do I export the file to csv format WITHOUT the header in the file (I don't want the header). is there away for me to include the rc:NoHeader=True in the SQL string? Please Help! Thanks :) ...more >>

Sorry, guys, my mind is wondering and get frustrated with RS. here is what i was trying to do: 1.using reportviewer (which is from MSDN sample) in a asp.net web app. 2. I can create report, modify report .. 3. when i view the report in out web app, since the reportview is using URL access to ...more >>

Need to pass the chosen Sunday from the Summary report to the Detail report as the endDate parameter displaying the results without promting the user. First report is 'Summary' report: It has 2 data sets: stored_proc1 @endDate, & stored_proc2_all_previous_Sundays (result is 'prevSunday' ...more >>

I had been successfully importing Access reports into SQL Reporting Services. Now all of sudden when I go to the Project menu to select the Import option, it's no longer there. I can't find it anywhere now. The only thing that I've done since I was able to import is, load XPsp2. Am I missing s...more >>

I want to set up a subscription for e-mail delivery of a report in Excel without the document map as the first sheet. I cannot find any a of setting this when creating the subscription. Is there any way of doing it?...more >>

Hi guys, I am very new to Reporting Services, so please bear with me here. I am curious about how we can configure the database server, database name, and login data using data from a properties file so that when Reporting Services and the Report Server start up, they have all the data they n...more >>

All, We recently tried to upgrade to the release version of Reporting Services from Rossetta, unfortunatly the upgrade failed halfway through, and no matter what i try i cannot get past the point where error 1603 is reported. I've even tried to uninstall and it says that Reporting servi...more >>