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 2005 > threads for friday december 9

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

disabled fields, such as Upload File, in Report Manager
Posted by Shang at 12/9/2005 8:47:02 PM
When I open Report Manager through IE on server 2003 installed with reporting service and login as an admin through remote desktop connection, I can see all the features but disabled. I can not Upload File, Add New Data Source etc.. What is wrong? Please help....more >>

Parameter in WHERE clause using Functions
Posted by BLKeller at 12/9/2005 2:32:03 PM
I'm trying to use a report parameter in my where clause to compare against the month portion of a field. Reporting Services (version 2000) does not seem to like this. Here's the WHERE clause I'm trying to get to work (of course it's all on one line): WHERE (company = @Company) AND (MONTH(cl...more >>

non-typesafe data reporting
Posted by Chris at 12/9/2005 12:47:54 PM
I have vb.net 2005 code that generates data that needs to be reported. The results need to be reported in generic text fields in the rdlc report. Sometimes I will report 2 text values while the next time I may report 3 values in the report text box. My problem is that I can't pass this progra...more >>

Reporting Services Consume A Web Service
Posted by Chris at 12/9/2005 12:27:19 PM
Is it possible to have a Reporting Services consume a web service that generates a dataset, then turn around and generate the report based on that dataset? I'm using SQL Server 2000. I'm trying to implement a middle web service based tier and would like to prevent reporting services from intera...more >>

LIKE '%' + @Parameter + '%' Does not work anymore?
Posted by barhoc11 NO[at]SPAM gmail.com at 12/9/2005 12:05:36 PM
When I use this statement to allow the user to enter in a wildcard '%' to search for all vendors I do not get anything returned when they put in the %. When they enter in a vender number it will filter and get the correct data. I use this LIKE statement on other reports that are based off of dif...more >>

Unable to execute LOGON AS
Posted by Larry Charlton at 12/9/2005 11:47:02 AM
I'm trying to test an upgrade to reporting services 2005. Most everything works except subscriptions. When the subscription runs it fails with the error message: 'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITY\NETWORK SERVICE'. The step failed. I've tried creating an u...more >>

System.Security.Permissions.SecurityPermission
Posted by Jedi Punk at 12/9/2005 10:40:50 AM
Before I go any further, let me admit I have searched all over for the fix and nothing is working. Here is my Error The hidden expression for the table 'table1' contains an error: Request for the permission of type System.Security.Permissions.SecurityPermission, mscorlib, Version=1.0.5000.0,...more >>

Trail version expired
Posted by GeorgeJ at 12/9/2005 9:33:02 AM
Hello: I designed some reports on SQL Reporting Services Trial version. At this moment this version has expired. How I do to reinstall the full version without losing the reports defined on trial version? Thanks....more >>



SQL RS2005 The request failed with HTTP status 401: Unauthorized.
Posted by Rob G at 12/9/2005 8:19:02 AM
This work fine running .aspx and viewer with remote processing mode if running on local iis same as report server. I using Windows 2003 servpack1 and RS2005. This works locally: <rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote"> <ServerReport ...more >>

Code Access Security
Posted by Joel Daniels at 12/9/2005 8:09:03 AM
I am attempting to customize code access security so that a custom assembly can read from the registry. I added a new permission set like this: <PermissionSet class="NamedPermissionSet" version="1" ...more >>

Reporting Services Query
Posted by pieter.lessing NO[at]SPAM gmail.com at 12/9/2005 1:37:53 AM
Hi SQL Reporting Services 2005 is the first reporting tool I have ever used so I am battling a bit to set up some of the reports I'd like to create. I'd very much appreciate some help. Question 1 Take the following simple dataset as an example. VALUE 100 120 150 500 501 502 520 ...more >>

Continuous blanks
Posted by Dai Zefeng at 12/9/2005 12:00:00 AM
Hi, I need a column with title "Sales Revenue"(4 blanks between two words). It is ok to be viewed in report designer, however, when view it in IE, it is shown as "Sales Revenue", because IE will take continuous blanks as a single blank. Is there any way to keep the format? Thanks, ...more >>


DevelopmentNow Blog