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 > december 2006 > threads for december 22 - 28, 2006

Filter by week: 1 2 3 4 5

More grouping Woes!
Posted by Carl Henthorn at 12/28/2006 4:14:01 PM
I have a result set of consisting of names and addresses. each person at a particular address (1-n people) gets an identical groupid to group them in a "Family". My report lists each column, groupid, name, address, with one row for each person. I would like for it to group on the groupid, the...more >>


How do I delete unused reports and datasources?
Posted by dgk at 12/28/2006 2:48:48 PM
SSRS2005. There are several data sources and reports that were created during testing/learning, and I'd like to delete them. I can go to 127.0.0.1/reportserver and see them but can't delete them. Entries pointing to them are stored in the sqlserver database (catalog table) but I really don't wan...more >>

SSRS 2005 SP1 Passing Duplicate Parameter
Posted by neb139 NO[at]SPAM gmail.com at 12/28/2006 1:02:00 PM
Hello, Is there a way to allow a multi-valued parameter to provide the default values from another parameter? I have done this successfully when using separate datasets, however within the same dataset, using only one selected parameter value I always receive the error: "The [Hierarchy] ...more >>

Coloring the mx value in a record set
Posted by SalamElias at 12/28/2006 2:39:00 AM
Hi, I have a simple report that displays several records having 2 fields, date field and Quantity field I ma,aged to alternate the colors of line (RosntBrown and black) bu I need also to display the max Qty in a color different of the other ones, how this can be achieved Thanks...more >>

How to export 5 .rdl files to a single excel workbook as diff. she
Posted by puneet at 12/27/2006 10:01:01 PM
Hi, I need to export 5 .rdl files to a single excel workbook file as different sheets. How to export them? I need to write .net code or what? If yes then how? Please guide me on that. TIA ...more >>

SP1 MultiValue Parameter Select All Alternative
Posted by SimonDev at 12/27/2006 6:39:01 PM
Hi I guess the SP1 MultiValue Parameter great disappearing Select All option has been done to death on this news group by now. That isn't exactly my problem but it's related. I've actually solved the basic problem, thanks to suggestions in Brian Welcker's blog (https://blogs.msdn.com...more >>

Reportviewer problem!!
Posted by Henrik Nordgren at 12/27/2006 3:28:01 PM
Hi! I have found a very strange issue with the reportviewer. The CanGrow property doesnt seem to work! This one of my tablecells: <TableCell> <ReportItems> <Textbox Name="textbox13"> <rd:DefaultName>textbox13</rd:DefaultName> ...more >>

Need help with the Reportviewer in .NET
Posted by Henrik Nordgren at 12/27/2006 3:24:00 PM
Hi! Im working with VS2005 and I have created a winforms application that uses the reportviewer to show a report. I have a header with some text, a table which I populate from a datasource, and an image which I also need to populate from a datasource. The problem is that the image doesnt sh...more >>



Data Filtering and Display
Posted by MJ at 12/27/2006 1:30:32 AM
I have a data set with some info - PK, Field1, Field2, Field3 etc. I need to dynamically display columns base don Field1, with Field 2 and Field 3 displaying once for each Field 1. The PK is the row. I figured this out easily enough with column groupings. My next step is to organize it in su...more >>

Problem with sorting in exported Excel document
Posted by Justin30519 at 12/26/2006 7:13:00 AM
Hello. I am using Reporting Services 2000 and Microsoft Excel 2003 running on Windows XP Professional. I have a report that contains sales information that I am exporting to Excel. The first two lines of the report contain title information. They span all columns of the report. For example, th...more >>

Vista/IIS and Reporting Services
Posted by Joel Johnson at 12/25/2006 4:30:13 PM
Any word on when Reporting Services will work with IIS7/Vista? Joel Johnson ...more >>

Supply dataset to subreport
Posted by Locus at 12/25/2006 7:45:02 AM
I allow user to select database during running of my program. So, the program populate dataset for reportviewer just before call RefreshReport as follows: mObjAdaptor.Fill(Me.rep_DataSet.MyQuery) Me.ReportViewer1.LocalReport.SetParameters(mReportParameters) Me.ReportView...more >>

Query dataset locally from code
Posted by Henry99 at 12/24/2006 1:58:01 PM
Hi all, I need to get 20 rows of data from the SQL Server DB to put in 20 Textboxes always one item of one row. It's about Text in various languages, so each language needs 20 textstrings. I don't want to call the Stored Procedure 20 times. So I thought in calling it one time, get the data o...more >>

VARCHAR trivia?
Posted by Elaine at 12/22/2006 9:38:01 AM
In SQL Svr Mgmt Studio, the keyword "VARCHAR" does not turn blue as it does in '00 Query Analyzer. Is there some change in the datatype? Thx...more >>

Customize ReportViewer Animation
Posted by bigcoops NO[at]SPAM hotmail.com at 12/22/2006 7:43:11 AM
Hello All, I am developing an application that queries a database for a large amount of data. The SQL server is not local so the time to query the data can take some time. Once I have the data locally, I send it to the ReportViewer to display. The ReportViewer then shows the "Processing" ...more >>

rsAccess Denied!! The permissions granted to user 'PP2000\Nataliya
Posted by nat at 12/22/2006 4:34:00 AM
Hi, I am running SQL Server 2005 and Windows Vista Ultimate. I have a simple report with 2 textboxes on the layout: one for the title and one to display current execution time. Reports runs ok but when I try and change anything on report properties->execution (for instance to cache the...more >>


DevelopmentNow Blog