Databases Reference
In-Depth Information
In the present case, there is only one tablix but in general a tablix may contain
many more tablix, charts, and other widgets. However, for describing the
principle involved, the one chosen is sufficient.
The data chosen is cached data feed and it is preferable you run the report
before setting up a rule.
Rules that you set up are very similar to the filtering you
do on data. You can set up rules based on Values as well
as Fields. The fields in the left are automatically displayed
while customizing the rule.
Rules are stored in the alerting database in XML format. Here is a sample of
rules in the database.
<data-condition xmlns="http://schemas.microsoft.com/
rsalerting/2011/03/alertdefinition">
<scope>Any</scope>
<clause>
<is-or-clause>False</is-or-clause>
<expression-type>String</expression-type>
<left-operand>CompanyName</left-operand>
<operator>Equal</operator>
<right-operand>
<operand-type>Value</operand-type>
<value><![CDATA[Jet Shipping]]></value>
</right-operand>
</clause>
</data-condition>
Here is a simple rule to alert the receiver of an e-mail when there is an entry
in the
CompanyName
field of a company that has the
Jet Shipping
string in it.
From the drop-down on the right side of
CompanyName
in the rule there are
other comparisons (
is
,
is not
) possible. The name of the alert is different from
its default name (name of the report). Since you can create multiple alerts to
the same report, a named alert is highly recommended to do a follow up.
The scheduling of the report is very similar to the scheduling in Report
Manager you have seen in
Chapter 4
,
Working with Report Manager
. The e-mail
recipient and description are choices that you make to deliver your data alert.
Follow this link to learn more about alert rules and alert schedules:
http://technet.microsoft.com/en-us/library/gg492254.aspx
Search WWH ::
Custom Search