Hi All,
I have a requirement to run a crosstab report daily and compare it with previous day's output and send an email in following cases :
a ) if there is any difference in numbers in any of the intersection.
b) if any new row is added to the crosstab.
Report output Format : HTML.
Your help would be highly appreciated.
This could be done via SDK or Event Studio.
For Event Studio, you could create stored procedures that return row count and summary totals. I don't know your full requirements, but presumably if the intersection values are different then the rollup totals should generally be different. If both conditions are met, send an e-mail.