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 > july 2006 > threads for friday july 14

Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Parameters with Crystal Reports.
Posted by Kevin Burton at 7/14/2006 8:58:01 PM
I have set up some (three to be exact) parameters in a report that I want to be able to print. Before I set the parameters everything worked just fine. I set the datasource and the printout worked great. Now I add parameters to the report and it seems that no matter what I do, I get an excepti...more >>


how to turn off scrolling
Posted by Carl Henthorn at 7/14/2006 5:08:02 PM
I have a matrix report that has the grouping columns and headers scrolling over the data so we cant see it. How do I turn this behavior off? Thanks!...more >>

How to get the record created date?
Posted by tcw at 7/14/2006 4:15:23 PM
How do I delete rows that are older than 180 days if the table does not contain a column of timestamp? The following statement works fine if parameter startdate is known: DELETE From MyTable Where DATEDIFF (day, startdate, GETDATE()) > 180 Thanks in advance. -tc ...more >>

Workaround needed for page break between detail rows.
Posted by Tim Dot NoSpam at 7/14/2006 3:56:07 PM
I have a scenario where my report layout [Header Group] [group 1] - repeat header new page, page break [group 2] - repeat header on new page [Detail row 1] [Detail row 2] Will break detail row 1 and detail row 2 apart and page break in between rows. I have Keep Toget...more >>

XML Data Source Method not returning fields
Posted by John A at 7/14/2006 3:12:02 PM
Hi all, when I first learned about the ability in SQL Server 2005 Reporting Services to use a Web Service that returns an XML Data Set as the Data Source I was thrilled. However I am having a small but very frustrating problem. I have a number of Methods in my web service and all but one...more >>

CreateSubscription
Posted by Tony at 7/14/2006 1:07:01 PM
I am trying to use the article at http://msdn2.microsoft.com/en-US/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx to create a subscription. When I try to run the page I receive the following error message: Compilation ...more >>

How to set up row/column labels for matrix report?
Posted by yongli at 7/14/2006 12:26:02 PM
It seems the row/column lables are not automatically created in the matrix report as in table report. Anyone know how to do this? Thanks,...more >>

Conditional totals for matrix report
Posted by Carl Henthorn at 7/14/2006 12:19:02 PM
I have a matrix report that has the value of one (1) in the row field when my row header has that value. agent air hotel cruise ------- ---- ------ ---------- bob 1 1 jim ...more >>



Implimenting additional export types
Posted by John J. Hughes II at 7/14/2006 11:07:12 AM
Is it possible to add additional export types to the list, link to sample code would be nice. Select a format (Export) XML file with report data CSV (somma delimited) TIFF file Acrobat (PDF) file Web archive Excel ---- MY NEW TYPE --- Regards, John ...more >>

Does the reporting server have to have SQL installed too?
Posted by User at 7/14/2006 9:35:18 AM
Say the Reporting server has iis and the db server is on a seperate server running SQL? ...more >>

breakpage in details
Posted by show the last row of details on new page at 7/14/2006 8:37:02 AM
Hi, I have a table with a header, footer and details. I add in my table a group with a header and footer but without details. So the probleme i have is that the last row of my table's detail is show on new page. Anybody can help me to resolve that. Thank's. ̉ۡric...more >>

Reprot description not getting updated.
Posted by vRam at 7/14/2006 7:35:02 AM
I publish an RDL to report server using web service, then later i have a modified RDL which has the the report description changed. I republish with "Overwrite" on my existing reprot using webservice. The description is not getting updated in report manager. If i edit the new report form re...more >>

Choosing an RDBMS for Reporting Services....
Posted by Deejjaayy at 7/14/2006 3:46:01 AM
Hi All, We would like to use as much of the SQL Server 2005 Reporting Services functionality as is possible, even though we (as a firm) are standardised on Sybase... I've been reading the documentation/information and there is a ton out there!!! My main question is - is it possible to us...more >>

Impersonate problem in 2005
Posted by ReneMo at 7/14/2006 1:19:01 AM
Hello, I'm migrating from RS 2000 to 2005. Some of my reports use a custom assembly who makes use of WindowsIdentity.GetCurrent() to retrieve the login name of the report user. Although the Reports web.config contains: <authentication mode="Windows" /> <identity impersonate="true" /...more >>

RS 2000 & RS 2005
Posted by AVG at 7/14/2006 12:00:00 AM
From other posts I have read, I understand that SQL Server 2000 and 2005 can co-exist on the same machine. What about RS 2000 and RS 2005? This is a development machine and I need to be able to create and deploy reports in both versions? TIA, -- AG Email: discuss at adhdata dot com ...more >>


DevelopmentNow Blog