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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|