I have a report that will pull out a list of bugs assigned to users for a period of time (@StartDate, @EndDate). Optionally the report has option to select a single user (@UserName) or just all of them. There are 2 datasets. First dataset: Bugs requires 3 parameters: @StartDate, @EndDate, @...more >>

Recently setup my first Sharepoint (wss 3.0, sp2) site including integrated Report Services. I have SQL Server 2005 (full version, not the express version) installed on the same computer. I think I did a farm install, but installed everything on one computer. I do plan on using some linked...more >>

What am I missing, here? The "Custom Reports..." context menu appears, but is grayed out, and no "Standard Reports" context menu item is there. I've found no reference to additional steps to get these reports enabled/visible. Help? thanks,...more >>

When I run the rskeymgmt program to backup the encryption key, I get the following error: The Report Server Windows service is not responding to RPC requests. The service may not be running. I have checked, and the service is running. We are using SQL Server 2005 sp2. The command I am u...more >>

I am looking to find some good training materials for the Report Builder for my end users. I looked at "Microsoft SQL Server 2005 Reporting Services for Dummies" and it seems as though they just drop the ball in chapter 8 on the end user side. I've looked at "Microsoft SQL Server 2005 Repo...more >>

I am building a report that has two parameters that will always be Sunday to Sunday but I want a text box to show the Saturdays date for the first parameter which would be the first sunday. Example: Parameter 1 - 4/15/2007 Parameter 2 - 4/22/2007 I need the text box to read 4/21/2007 which ...more >>

Hi, Is there any way to pass "list{" + Parameters!Parameter3.Value + "}" as the whole parameter? Right now I have the text part in the input text box and the user types the value inside the braces. I'm talking to Informix db which is why I have this strange format. Thanks, Fred ...more >>

What is the best method of retrieving the database connection string used to authenticate a user against the datastore. I was trying to add the database connection string to the RSReportServer.config file and read it using SetConfiguration. How is SetConfiguration called? How does SetConfigura...more >>

Hi All, In my project there is separate database for each client. Based on the client i need to connect to the corresponding database and use that as the data source to generate Report. Is it possible to have dynamic data source without deploying all the reports with different ds for all t...more >>

I entered a Parameter drop down for my report, but I do not have the option to select all when I go to generate my report. Any ideas on how to get the select all to work?...more >>

When I get a return from my report, it is returning the date in the formate of "05/02/2007 12:00:00AM" How do I get rid of the 12:00:00AM part? Thanks, Ryan...more >>

I have a table with a group. I can set RepeatOnNewPage = true on the group properties to have it page break for each item, but is it possible to put 2 items and then a page break? Thanks...more >>

Hi All, I am installing SQL 2005 and would like to know if there the reporting services are the only thing in SQL that requires IIS. So I guess my question is if I shutdown IIS on the box what will break? Thanks -David ...more >>

I hope somebody can help me on this topic--it would be much appreciated. I'm trying to get percentages in a group-- a sum(amount) within the group compared to a sum(amount) of the whole group total: Group1 ItemA - sum(amount) - 400 ItemB - sum(amount) - 600 ItemC - sum(amount) - 200 Total Gr...more >>

Hi, I am trying to establish a way to count the number of True/False entries across a number of columns. That is I have a dataset returning results of organisations (rows) and whether they have opted for a particular criteria (columns). I want to know how many of the criteria a particular o...more >>

Hello, I am in the process of converting some Crystal reports to SQL Server Reporting Services 2005 reports, and have come up against a 'previous' function used in Crystal. Is there an alternative for ths function in SQL Server Reporting Services 2005? Thanks in advance, Craig K ...more >>

Hi, I am getting the above error message when trying to export to Excel. It seems that others are also experiencing the same problem, but cannot seem to find a solution for this. My report is pretty straight forward, with a matrix which contains text boxes. Any help would be great. Th...more >>

Can I change the report parameter setting when using datetime? If I change the report setting only the report get localized. And I don't want to use a report parameter type of String and use(for Dataset): SELECT DISTINCT CONVERT(varchar,DATE_COLUMN,120) FROM tablename Regards...more >>

I created a report based on matrix. I set the can grow property of all fields to false. In the report the fields are behaving as expected - the size is fixed. When I'm exporting to excel the fields are growing according to the text size. (I have other report based on table and the can grow prope...more >>

I have installed VB 2003 but don't see a project option for Business Intelligence Projects? How do I get this installed as I need to create MS Operation Manager 2005 reports? ...more >>

Is it possible to append data from the report into an exising Excel file? Thanks ...more >>