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 2005 > threads for friday june 17

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

reporting services emails
Posted by helpful sql at 6/17/2005 2:25:56 PM
Hi all, I have created a Reporting Services Report and now I am trying to schedule it to be emailed every week. I made sure the RSReportServer.config file has correct values in SMTPServer(this is set to IP Address of SMTP server) and From(This is set to the e-mail address we created to use...more >>

Is there a URL to re-install the RSClientPrint.dll
Posted by Kyle Jedrusiak at 6/17/2005 2:00:35 PM
We have a missing or curropted RSClientPrint.dll on several machines. Is there a URL to our server that will just install the dll as opposed to having to acutually running a report? Kyle! ...more >>

URL, Frames, Hyperlinks and breaking out
Posted by Jim_OLAP at 6/17/2005 2:00:01 PM
Hello, We are using an ASP multiple frame application to display reports using the URL method. It's a traditional format, with report names on the left frame and report display on the right side frame. The problem we are having is that we cannot break out of the multiple frames when usin...more >>

Images render in designer but not in Report Manger or Report Serve
Posted by Keith Powers at 6/17/2005 1:56:04 PM
The scenario is: image UNC paths are stored in the DB; I call a report code function that receives the Field.ImagePath and returns a binary array (Byte()). This works in designer but access via Report Manager or http::\\MyServer\Report Server yields the notorious redX. -- Keith Powers,...more >>

Manage TextBox.Value in other TextBox for calculations
Posted by Dario Concilio [MCP] at 6/17/2005 10:57:15 AM
Hi, I need to know if and how can I do this: tbTotal tbNumber1 tbNumber2 ? 12 5 ? 3 7 If I've some rows and I want insert in expression of tbTotal the pseudo-code tbNumber1+tbNumber2 how can I do this? I need...more >>

rsactivate returns error, unable to activate error
Posted by hcas at 6/17/2005 10:49:05 AM
Failure starting the web service: Unexpected database error (-2147159548) 0x80004002...more >>

Licensing RS when deploying reports to the web
Posted by Dan Friauf at 6/17/2005 10:01:12 AM
We are currently evaluating RS as a reporting solution. I have explained that the license for RS is part of our SQL Server license and that no additional license is needed. However, management is concerned that once we begin to deploy reports to the web, outside our firewall, that the licens...more >>

Very Large PDF Report Problem
Posted by Chuck at 6/17/2005 10:01:02 AM
Hi, We use subscription to generate more than 1500 PDF page reports. They were fine for the past few days, but it starts failing to generate PDF report that has 2000 pages every day. Does anybody know why? Does it reach max PDF size or there is a rendering issue? Thanks. Charles...more >>



Finding the Security Group(s) of User!UserID
Posted by Todd Chittenden at 6/17/2005 9:44:04 AM
I can see where the Global Parameter User!UserID will return the domain and userid of the person logged in. Is there any way to test for membership in a security group of that user? In VS.NET there is the User.IsInRole("my_Domain\Security_Group") function but I cannot seem to equate that in...more >>

Symmetric Key Error
Posted by Darrell at 6/17/2005 9:37:52 AM
I seem to be able to run and view reports in the Report Manager. In fact, I can do just about everything I need to do. I have created a push subscription with not problem, and even worked on the development server. When I moved the report to the production server and created the subscription, ...more >>

Moving Reporting Services
Posted by Donnie at 6/17/2005 9:29:37 AM
My current setup is this: SQL 2000 Reporting Services SP1 is on Server A SQL 2000 Reporting Services Databases are on Server A I have moved reporting services as follows: SQL 2000 Reporting Services SP1 to Server B SQL 2000 Reporting Services Databases to Server C I have done this foll...more >>

Field Not Recognized In Dataset
Posted by CaskeyRW at 6/17/2005 8:09:12 AM
I have a dataset that I was using in a report that I determined I needed to add a field to. After I changed the query to include this field, the field is not displaying as part of the dataset when I look in the field browser or try to use the field in the report. The field I have added is "Q...more >>

Cannot open a connection
Posted by mlugoc at 6/17/2005 7:55:01 AM
I am using reporing services in my c# web application. When I debug my web application, the reporting section show me the following error: "The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rs...more >>

Use report definition language in asp.net application
Posted by Kishor at 6/17/2005 3:57:17 AM
i just need add the reference of the rdl in my .net application and well i need the reporting designing envoirnment at runtime to. How can i do this ? PLz help me....more >>

top n detail rows
Posted by pcalv at 6/17/2005 3:23:14 AM
Hi I am trying to limit the numbers of returned detail rows in my report to 5 at most. I know you do something with rownumber and grouping but i'm not sure of the syntax. Hope someone can help. Thanks Paul...more >>

Generating Percent problem with divide by zero
Posted by Leon at 6/17/2005 2:24:08 AM
Im trying to generate a percentage value on a agregated field but in some groups there isn't any information so it tries to divide by zero and i get an error So i thought id use a IIf to se if either the Value or the Total was zero and write out 0 % but the IIf seems to be running the calcul...more >>


DevelopmentNow Blog