there is a bunch of things to consider when building a web reporting engine.
Performance, Scalability, Queue, Security, Out put, Distribution, Scheduling
etc.
In addition to this you need to do it all from the web.
We have a solution we sell. Might be a place to start.
Or you can just start coding it from scratch.
What we developed is a database model that stores the definition of a
report. So it tells us which obkect to run to collect input arguments. The
object is coded by a developer and can handle validation of input arguments.
It then stores the arguments in the database.
The report definition tells us which object handles out put, PDF, Excel,
text etc. The next info is how to handle distribution. Display on screen or
e-mail or FTP. The last object tells us how to generate the report. Gets
arguments and process the request.
It's all prety straight forward. Then on top of all of this we have secrity
that says, who can run the report as well as track who has looked at the
report.
http://www.powerobjects.com/smlportal.aspx
I would say get some demo code, find out what works and what does not work.
If you think its better to start with a solution thats another option.
Also PB11 has web forms. This is antoher option to build reports.
With smlPortal you get all the source code. So its a good way to get a jump
start (code can't be distributed).
Good luck
--
Dean Jones
CEO
PowerObjects
http://www.powerobjects.com
(612) 339-3355 Ext. 112
TeamSybase
* * Think Sybase * *
<sportster> wrote in message news:48c99097.2ecf.1681692777@sybase.com...
> Hello, been out of the PB arena for over 6 years and I've
> been assigned a project that involves Web Reporting and
> Front end Database maintanence. I'm looking for a sample or
> basic applicaiton that will allow me to get a jump start on
> building an app from scratch. I've never done the Web
> reporting piece and would like any sample code or such to
> get a jump start on that as well. Thanks for any info, code,
> PBL's that you can provide. Also if you can point me to any
> code sample on the web that would be great as well. I'm also
> going to be doing some hand held development so if anyone
> can point me in that direction as well that would be
> great... Thanks All...
|