Subscription suppression if no data



  • 1. Excel Files Too Large
    Does anyone know if SP1 includes any fixes to the file size of Excel files. We are trying to replace an old reporting tool with RS; however, when exporting a relativly small report the Excel file in 5-15 MB. Has SP1 addressed this issue? There are similar problems with PDF files as well.
  • 2. Expand/Collapse image button (+/-) is reversed sometimes? How to
    Using the Textbox Properties Dialog : Advanced : Visibility tab : You can control the how the toggle initially set, Expanded, Collapsed, or use an expression -- Bruce Johnson [MSFT] Microsoft SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. "Joe" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ... > I have noticed that sometimes the +/- image button displayed next to a collapsable group is reversed, it displays a + sign when it is already expanded and a - sign when it is already collapsed. > > Anyone know what causes this and/or what I can do to fix it?
  • 3. Oracle Stored Procedures
    I have two Oracle servers 8.0.5 and 9.2. The client on my desktop is currently 8.1.7. I have a simple table and a stored procedure that takes two date parameters and returns a reference cursor. Against 9.2 everything works great. When I hit the 8.0.5 database, I can't get it to retreive parameters, reference cursor, or fields. If I develop against 9.2 and deploy and try to point to 8.0.5, Oracle doesn't work. OLEDB complains about a bad datatype. If I change the xml from string to datetime and run it, no complaints and no data. Does anyone have any information on getting stored procedures/packages to work with 8.0.5 databases?
  • 4. % of data region
    You've got the correct basic structure of the expression. It sounds like you're just getting the group name wrong. You want the name of the innermost row group. By default, the group name would be something like "matrix1_fieldname" (unless you changed it). =Sum(Fields!QUANTITY.Value)/Sum(Fields!QUANTITY.Value, "matrix1_subcategory") -- This post is provided 'AS IS' with no warranties, and confers no rights. All rights reserved. Some assembly required. Batteries not included. Your mileage may vary. Objects in mirror may be closer than they appear. No user serviceable parts inside. Opening cover voids warranty. Keep out of reach of children under 3. "Chris Patten" < XXXX@XXXXX.COM > wrote in message news: XXXX@XXXXX.COM ... > I have a Matrix with the subtotal column at the end. > I want to have a calcualed field on the detail row that > gives me a % of the subtotal at the end of the row..tried > many things, none work. > > =Sum(Fields!QUANTITY.Value)/Sum(Fields!QUANTITY.Value, "MatrixRow3") > > This will give me a percent of the total dataset, but not what I want. > =Sum(Fields!QUANTITY.Value)/Sum(Fields!QUANTITY.Value, "datasetname")

Subscription suppression if no data

Postby V2lsbGlhbQ » Thu, 20 Oct 2005 03:34:04 GMT

Is there a way to suppress the execution of an email if a subscription runs a 
report that returns no data?

I am not yet on 2005 if that makes a difference.

RE: Subscription suppression if no data

Postby UmVuZU1v » Fri, 04 Nov 2005 19:27:05 GMT

A way to suppress the subscription is to change your stored procedure so it 
returns nothing at all when there is no data. This makes your report going 
into error state and suppresses the execution of the subscription.

A disadvantage is that you get the anoying message "Invalid attempt to read 
when no data is present".

I 'm also looking for a better solution or a way to customize this error 

RE: Subscription suppression if no data

Postby V2lsbGlhbQ » Sun, 06 Nov 2005 02:12:03 GMT

Thanks for the insight, but I have a SP that returns no data. The 
subscription generates an email with results included, rendered in  Excel 
format. The spreadsheet has a header line, but no data. Do I need to suppress 
the header to get the report to fail as you mentioned? 

Similar Threads:

1.suppression of null data

Is there a way to suppress a line from showing on a report if the value for 
the a field is null 

2.Data Driven Subscriptions with data Driven Parameters

Hey all, 

I've been wondering about this for quite a while...and of course, now my 
boss wants an incarnation of it made before IKE hits the coast (Yee!!!)  
Maybe someone has done this before already in some fashion.  I'm just looking 
foir a yes or no that it can be done...and a pointer on where to do some 

We would like to send our list of email addresses a report that has the data 
customized for that email address.  I guess it could kind of be looked at 
like a mail merge in Word.  A sample would be to have RS send out regional 
sales reports to each of regional managers... where they only see their 
region.  Sounds like a pretty common thing to do... 

From what I have read the Data Driven subscriptions send one report to 5000 
people... but, I need to send 5000 people their individually tailored reports.

3.Data-driven subscription web service data source

I'm using a web service url as the data source for determining the recipients 
of a data-driven subscription. The web service is configured to permit 
anonymous access. When I try to try to set up the DDS to use the web service 
it won't let me specify "Credentials are not required". The error is that 
there must be credentials saved with the report. 

How can I set the DDS to use a web service with no credentials?

4.set DataDriven Subscription Data source to shared data source via code


I am creating a data driven subscription via code.  I have a shared data
source I wish to use as the data source for this data driven subscription.

How do you set the DataRetrievalPlan.Item property so that the subscription
is set up to used the shared data source

(instead of getting the shared data source I am getting a copy of the data

many thanks


5.Data Driven Subscriptions outside the network missing data table

I have a Data Driven Subscription sending to a dynamic list of email address 
that do not belong to my domain.  The subscription sends fine but the data is 
completely missing from the reports.  If i send to an email address on my 
domain I can see the data.  Is there a way to somehow embed the data into 
html or something. 
Yes, I searched first :)

6. NullReferenceException when using data-driven subscription with custom data extension

7. Calculated Members, All Member Suppression

8. Zero / Null Value suppression problem in Excel Pivot Table



Who is online

Users browsing this forum: No registered users and 88 guest