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.
Subscription suppression if no data
3 posts
• Page 1 of 1
- IBM PC
- cad
- Windows Media
- fortran
- MS SQL SERVER
- Computer architecture
- ms windows
- msn
- web Designer
- vms
Jump to:
- 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")
Next
Subscription suppression if no data
by V2lsbGlhbQ » Thu, 20 Oct 2005 03:34:04 GMT
RE: Subscription suppression if no data
by 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 message.
RE: Subscription suppression if no data
by 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:
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 research. 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
Hi, 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 source) many thanks Matt
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. Thanks -- -------------------------------------------- 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
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 88 guest