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 > may 2006 > threads for friday may 19

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

Performance issue with reporting services
Posted by msdnuser at 5/19/2006 8:16:01 PM
Hi, We have reports with dynamic sql involving subqueries,cte,a single parameter containing the whole where clause etc in the dataset. Then in the layout we have table with drilldowns to 4 levels and the data will appear in 5th level without any further drill downs. Also we are forced to in...more >>

excel export problem
Posted by msdnuser at 5/19/2006 8:05:01 PM
Hi all, We have a big report with 4 or 5 levels of drill downs and various other expressions. While exporting to excel format, unlike other formats, the drill down capability and other expressions as formulas are also exported. Thus if the report that is exported is large then exporting do...more >>

Install Report Designer without SQL-Server-DBMS
Posted by Christian Nein at 5/19/2006 7:11:24 PM
Hi, I would like to design Reporting Services-reports with Visual Studio .NET 2003 by using the Reporting Services Report Designer. VS 2003 .NET is installed on my local machine (OS=Win XP Prof.) and the Report Server I want to use is an already running Reporting Services installation (SQL ...more >>

I need custom security context - is it possible?
Posted by Tomasz Jastrzebski at 5/19/2006 6:43:29 PM
Hello, My SSRS report needs to query exchange servers, via http based WebDAV protocol, to get users mailbox summary data. Technically it can be done but the problem is security. The WebDAV query needs to be issued using security context other than the context used by SSRS service or the c...more >>

Formatting cents
Posted by Scott at 5/19/2006 12:49:02 PM
I am using RS 2000 and I am trying to format a total amount. I want the total amount to be separted into two separate text boxes, one with dollars and one with cents. I am able to get the dollars portion but unable to get the cents portion. For example: If I have 123.05 I want 123 in box A ...more >>

Saving an embedded image
Posted by Dan Wood at 5/19/2006 11:27:01 AM
Is it possible to save an embedded image back to the file system? I have a report than has an embedded image and I want to be able to save it. Is this possible? Thanks in advance for any help. ...more >>

To Microsoft: Best practices for standardizing report appearance?
Posted by Chris G. at 5/19/2006 9:10:02 AM
To Microsoft: I am posting this via Managed News Groups in the hopes that someone from Microsoft can shed some light on this topic. Via the Microsoft forums I have gotten suggestions from the community, but since this is an important topic (at least to me) I would like to hear Microsoft'...more >>

Re-install Reporting Services
Posted by luvic.vangool NO[at]SPAM gmail.com at 5/19/2006 8:44:09 AM
Hi, I had to re-install IIS for an unrelated development issue. As a result, I now need to re-register reporting services (and its webs etc) in IIS. I can't seem to do this through simply "Add/Remove" because I get the error: "The setup failed to read IIsMimeMap table. The error code is -...more >>



The remote certificate is invalid according to the validation procedure.
Posted by mjpmsa NO[at]SPAM yahoo.com at 5/19/2006 7:53:10 AM
Server administration question here. I set up Reporting Services to run on multiple websites on one IIS webserver. Report Manager is only installed on one website, but the /reportserver virtual directory exists on all of them. The websites are all anonymous authentication using local users...more >>

Paging in Drill Down Reports
Posted by Piyush at 5/19/2006 7:49:02 AM
My requirement is that i want to have paging i.e show 20 records per page in a Drill Down report. How to do it or where can i find a solution to this? Thanks in advance......more >>

Error using rs.FireEvent
Posted by Shrinivas at 5/19/2006 6:06:12 AM
Hi all , I am using rs.fireevent () class for firing an event but I a getting an error My script code is Sub Main Dim rs As New ReportingService() rs.Credentials = System.Net.CredentialCache.DefaultCredentials Dim subs As Subscription() = rs.ListSubscriptions("/Reports...more >>

Sending Email Using Rs Utility
Posted by Shrinivas at 5/19/2006 2:04:12 AM
Hi all, I would like to know can we send schduled reports through email using RS utility provided by reporting service. If any body can explain me how I will be greatul to him. Regards Shrinvas ...more >>


DevelopmentNow Blog