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 2006 > threads for monday october 23

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

Don't send report if it has no data
Posted by Sanjeev Rampersad at 10/23/2006 3:06:46 PM
Hi All, I have the standard version of SQL Server installed. I have setup a few reports that will be automatically sent to some out clients on a daily basis via a normal email-based subscription in reporting services. On some days, these reports are blank i.e. no rows returned in the datase...more >>

Report Server Windows Service cannot connect to the report server
Posted by Mike at 10/23/2006 11:59:02 AM
We are experiencing the error below on our SQL Server 2005 server. Any help would be appreciated. Thank you. Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database. -- Mike...more >>

RS Repository database version is dorked up, named instance has higher number than base instance, now can't access it.
Posted by Steve MunLeeuw at 10/23/2006 11:45:12 AM
I installed a named instance but can't upgrade the database. The found version is higher than the expected version. I read some blogs and it's probably related to sp1. The config tool for the named instance gives me all green but when I try to access the reports I get the following error. ...more >>

AD Synch in Sql Reporting Services
Posted by Rob Bowers at 10/23/2006 11:45:03 AM
Is there a way to do an AD Synch in Sql Reporting Services? In short Groups have been created in AD. Roles were also setup in SQL Reporting for the folder that we wanted permissions applied to. When I add a person to a global group in AD, the permissions will not work in SQL Reporting. T...more >>

Custom Assembly config file and named instances of Reporting Services
Posted by Steve MunLeeuw at 10/23/2006 11:25:18 AM
We have a custom assembly that is using a config file. We park the config file in the instance folder of RS along with the dll. We look in the registry to find the instance. When there are multiple instances of RS I am not identifying the correct instance to locate the correct custom assemb...more >>

comparision filter on a float field
Posted by marg at 10/23/2006 11:15:02 AM
I'm trying to do a comparision filter on a float field and I keep getting the error > Expression =Fields!float_cal.Value > Operator <= > Value =0 I keep getting the error 'check data type returned'. I tried > Expression =CInt(Fields!float_cal.Value ) but this did not work either. ...more >>

I do want Collapsed Columns (+/-) to export in excel.
Posted by Sanjay at 10/23/2006 11:10:03 AM
Hi, I have a simple requirement, I do want to show columns in collapsed mode(with +/-) when it is exported to excel. i.e I have some groups in report and by default they are in collapsed mode, so when we click on export to excel, data in excel also shows with +/- which I don't want. Any id...more >>

VS.NET 2003 and MS SQL RS 2005
Posted by Arjun Prabhu at 10/23/2006 10:41:37 AM
Our team is kind of new to SQL Server Reporting Services, and we are very keen on using Reporting Services in our Application due to the feature set it offers. We have the following setup.... 1. Application data - in SQL Server 2000 (say in Machine X) 2. Web Application(ASP.NET) - .NET 1.1 ...more >>



specify paper orientation for render/print using deviceInfo?
Posted by Rich at 10/23/2006 10:29:03 AM
Hello, I found some code for rendering/printing a report from the client using a deviceinfo string and stream. The following deviceinfo string prints in portrait. How can I specify landscape? I tried adding a field to this string <DeviceOrientation>. I am hit/miss here, and this did not...more >>

Domain Authentication
Posted by Chris Hornung at 10/23/2006 8:51:01 AM
I need to get the Data sources that use Domain Authetication functioning. I have an internal Web Server Set up that is using "Integrated Windows Authntication". That box is checked in the "Authenitcation Methods" dialog box of the Default Web Site Properties page's Directory Security Tab. ...more >>

matrix apperaance
Posted by Brian L at 10/23/2006 8:45:02 AM
Anyone have any idea how to get a matrix to display a different background color for every other row? ...more >>

How to pass Report Parameter in the URL directly
Posted by jimmy at 10/23/2006 2:36:01 AM
hi I have set up a report parameter in a report and I want to pass the parameter value to this report through URL directly. Such as: http://host/Reports/Pages/Report.aspx?Itempath=...... &Report_Parameter_1=2006&rs:Command=Render...... However I met a problem and the error message is:...more >>


DevelopmentNow Blog