I've installed the 64 bit version of Sql Server 2005 Express Edition with Advanced Features with SP2 on a PC with an Intel 64bit Dual Core CPU running Windows XP Pro x64. IIS is running with 64 bit ASP installed. But, Reporting Services will not install because it insists on having 32 bit ASP. ...more >>

The following is a question from a client, has anyone else seen this before? The client is running SRS 2000 on a Windows 2003 Server on SP1. Any assistance is extremely appreciated... When printing and switching to a printer other than the default, my PC shuts down and initiates a Restart...more >>

If I have a licensed version of SQL 2000 am I eligible for a free Reporting services copy? Thanks ...more >>

Can I run SQL 2005 report on SQL 2000 server? Thanks ...more >>

ASP.Net 2.0 Web app with ReportViewer Control. I have a basic report that has a link to another report. The first report loads OK then I click the link then the second report loads OK. But when I then hit the back button (the back arrow in the Reportviewer Control) I get Back call without dri...more >>

Hi, There seems to be a bug with the multi-valed fields when only one value is selected and that value contains only spaces. I get the message 'Please select a value for the parameter...'. It works when I test it in Visual Studio but it doesn't work on the Web. I'm using SQL Server 2005 wit...more >>

I've written a rss script file to automate publishing of reports to our server. I've encountered a problem when republishing reports that have a default value set for a parameter. If I change the default value of the parameter in the report rdl and then try to republish, that parameter's defa...more >>

If I install reporting services on my database server, can my developers make a call to it using web services? I have a front-end web server with a firewall separating it and the web services machine and the database server. I would like for the applications to make a call for the reports ...more >>

I'm having issues getting report services to work (2005). I've tried on both a Vista and an XP SP2 machine. I'm using SQL Server 2005 Dev ed. Basically on both machines I have got to the point where if I browse for http://localhost/ReportServer all I see is localhost/ReportServer - / M...more >>

After installing SP2 for SQL 2005 I can no longer run rskeymgmt. I was trying to backup the encryption key (rskeymgmt -e -fc:\rsdbkey.txt -ppassword) but I get the following error: The Report Server Windows service in not responding to RPC requests. The service may not be running. I hav...more >>

I'd like to use Visual Studio to actually create an output file which I will then use as an input dataset to generate various reports. The "output" need to be dynamically grouped with several calculations at the grouping level. Visual Studio gives me the flexibility to accomplish the logic...more >>

I've got a table in my Data Source View that is one of our central entity tables in our warehouse, and there are LOTS of relationship lines (Roles) linking to this table. We've just added 6 new columns to this table, and I need to add them to the Data Source View so the new columns will be ava...more >>

