Generating reports using data feeds from other systems

Dear all,
I've been following this group with interest for a while now but haven't
seen any firm pointers for a solution to meet my problems.
Essentially I would like to be able to
1) Create reports, acknowledgements, delivery notes, invoices, etc using
data supplied from my legacy system Unix.
2) Output them to PDF - some of the parameters of this would be in the data
feed.
3) Email or fax these PDFs to our customers.
It's not possible Reporting Services to query directly our system due to
other limitations, but can we feed RS with data either via uploading a file
to a "watch" directory or via a print spool queue on the windows system - we
already use both methods for other applications.
The reason for a print queue is it's easy to implement from Unix to
Windows - no messing with FTP etc, and print queues already exist in our
application.
The format of the data feed can be XML or indeed anything as we are source
code holders for our product.
The questions are:
1) Is this vaguely possible. ?
2) Can RS take it's feed from a print queue - with possibly us putting
together the software to accept the data on the print queue.
3) Could it handle files dropped into a "watch directory"
4) Can RS create PDFs using parameters in the feed file.
5) Could RS, with perhaps additional development, distribute the PDFs based
on parameters contained with the data feed.
If anyone could shed any light on my thoughts, or perhaps, they've done
something like this already, I would greatly appreciate some feedback.
How about this as a product Microsoft - all those legacy systems out there
suddenly able to print something a little better than the old dot-matrix
print-outs on pre-printed stationary. !!!
Any pointers would be much appreciated.
Kind Rgds
Graham GoodeyThis is possible but you will need to write a custom data extension for both
the data in the report as well as driving the delivery of reports. I think
the file-based approach will be easier than the print queue.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Graham Goodey" <graham_goodey@.yahoo.com> wrote in message
news:O4b500PVEHA.1012@.TK2MSFTNGP09.phx.gbl...
> Dear all,
> I've been following this group with interest for a while now but haven't
> seen any firm pointers for a solution to meet my problems.
> Essentially I would like to be able to
> 1) Create reports, acknowledgements, delivery notes, invoices, etc using
> data supplied from my legacy system Unix.
> 2) Output them to PDF - some of the parameters of this would be in the
data
> feed.
> 3) Email or fax these PDFs to our customers.
> It's not possible Reporting Services to query directly our system due to
> other limitations, but can we feed RS with data either via uploading a
file
> to a "watch" directory or via a print spool queue on the windows system -
we
> already use both methods for other applications.
> The reason for a print queue is it's easy to implement from Unix to
> Windows - no messing with FTP etc, and print queues already exist in our
> application.
> The format of the data feed can be XML or indeed anything as we are source
> code holders for our product.
> The questions are:
> 1) Is this vaguely possible. ?
> 2) Can RS take it's feed from a print queue - with possibly us putting
> together the software to accept the data on the print queue.
> 3) Could it handle files dropped into a "watch directory"
> 4) Can RS create PDFs using parameters in the feed file.
> 5) Could RS, with perhaps additional development, distribute the PDFs
based
> on parameters contained with the data feed.
> If anyone could shed any light on my thoughts, or perhaps, they've done
> something like this already, I would greatly appreciate some feedback.
>
> How about this as a product Microsoft - all those legacy systems out there
> suddenly able to print something a little better than the old dot-matrix
> print-outs on pre-printed stationary. !!!
>
> Any pointers would be much appreciated.
>
> Kind Rgds
>
> Graham Goodey
>
>
>