Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

Report Scheduler...

edited January 2004 in General
Microsoft SQL server report services has an interesting feature that I was
wondering if Digital metaphors or perhaps a 3rd party would consider
developing or it is developed already.

In the report services you are able to schedule a report for execution and
delivery. So you can say for instance execute this report on Monday nights
and deliver it via email to this group of people.

Any thoughts on the future direction of digital methaphors regarding this
topic?

As an existing and very happy report builder customer, I would like to have
this feature for an application but don't want to re-invent the wheel.

Thanks,

Isi Robayna

Comments

  • edited January 2004
    Isi R wrote:


    Well as far as I know there're some products enabling RB to produce PDF
    - depending on your development tool there should be some other third
    party components for sending mail?

    Why not take windows planned tasks to run your app using a command line
    that makes it create a pdf, send it and terminate? Thats not
    re-inventing the whell but customizing it a bit.

    Kind regards,

    Mark
  • edited January 2004
    I have made just that for a customer. Reports are
    created by a com+ object and this com+ object
    is started by a windows ntservice at a specific time.
    There a dayreports, weekreports, monthreports and yearreports
    all created at specific intervals, as the name already suggested!
    After the com+ object has created the reports they
    are send by mail (in pdf format, mostly)to certain people.
    The settings for all this are stored in a database and
    can be easily adjusted.

    greetings,

    Rob Segerink



  • edited January 2004
    "Mark Meyer" wrote in message news:400e9bf1




    I've done exactly this, and it works very well. RB to create reports.
    Pragnaan to render as PDF. Indy (in the Delphi box) to send email. Windows
    Scheduler (etc.) to run it at an appointed time.

    There isn't really anything reporting-specific about a scheduling tool, so
    I'd say that the tools you are asking for already exists. There are plenty
    of scheduling mechanisms around, including several build in to Windows.

    That said, some people like all-in-one-box solutions, it would be valuable
    to some RB users to have the RB report server include a schedulable report
    feature.

    --
    [ Kyle Cordes * kyle@kylecordes.com * http://kylecordes.com ]
    [ Better processes, better design, better software. Java, ]
    [ Delphi, BDE Alternatives Guide, Enterprise apps, and more ]
  • edited January 2004
    Absolutely,

    As a matter of fact, I would be willing to pay for such a tool (depending on
    a "reasonable" price)

    Regards,

    Isi R.


  • edited January 2004
    try visualchron at efg pages.
    it suits my needs for years.
    Didier

    "Isi R" a ?crit dans le message news:
    400fb4df@dm500....
    on
This discussion has been closed.