I am trying to display one of 2 values based on an input parameter. I have created a field which is supposed to evaluate the parameter and display the appropriate field. My code is as follows: =iif( Parameters!LastWeek.Value = "Y", Fields!Measures_M30N_MTD_Last_Week_of_Month.Value, Fie...more >>

Standard newbie disclaimer: I have searched the archives and this is my second week with the tool, so my apologies if this is a rather simple question or I am not asking the question properly. My team has received a specification for a report where the customers would like to see column total...more >>

I am trying to figure out the best place to install reporting services give the following: The need is to allow developers to use reporting services within their applications. Web users will only get the results of the reports in a web app and will not have access to the UI. Should I in...more >>

Is it possible to render multiple reports and then export them to 1 PDF file? If so, how can this be accomplished?...more >>

Does anybody know how to programmatically set the Print Button on the toolbar of the Windows version of the Report Viewer control? I'd like to display the report in "Print Preview" document look by default after the report has been rendered for the user. I think I'm trying to ask how to chan...more >>

hello there, i asked before, but didn't take any answer, maybe this time.. :) i use asp.net 2.0 and reportviewer component with local mode.. when i open report in reportviewer, allways shown with yellow toolbar.. but rest of my site has green-orange colors.. how can i change reportviewe...more >>

I am trying to achive something like this: --------------- some text ---------------- | | | | | | |-----------------...more >>

Can I merge two vertical cells in a table? Thanks ...more >>

I am putting a rectangle around my table. Table's height can grow alone with a number of rows. Can I resize a height of the rectangle accordingly? Thanks ...more >>

I have a report with a chart and a textbox. I use the 'navigation' property of the textbox to jump to another report. When my request returns an empty dataset I have the following exception: [1580] w3wp!library!1!04/04/2007-20:16:26:: i INFO: Call to RenderFirst( '/Reporting/ReportProjects' ) ...more >>

Hi all, Based on these Report Specs it looks like using just Report Server alone won't cut it. Spec: 1) Tracking Code: Allow Blank 2) Event Code: Allow Blank 3) User must fill in #1 or #2 but not both 4) Mkt Code: Allow Blank or up to 5 values 5) Date1: Option to specify a single date or ran...more >>

Hi - In 2000, how can you determine where an RS installation is point to for it's sql server repository database? Not clear to me since the config files are encrypted. I installed the database on a different server but not sure how to find out after the fact which server and db that is. T...more >>

Hi - I have a report that uses an OLAP cube. I cannot figure out how to pass parameters into the report using URL. I've tried setting the parameter to the value I desire, but that doesn't work. Here's an example: http://mysite/reportserver/report.rdl&rc:toolbar=true&rc:LinkTarget=_top&DimP...more >>

I have a table in reporting services. I have a field that calcuates a percentage and the report is sorted in ascending order by this percentage. I want to draw a single red horizontal line at a threshold, let's say 95% so that any record lower than 95% would be above the line and any record hi...more >>

I have a report that summarises data in project A and a report that details the data in Project B. When the users clicks an item link in the Project A report I want to be able to call the report in Project B. When you create the link you are offered the reports in the current project only. ...more >>

Hi All, I just had a client ask me if the stored procedures that a suite of reports I have written can have a different prefix than dbo. Of course, if the prefix is supplied inside the RDL a different prefix can be used....but that would mean knowing the prefix during development or changing ...more >>

Hi. I have a report with accounts in a list, and all activities belonging to each account in a table , at the buttom of the list I would like to show all accounts in my report, but only the top 10 activities for each account. I tried to solve this filter in sql but i have this running and i...more >>

a) how do I know which version of SSRS designer I have? how do I know which version is current? b) anyone know what this means: c:\documents and settings\administrator\my documents\visual studio projects\takeonefivefive_20070329\takeonefivefive\takeonefivefive \takeonefivefive\rptReviewingM...more >>

