I have the dataset like this and created a table in the report: Year Quarter Cost 2003 Q1 1000 2003 Q2 2000 2003 Q3 500 2003 Q4 1000 With the runningvalue function, I added additional column in the table: Year Quarter Cost Accumulated cost 2003 Q1 ...more >>

Dear All, I'm creating a report in the CRM , i'm using group by clause and i need to add count Expression in the group footer depending on the details area of the group , i've added this code in a textbox : = count(fieldname.value, scope) it didn't work & it generates an error that the ...more >>

Dear All, I was wondering if we can use datepicker to enter date parameter in our report. thanks in advance ...more >>

I need to integrate the data from one report into another report. I saw in one of SSRS 2005 presentations that the output of one report can be used as input into another report. Appreciate if you somebody could point me how this can be done. Thanks Karen ...more >>

Hi, Guys... I have a problem in suppressing the group in reporting services. When i set the visibility of the group with expression to false then the group include the detail will be suppressed. How can i suppress the group without suppress the detail of the group? Thank you Regards, Su...more >>

Hi Everyone, I am using, or want to use a parameter as a filter in a sql statement, the user will pick from a list that will then send a delimited list of numbers e.g. "a1,a2,a3,a4" as the parameter that will be referenced in the sql statement with a " field IN (@parameter) " type thing. Im ...more >>

When I click the "Upgrade" button while trying to configure reporting services I get a couple of errors here are the two errors: "Verify Database Version" First Yellow "!" Says : The database version (C.0.8.40) does not match your reporting services installation. You must upgrade your repor...more >>

I was led to believe that you could deploy reports created in VS2003 to RS2005. I have upgraded our test system to RS2005, but when I try to deploy a report that has been created in VS2003 (RS2000), I get the following error: The version of the report server database is either in a format th...more >>

I have one table on a page and nothing else (I've deleted other stuff), when I render report and switch to the print view all the even number pages appear empty but valid page number and header. How do I fix this problem? Thank you in advance....more >>

I have what is likely a simple question but I have had no luck in tracking down an answer so far. I have a report that I've created in RS that is for an English company and I want to display the output in pounds as opposed to $. When I go to a given text-box and click the format/currency optio...more >>

We have a SQL Server 2000, that is NT Authentication ONLY because it is exposed to our external web applications. We are using Report Server 2000. We generally use NT Authentication for our reports since most are on demand reports to this server and haven’t had an issue. Our issue arrives...more >>

Running Reporting Services 2005 (RTM) and SQL Server 2005... Have a RS report that calls a stored proc. The stored procedure takes 3 parameters - BeginDate, EndDate, and GUID (which is the output parameter; nothing passed in). I'm trying to get the GUID output parameter assigned to the GUID ...more >>

I am developing a Web site using VS.Net 2005 using Forms authentication under ASP.Net 2.0. The user enters a SQL logon and password, we authenticate that, then use an embedded logon and password for all SQL calls. It works fine, except when I try to export a report. I have ReportViewer em...more >>

I need to make use of static groups for a matrix however I dont want these to display in the end result. I have hidden them and shrunk them as much as possible but they still show - even if I put 0 in for the height it comes back with .03125 in the height of the cell ... it wont allow 0 (in e...more >>

I'm using VS2005 and RS2005 to build an asp.net 2.0 web app. I originally designed my reporting services 2005 reports as server reports, and called them in VB using the url method. The reports worked well, the print button showed on the report toolbar, and life was good. We had a need to go...more >>

Hello everybody I have some problems with the report designer in visual studio 2003. When I'm working on a new report project and I had defined my data source and my data sets, and I had have a report made, if I want to change my report (for example: create a new list or table or try to modif...more >>

Has anyone had any luck changing the default spinningwheel.gif icon that displays as a report is being generated?...more >>

I am trying to install the Report Designer on my laptop. The laptop is running Windows XP Pro SP2. I have the SQL server 2000 Reporting CD. Reporting services are running on the file server which is also running SQL server 2000. At installation I am not given the option to install the report ...more >>

======== REPOSTED w/MSDN ALIAS ======== We have a custom assembly used by our reports that needs to access SQL Server and the Registry. In code, prior to making our SQL server connection, we assert the System.Data.SqlClient.SqlClientPermission and we are able to connect just fine. Prior to ope...more >>

My company is in the process of migrating to SQL Reporting Services 2005. At this time we are most interested in the Business Intelligence functionality included in SS2K5. While we were testing this product we had everything all on the same box...SS, Reporting Services, web tools...everything....more >>

Hello All, First time post question here :) Is it possible to have 3 or more parameters in one row in RS2000 ? by default only 2 are alowed to display in one row in reporting parameters header, and it seems no setting in VS.net 2003 can handle it. or is it possbile to directly write some xml ...more >>

Can I backup report files (.rdl) from reporting services server? and how to do it? Because my disk is broken, the report project also lost. -_-... thanks ...more >>

I know that the ReportServer database is unique to the Reporting Service instance, but is there anything in it that ties it to a specific database server? I plan on putting the database in a SQL2005 mirrored scenario of which the ReportServer Databases will be included in this. Has anyone tri...more >>