Hi NG, I deinstalled SQLServer 2005 Express Edition and installed the Advanced Express Edition again to try the technics of the Reproting Services. The installation finished without any error message. If I try to run the Configuration-Manager for Reporting Services a message is immediatel...more >>

Hello, I'm struggling to make operations on results obtained from grouping by specific dimensions. To be more specific, I'd like to substract value of e.g. sales for some product for one year from values from the preceding year. I'd like to somehow access the resulting recordset from group...more >>

Hello All, I have created Reporting Services Report and I had given a user Browser permissions to browse the report. But he is not able to get to the report. The browser asks for userid and password and when typed it does not take it. Only when I put the user in the local administrator group...more >>

Hi Buddies, I designed one report using SQL Server 2005 Reporting services that has 3 different subreports in it. and It works fine only if i didn't checked it in to the source safe ( that means without using the source safe). Once i put it in the source safe and try to run, deploy the rep...more >>

Hi, I am working on a Report that needs to display dates in International Format (UK) dd/mm/yy, the database and Sql RS are installed on a US date format mm/dd/yy, how do I get the date to display correctly in the Report? Cheers Bob ...more >>

Based on a User's SUSER_SNAME(), I perform a query within our company's Sale Org to determine which Branches and Sales Reps are displayed in Parent Report's Table. Then, when the user clicks on a Sales Rep, a secondary Report gets "DrilledDown" to (not a sub-report) for the Rep's details... ...more >>

Hi, I have several reports out of which only one report is acting weirdly. The report displays fine when I open it up but when I try to print it, it only prints the first page. I tried exporting it to PDF and the same thing, the PDF has only one page. I tried exporting in all formats and foun...more >>

I've done a clean install of RS2005 and then migrated old RS2000 database to RS2005. After the migration the Report Builder menu item is missing. I have system administrator level permission. I need your advice. TIA, Kamel ...more >>

Hello Techocrats: Could you please tell me if MS has added a feature called bursting the report in SQL 2005 reporting service? If yes, How to use it? Thanks Sanajy...more >>

Hi, I've dropped a table control in the body of a report. I've moved this table 10 cm down from the top of the report. When I'm browse the report is looks ok , the page 1,2... But when I print the report, the first page is ok ( the table begin 10 cm down the top), but in the 2 and 3 ... page...more >>