i'm using SQL Server Reporting Services 2005 and have a simple report that essentially pulls back a bunch of database records and displays the results in the excel-like grid. I want to shade an entire row, based on the value of a field contained in that row, but i can't figure out where (and ...more >>

I see there's MS documentaion on creating a data driven subscription. The example shows to create a data source for the data retrieval plan. see http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createdatadrivensubscr...more >>

Does anyone know how to get the web browser scroll bar to synch with the ReportViewer scroll bar? ...more >>

We are utilizing a SQL reportviewer control to view reports from within our ASP.Net application. I have run into an issue that I am not sure how to deal with. We currently pass in one parameter from the application that defines the current company and the rest of the parameters are supposed t...more >>

When viewing the report on-screen I get the field value in my header. However, when I export to PDF or Excel or Web Archive, the value in the header disappears. I use the hidden column technique and reference the ReportItem in the header. Have any ideas? -- Harry Riddle...more >>

Hi, I've restored my report server 2005 from serverA to serverB and Reporting Services will run and I can access the reports, but the above error will pop whenever I try to run a report. I followed the steps outlined below - where did I go wrong? 1) backed up the encryption key on serverA 2...more >>

I tried creating a hyperlink to a file on a network share using UNC like this: \\share\folder\file.txt Reporting services doesnt like this, so I changed it to use the file protocol: file://share/folder/file.txt But RS complains and says that the file:// protocol is not supported. It do...more >>

Has anyone encountered error 2878 installing SQL Server 2000 Reporting Services Developer Edition and how to get around it? -- Browse http://connect.microsoft.com/VisualStudio/feedback/ and vote. http://www.peterRitchie.com/blog/ Microsoft MVP, Visual Developer - Visual C#...more >>

Wondering if anyone else has had this problem? I'm using RS for SQL 2005 and checked the option "Header should remain visible while scrolling" on my table. And the header line does remain visible, but it's on top of the data as you scroll down the page. (the header line is 3 lines long - if th...more >>

I have this expression: =Iif(max( Fields!xpto.Value)=0,"--",1/max( Fields!xpto.Value)) My problem is there when Fields!xpto.Value) is 0 then give me the folling error: "The value expression for the textbox 'textbox36' contains an error: Attempted to divide by zero." and appear #Error i...more >>

Is there a way to pass de visibility - hidden properties when I do a jump to report? Let me explain it: I have two report with the same products and several groups but the reports shows different regions, I have ToggleItem activated and my idea is that when jump from one report to another the v...more >>

Is is possible somehow to create a file from a subscription with the current system date and time as part of the file name?...more >>

My employer is switching to a new version of software that uses SSRS for reporting in the near future. We currently use Crystal Reports. Today I was creating a report in SSRS notice that I did not have a datetimepicker or calendar control. I went into the Add Tool section and both controls were ...more >>

I have a problem when opening a sql 2000 report in a new window. As soon as the the report is opened, asp.net post-backs will fail. This is what I do: window.open('http//:[ip address]/reportserver?/ReportFolder/ ReportName') As soon as I do that, asp.net post-backs on the opener will 'do ...more >>

So here is the situation which i feal i stuck in forever... I am deploying reports in PDF. Reports are deployed to a ASPX (GrpRptViewer.aspx) page which contains 2 frames..and report is deployed to the lower second frame ...."GrpRptViewerFrame2" Now in one of my new reports...i have to op...more >>

I am new to SQL reports ..I have couple of questions. I have created coupld of SQL reports using SQL server business intelligence studio on my local box and deployed it in my local machine [datbase is also local] .It works fine. Then I tried to point to another database on another machi...more >>

Can SQL Server 2000 Reporting Services live on the same server with SQL Server 2005 Reporting Servives?...more >>

We have a InfoPath 2005/ SharePoint/ SQL 2005 implemetation that stores the entire InfoPath form as the new xml data type in SQL 2005. The InfoPath form is a Project Status report and contains various status, budget and descriptive data. It is stored in a single column of datat type xml along ...more >>

I'm using an IIF statement to prevent the #Error when my formula is trying to divide by zero. IIF(FieldA=0,0,FieldB/FieldA). It is still giving me an #Error for the fields where denominator is zero--works great for all the others, but that defeats the purpose of the IIF. I've tried sanity check...more >>

I 'm trying to create a multiselect parameter in my report with option for editing during the user input. Right now the multiselect parameter does not allow user to edit values before running the report. It is readonly textbox and user not able to edit it. The multselect parameter allows the...more >>

Hello, thanks in advance for your help. My company is writing windows forms apps and we are using the Report Viewer control from Microsoft. It's pretty simple, set the ProcessingMode property to Remote, set the ReportServerUrl to http://myreportserver/ReportServer, and set the report path to ...more >>

I have a report query that has a table called invoice that is right outer joined (one to many) to a table called invoice_line. The invoice table contains a field called freight_amount and the invoice_line table contains a field called line_amount. I am using this query in a data set in set...more >>

I'm fairly new to reporting services but need some help ASAP. I am trying to run the same report on a different database on the same server. I tried using a linked report but that didn't seem to allow me to change the data source. I will have multiple databases on the same server with the s...more >>

I have a table with 3 groups before the detail level. In the second level I use a filter because one of the group only have information in the top group. The problem is that when I make a deploy with the hidden camp - true is show well but when I put false in the Hidden it's shows a blank line...more >>

Hi I generate a report successfully in SQL reporting services . Once the report is generated I then select the export option to export it to excel I then get this error message( see below) after waiting about 20 mins for the excel file to be generated. There is a lot of data in this repor...more >>

I am trying to create a report from a Report Model, but when I try to select the Datasource Type I find the Report Model DataSource Type is no longer available to select. It definitely used to be there. I have recently been experimenting with the Custom Report Items and modified the configs...more >>