Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ashok_S
Starting Member
5 Posts |
 Posted - 2005-06-09 : 04:49:50
|
| I am using Reporting Services To send mail to the users reg Contract Renewal Details Daily based on condition 7 days before the contract validity end date.if there is no record the mail should not be send to the user.but in my case the report displays only the Page header,i.e, our company name and Report name and no data found in the web archived report. I dont want to sent the report thru subscription if recordcount is 0. What to do if I want to disable the subscription only if recordcount is 0.Help Me.Ashok |
|
|
jhermiz
3564 Posts |
Posted - 2005-06-09 : 08:46:24
|
You cant do this directly in reporting services, however what you can do is create a vs.net project. The project has to reference the reporting service reference to make available all the various objects / properties. From here you will have to make a connection to your database, call a procedure that doesIF EXISTS(SELECT * FROM yourTABLE WHERE...) and return a status code of true or false. If the code is true records exist so you will have to instantiate a reporting service object and look into sending that report. This would all have to be done via code.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
Ashok_S
Starting Member
5 Posts |
Posted - 2005-06-10 : 03:30:37
|
| I have already designed the report and I have not written a single line of code there. If View code is selected, XML code displays. What Procedure follow to add that code into form. Send me Some Sample Code.Pls Help. |
|
|
|
jhermiz
3564 Posts |
Posted - 2005-06-10 : 10:12:39
|
Read what I posted, you can not do this directly in the XML, you will have to use reporting services objects (check RS BOL for the various objects / properties you can use).A report cant trigger the logic that you are wanting, but MS provides you with an entire framework and an object model to perform this task. It is not so difficult if you look at the help files, its like creating an object and calling a method of that object is all it is.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
|
|
Stop Subscription