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 > june 2006 > threads for thursday june 29

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

Does chart support more than 800 points?
Posted by Jun Yuan at 6/29/2006 11:34:02 PM
I'm using SQL Server 2000 Reporting Services. I want to create a curve using chart for a series of data. If the number of points (x axis) is small (less than 800), the curve is displayed correctly. But if the number of points is more than 800, the curve cannot come out, after about 1 minu...more >>

Prblem with MSDN Article on forms authentication for rs2005
Posted by vamsi at 6/29/2006 4:42:38 PM
Hi All i wanted to implement foms authentication to RS2005.i am using the MSDN article to implement the forms authentication.when build the project i am getting this error. 'Microsoft.Samples.ReportingServices.CustomSecurity.Authorization' does not implement interface member 'M...more >>

Parameters behave as if they are cascading parameters
Posted by erdal akbulut at 6/29/2006 3:15:06 PM
Hello, I have created a report which use MS SQL Server 2000 Analysis Services. I am using MS Reporting Services 2000. I have 7 parameters, 3 Of them are also linked to olap data source. The other 4 parameters are non queried. Every parameter has non-queried defaults and some defaults use e...more >>

A URL expression problem with a Jump to command
Posted by Hotwheels at 6/29/2006 2:05:02 PM
I have a report that uses the table control, the last column has id's for dealcompanies in it(Fields!res_dealCompanyid.Value). When the user clicks on any of the other Columns in a row I would like to be able to grab the id from the last column in the row and insert it into the expression for ...more >>

SWITCH statement
Posted by K. Thomas at 6/29/2006 12:57:02 PM
What's the best way to display "approved" when a status field is "A", "pending" when a status field is "P", etc? Would the SWITCH statement be best? If so, what is the syntax for this and where do I put it in my report? Any suggestions are welcomed. -- K. Thomas...more >>

Rendering Problem in PDF and Tiff
Posted by GaryDean at 6/29/2006 12:28:11 PM
using ssrs 2005 I have a report that looks fine in the preview and in mhtml. But in Tiff and PDF it page ejects and takes another blank page and an eject prior to printing a textbox. The textbox is as wide as the page width (I have made it narrower and played around with the height in the lay...more >>

Avg Date Diff?
Posted by naomimsm NO[at]SPAM gmail.com at 6/29/2006 10:49:27 AM
Has anyone had any luck getting an Avg on Date Diff? Here's what I'm trying to do: Figure out the average time it takes from ringtime (datetime) to starttime(datetime). Any ideas? ...more >>

SQL Server 2005 Uninstall failure
Posted by matt at 6/29/2006 10:15:03 AM
I am having some issues trying to uninstall SQL Server Reporting Services 2005. We are running: Win 2k OS Sql Server 2000 NO reporting services Sql Server 2005 w/reporting services When I try and uninstall my previous version of SQL 2005, everything uninstalls with the exception of report...more >>



Subreport Could Not be shown
Posted by GaryDean at 6/29/2006 10:06:26 AM
Sometimes my subreport renders fine in the preview environment. An then sometimes I simply get the message Error: Subreport Could Not be Shown. There is no clue given as to why it cannot be shown. I just have to do random things with the layout and hope it shows. Is there a more scientif...more >>

rsReportNotReady error
Posted by Rich at 6/29/2006 8:40:06 AM
Hi all, We've started having problems with our SSRS 2005 reports in the last few weeks, whereby users get the following error when they try to access reports: "The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotR...more >>

Force textbox to break across pages on PDF
Posted by Ryan at 6/29/2006 8:13:36 AM
Textboxes with lots of data force page breaks when exported to PDF if they do not fit onto the remainder of the page. This leaves a lot of whitespace on the previous page which looks odd. Does anyone have a workaround that will split textboxes across multiple pages when rendering to a page bas...more >>

Index was outside the bounds of the array.
Posted by vRam at 6/29/2006 7:17:02 AM
I am getting the following message when trying to export a report to PDF format --------------------------- Export Error --------------------------- Index was outside the bounds of the array. --------------------------- OK --------------------------- The report works fine in all other f...more >>

Deploying Reports
Posted by GaryDean at 6/29/2006 7:06:39 AM
this is about two related issues... We tried to deploy by backing up the ReportServer DB on my XP dev box and restoring over an existing ReportServer DB on a Server 2003 box. After the restore, when trying to go to /localhost/reports we got "login failed for 'NT AUTHORITY\NETWORK SERVICE'. ...more >>

background images and external URLs sorting problem
Posted by BLV at 6/29/2006 7:02:02 AM
I have created a report which uses an external .bmp accessed through a URL as the background image of the header (i.e. to brand the report with the company logo). this works fine until I use the interactive sort function which causes the image to disappear. refreshing the report brings back...more >>


DevelopmentNow Blog