Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
all groups > sql server reporting services > october 2007 > threads for october 29 - 31, 2007

Filter by week: 1 2 3 4 5

Optional filtering by parameter
Posted by Dmitry Duginov at 10/31/2007 2:13:05 PM
Can anybody suggest the easy way to add an optional parameter to the report? Example: Without this "feature" the report contains records for the groups A, B, C, etc. I'd like to add the parameter "SingleGroup". By default it is null and the report should work exactly as before. If I set the v...more >>


loading a report in a windows application using reportviewer
Posted by billyburditt NO[at]SPAM gmail.com at 10/31/2007 10:56:13 AM
I have a windows application which displays a remote report using the reportviewer. It works fine except on the form load it runs the report. I rather the report just display instead of running. This is a problem for two reasons: 1. My report has parameters. Since no parameters have been ...more >>

Creating SSRS folders?
Posted by jobs at 10/31/2007 10:13:45 AM
New ssrs istall. When I attempt to open report manager, i just get SQL Server Reporting Services Home with no option for creating a folder etc, like i have on development When I attempt to deploy to ther server I get : Deploying to http://amsqlclusterxx/reportserver/ Error rsItemAlr...more >>

Speed up software.
Posted by Scott Burke at 10/31/2007 9:59:07 AM
I use Microsoft Visual Studio 2005 to write my reports. When I run the reports in VS it takes forever to run. I checkec the task manager and the System Idle Process is 70% while the reports are being processed. Question: Does anyone else have this problem? Does Microsoft Visual Studio 200...more >>

Change Subreport Name while running
Posted by Harry Leboeuf at 10/31/2007 9:46:37 AM
Is there a way to change the subreport name while running a report. Depending on the user that runs the main report i would like to present another subreport. The subreportname can't be changed by an expression. I could place all subreports on it and then hide the ones that arn't needed but...more >>

Can't deploy report on the reporting server
Posted by andys at 10/31/2007 9:26:00 AM
Please help - I am trying to deploy report on the server - getting following: =================================== A connection could not be made to the report server http://169.35.137.96/ReportServer/. (Microsoft Report Designer) =================================== The server committ...more >>

Chart error: Parameter is not valid
Posted by Rolf Smeds at 10/31/2007 5:52:03 AM
Hi, I'm using Reporting Services 2005, trying to design a report in Visual Studio 2005. I have a chart in the report that seems to work just fine when I test it with Preview. However, every now and then, if I change some trivial detail in the chart properties, such as the title font, ...more >>

SQL SERVER 2003 - Report Server
Posted by Logger at 10/30/2007 4:22:01 PM
Does Microsoft keep a previous version of the .rdl if you deploy a report in Visual studio 2003? If so, how do you retrieve it? ...more >>



How to add a calender with a user parameter
Posted by rampaleee NO[at]SPAM gmail.com at 10/30/2007 3:11:33 AM
Hello evry one, Can any one help me how to add a calender as a list of values,to an user parameter in reports. I am passing a parameter called effective date. for that parameter i need calender as a list of value. Please any one help on this.. thanks Balaji ...more >>

Image not displayed in report
Posted by Kirk at 10/30/2007 12:00:00 AM
I am creating a very simple report in VS 2005. I dragged an image control to the report surface and set it's value property to the virtual path of my image (like "~/SubPage/Trademark.jpg"). However, the image is never displayed - either at design time, when the report viewer runs, or when the ...more >>

How to Block a System Administrator in RS
Posted by Harry Leboeuf at 10/30/2007 12:00:00 AM
My machine is in a domain. The local group Administrators had a member that is the Domain Admins. Our Tech Support has configured this like that. Now, in the Home directory i've deleted the BUILTIN\Administrators from the users and groups that can access the tree. Even on some directories i'v...more >>

Excel Report - Large File
Posted by Madhan Raj J at 10/29/2007 10:46:01 PM
SQL Server 2005 reporting service is being used to generate a large excel report with about 30,000 rows. The size of file generated is ~15MB. but if the same file is opened in Excel 2003 and saved back in XLS format itself, the size of the file reduces to approximately 50% of the original size...more >>

Reporting Services - Local Report - Memory & Session Usage
Posted by Antony at 10/29/2007 8:19:00 PM
Hello there, I'm currently experiencing some issues with Reporting Services' ReportViewer Control. When running the control without a Reporting Server in 'Local' processing mode we cannot serve very many simultaneous requests. Worse, if a single user opens several reports one after the oth...more >>

Published Report Not Showing Correctly in Report Manager webpage
Posted by RBS at 10/29/2007 11:56:02 AM
have a report that in the designer in Visual Studio it displays correctly on the preview tab. The report has 5 subreports and one of the subreports is a matrix. On the report I have a parameter for the user to choose rather to see the matrix subreport or not. When I view the rep...more >>

I want duplicates in my matrix!
Posted by Mike Austin at 10/29/2007 10:41:13 AM
I have a very simple report that allows users to extract data to an excel spreadsheet and work with it. It consists of a single matrix with 3 row groups, 1 column group and 1 "fact" cell. When it is run, either in preview or deploy mode, the report is hiding duplicate values in the first colum...more >>

Using parent datatable row in the report table object
Posted by Sanjin at 10/29/2007 7:32:00 AM
I have the dataset with the following tables, Products and OrderDetails. The structure (simplified): CREATE TABLE [dbo].[OrderDetails] ( [Id] [int] NOT NULL , [ProductId] [int] NOT NULL , [Quantity] [numeric](18, 2) NOT NULL , [Price] [numeric](18, 2) NOT NULL ) ON [PRIMARY] GO CREATE T...more >>

Dynamic Parameters
Posted by brinda.shree NO[at]SPAM gmail.com at 10/29/2007 1:58:46 AM
I need to build a report in which every field of the dataset acts as a Parameter to filter data in the report, so that the user is not binded only to a fixed set of filters. Based on the datatype of the filter; the condition should be specified and the user will only supply the value for which...more >>


DevelopmentNow Blog