Hi everyone. I have done SRS for 3 years and have never run across this issue until today. I have a simple report. It takes a parameter called "SalesPerson" (select fullname from sales_contact) I use this parameter to get my data back. ie (select * from sales where salescontact = @...more >>

Hi all, I'm working with CRM and I need to selectively add one of 5 tables. Each of these tables have a field called activityid. I'd like to join only the one with a specific activity ID. Can I do a left outer join with coalesce? ...more >>

Okay I am trying to create a custom field. I have a dataset where the values for the dates are displayed like this: 1/1/2004 is stored as 1040101, if the date is 01/01/99, is stored as 990101. I need to format the data to be MMDDCCYY. I am trying to use the Mid function to extract what I ...more >>

This is a new installation of SQL Server 2005 (Developer's Edition) on Windows XP (SP2). After installation I ran the Reporting Services Configuration Tool (all boxes show a green check). I can browse browse to http://localhost/reports without a problem As soon as I try to deploy any re...more >>

SSRS 2005 I am building a custom asp.net report parameter page interface for our Reporting Services reports. We want to leverage as much of the design information contained in the report definitions as possible to automate the building of the report parameter pages. I see how I can use t...more >>

>From a .Net application can pass the parameters to a SQL 2005 report from within code without the parameter options being visible within the SQL report viewer component? ...more >>

Hi, Can I use Reporting Services 2005 with SQL Server 2003 SP2? Thanks :-) Sean ...more >>

Hi. I have a datasource that depend on parameter A. Parameter A get his values from query and have a defualt value. Parameter B get his default value from query that depend on parameter A. Now, whan I run the report, parameter A get a value and then parameter B get his value and the datasou...more >>

I've configured a report which will be sent out monthly however I want to set report parameters for startdate and enddata to be the first day and last day of the previous month. I'm going to send this automatically on the 5th of every month for the previous month so I want to be able to do this...more >>

Hey guys Scenario --------- I'm basically pulling a load of old data periodically from a bunch of client MSDE machines onto a server, and pushing the data into flat files using a ..Net application that I knocked up. The flat files are delimited, and there are multiple files based on their...more >>

Hello is there any way in a text box to make the text different colors? For example, if you have "Hello World" I'd like "Hello" to be red and "World" to be green. Thanks, ...more >>

Hi all, is there any workaorund for using fields in report header or footer? Now I user parameters as workaround and I´m not really happy with that... Thanks, Toni ...more >>

Hi, Any ideas on how to automatically generate and save the report to local server drive backend when user click on certain link on the application? The user do not have to render and display the report in frontend or click on save button when prompted? The system should not prompt user for...more >>

We have a 2003 server with SQL Server 2005. Our instance in SRS was playing up basically so I uninstalled it. When I now try to reinstall via the original CD it still thinks the product is installed. If I try to uninstall it tells me no features have changed and exits. When I try to re...more >>

Hi, Do you know the connection limit of express's reporting services? As i know standard's version is unlimited, so how about the adv version. Can I use this free version as web reporting tool for more than 100 users? Many Thanks..... ...more >>

Hi all, Hopefully, this is a quick and easy one to answer. Is it possible to execute an sql statement from custom code on the "Code" tab of a Report's properties menu? I'm pretty sure I could do this by writing a custom assembly and referencing it from the report, but what I want to do is w...more >>

I have a report with a single parameter, named param1. The parameter is a list box that accepts multiple values. When I select a single value from a listbox, the report works fine, But when I select more than one value, the stored procedure call fails saying '[Must declare the variable '@param...more >>

I have a report with a single parameter, named param1. The parameter is a list box that accepts multiple values. When I select a single value from a listbox, the report works fine, But when I select more than one value, the stored procedure call fails saying '[Query execution failed for data s...more >>

Is it possible to make use of the programming infrastructure in SQL Server Reporting Services without going through web services hosted on IIS? The reason for the question is that I have an existing application that does reporting via crystal reports but the crystal report library the applicatio...more >>

For the record, and for anyone else this issue might affect... We have an intranet application that uses RSClientPrint to display a variety of reports from a particular web application. The RSClientPrint object worked properly on some people's PCs, but on others it would appear to hang for 15...more >>

Hi, I am using Visual Studio 2005 and SQL Server 2005 Reporting Services with Dundas charts for Reporting. I have creatied one subreport and put this subreport in List control in main report. I have placed Dundas chart in subreport. In this way I want to display many dundas charts dynamically...more >>

Hello, I have a total of 5 parameters in my report. Year, season, list type, startdate, enddate. Year and season are simple queries. List type depends on year and season Startdate depends on year,season and list type. it has a default value (dataset) to pull the min(date) given the ye...more >>

I created a web page with ASP.NET 2 and VB.BET 2. On the web page we put a ReportViewer to display a report of SQL Server 2005 Reporting Services. For the security reason, we use SecureIIS of eEye Digital Security to protect IIS. SecureIIS version is 2.1.1. If We arm the Site Security of SecureI...more >>

Hi, When I navigate to a report, the parameter menu is hidden. I have to click on the arrows in the menu to unhide them. This only happens on deployed reports viewing through IE. The navigate action is set to use: "Jump to report". I could use "Jump to URL" but don't want to hardcode the full...more >>

Hi gruoup I have to make a query from SQL Server tables joined with Visual FoxPro xbase tables. I created a Linked Server with Microrosft OLE DB Provider for Visual FoxPro provider, whth VFPOLEDB.1 string provider. Everything runs ok within a Business Intelligence Development Studio environme...more >>

I'm new to MS Reporting Services and I need help ..... I have a Stored Procedure and I'm passing 3 parameters. One of the parameters is a listbox with several options. I want to automatically populate those options from a database query. Problem is I am not sure how to do this. The report...more >>

RS2k5 I have a few reports that I launch In-House only with a URL. Is there a way to pass the id and password with that. The users get a login dialog and I'd really like to eliminate that. BUT!!! I don't want to setup each user/pw on my RS server. I don't want to allow anonymous login. I ...more >>

What is the proper way to set a parameter collection's values in code? (C# or VB.NET) should you get the parameter list using getReportParameters from the SOAP web service then setting the items in the returned collection then passing the collection back through setreportparameters...... or ca...more >>

Dear all, I am using Reporting Services 2000 with SQL Server 2000 and .NET FrameWork 1.1 My client wants to migrate the DataBase to SQL Server 2005. The reports *.rdl are hosted by the IIS Web Server running .NET Framwork 1.1 The question is very simple: Can I change the SQL Server 20...more >>