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 2004 > threads for monday december 27

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

No Data-Driven Subscription Button
Posted by Joel Rumerman at 12/27/2004 5:22:18 PM
Hi, I have a test server and a production RS server. On the test server I can create data-driven subscriptions with no problems. However, on the production server I do not get the "New Data-Driven Subscription" button and I can't figure out why. - I'm a domain administrator so I have loc...more >>

How to replace #Error to 0 (Zero)
Posted by Sam at 12/27/2004 3:37:02 PM
I have some report fields with complex expressions. The expression includes functions like abs(), sum() as well arithmetic operations. Example: =Code.GetSumResult( iif(Fields!Measures_A.Value.ToString().IndexOf("Percentage") > 0, Fields!Measures_Xyz.Value, iif(Fields!Measures_A.Value.ToStri...more >>

Filter problem
Posted by Matt Smith at 12/27/2004 3:22:06 PM
Under the Filters tab of the properties of several objects within the Reporting Services report designer their are 3 columns that correspond to the child tags of the filter tag. There is also a fourth column labelled 'And/Or'. This column seems to always be greyed out, and automatically places...more >>

Alternative to IIF ? Case ?
Posted by saustin99 at 12/27/2004 2:35:06 PM
Hi, Need to display a value in a text box based upon perhaps one of four values a parameter could have. This example is great for two values, = iif(UCASE(Parameters!SUPPID.Value) ="HHH", "Defense & Space", "Defense") Is there an alternative , case.... anything if we need to test for over...more >>

Reports for Multiple SQL Databases
Posted by Rob Edwards at 12/27/2004 2:31:01 PM
I would like to setup a Report server... so it can be used as the primary reporting server for the SQL databases in our environment. I've installed Windows 2003 Standard Edition, all necessary IIS components, SQL 2000 (with SP3), Reporting Services (with SP1). I used a domain account inste...more >>

Exported PDF Security
Posted by Vaibhav at 12/27/2004 2:15:41 PM
Hi All I am using SQL Reporting Services. I looked into the properties of the generated .pdf file and it allows user to edit the file contents using a full version Adobe Acrobat. Is it possible to make the exported PDF file uneditable ? Any help on this will be hisghly appreciated Th...more >>

aspnet_wp.exe could not be started.
Posted by Helpme Rhonda at 12/27/2004 1:17:02 PM
When I launch the reporting services report server on my sql server, I recieve the following error: "Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry ...more >>

Getting query associated with a dataset
Posted by billd at 12/27/2004 11:39:02 AM
Is it possible to get the post-processed query that is associated with a dataset? I need to see the SQL or MDX query that is produced *after* the IIF(), Code, Parameters, etc. have been evaluated. For example, immediatley after I create the report (via CreateSubscription) I would like t...more >>



Visibility on Export to Excel
Posted by CGW at 12/27/2004 11:17:06 AM
I'm having two problems with exports to Excel and hope that someone can help. Our reports are straightforward (tables, few matrices, nothing nested). They each contain textboxes who's visibility is toggled and are switched to hidden=false before export. However, no matter how we work it, they ...more >>

accented_characters_and_ñ's
Posted by Diego Belay at 12/27/2004 9:15:37 AM
Hi, I have a problem in a rss script, when i try to create a folder name that contains accented charactes or ñ's, the folder is created WITHOUT these characters. Example: rs.CreateFolder("Ñandú", "/", Nothing) I run the script and then i go to the report manager and the folder create...more >>

Report manager
Posted by Willem01 at 12/27/2004 6:15:03 AM
Hello, I'v tried several times to install RS on a local machine. The install seems to be succesfully, but i can't see/find the report manager. Everything else is vissible. Anyone?...more >>


DevelopmentNow Blog