Could a reporting tool like Jasper reports be used with EWB?

http://jasperforge.org/projects/jasperreports

Godfrey

Godfrey


I'll be interested to see Tim's answer to this. Looking at the link you provided my take on it would be that its nothing to do with EWB but will depend on the back end you implement since its intended to obtain data from a database and produce a report.

Roy Lambert

I would say yes but only by using container object Tim is adding - and
container would be just a web link to jasper app so nothing really to do
with EWB natively.

JasperReports is Java app (not JavaScript). As such you'd still need to
write the back end app for it and of course have your EWB store the data
in DB that JasperReports can access.

Raul


On 4/2/2012 11:23 AM, Roy Lambert wrote:
> Godfrey
>
>
> I'll be interested to see Tim's answer to this. Looking at the link you provided my take on it would be that its nothing to do with EWB but will depend on the back end you implement since its intended to obtain data from a database and produce a report.
>
> Roy Lambert
>

The container object would be the one to use right enough - all report
generation would be done server side. I tend to think in terms of
RemObjects (having built stuff like this in the past) and the flow in
this case could go something like:

1. Call a remote RemObjects service to start the build of the report.
2. The report is generated as a PDF (for example) which sits on the
server side.
3. Return the location of the generated PDF in the service call
(probably via a queue if the report generation will take a while).
4. Use the location info with the EWB container to display the remote
PDF in the browser.

There are then plenty of Delphi reporting tools you could use on the
server side.

Cheers, Bob


On 02/04/2012 16:36, Raul wrote:
>
> I would say yes but only by using container object Tim is adding - and
> container would be just a web link to jasper app so nothing really to do
> with EWB natively.
>
> JasperReports is Java app (not JavaScript). As such you'd still need to
> write the back end app for it and of course have your EWB store the data
> in DB that JasperReports can access.
>
> Raul
>
>
> On 4/2/2012 11:23 AM, Roy Lambert wrote:
>> Godfrey
>>
>>
>> I'll be interested to see Tim's answer to this. Looking at the link
>> you provided my take on it would be that its nothing to do with EWB
>> but will depend on the back end you implement since its intended to
>> obtain data from a database and produce a report.
>>
>> Roy Lambert
>>
>

There are then plenty of Delphi reporting tools you could use on the
server side.

Cool. I though I would have to develop the server in php.

Can I use fastreports on the server side?

What version of Delphi do I need?  I currently use the pro version.

I have never done any internet server development.  How difficult is it?   

>I though I would have to develop the server in php

If you're using ISS then you could create an ISAPI DLL, although the
problem with this is that hosters usually don't let you install them on
their servers (you need a dedicated box). I've never used ISAPI for
production since I tend to use RemObjects for my server-side work -
which is what my example was based on (although RO can also be used for
ISAPI work).

If you're using Apache then you can use FastCGI for your Delphi code -
take a look at the ExtPascal project there's some FastCGI code in there
(although again I've never used it).

You could use FR on the server side. Not sure if Delphi Pro can be used
for ISAPI work, but I'd be surprised if it couldn't - there's bound to
be some third-party code somewhere.

Regarding difficulty, I've found it pretty straightforward using Delphi,
although I believe PHP is supposed to be easier for general work. Not
sure how PHP would handle something like report generation though.

Cheers, Bob



On 03/04/2012 07:45, Godfrey Fletcher wrote:
> There are then plenty of Delphi reporting tools you could use on the
> server side.
>
> Cool. I though I would have to develop the server in php.
>
> Can I use fastreports on the server side?
>
> What version of Delphi do I need?  I currently use the pro version.
>
> I have never done any internet server development.  How difficult is it?
>

Hi Godfrey

Just saw this on the 3rd party forum
http://www.habarisoft.com/habari_webcomponents.html

There are others like it - I'm sure I've seen a free one but can't
remember where.

Cheers, Bob

Just saw this on the 3rd party forum
http://www.habarisoft.com/habari_webcomponents.html

Thanks Bob

I dont mind paying for components.  I just want the quickest simplest way to develop.  I dont have the time
to spend learning complicated tools.

Godfrey

Hi Godfrey - yes it's fair to say that some of the data access
frameworks have a steep learning curve, but are very powerful.

Cheers, Bob


On 03/04/2012 12:27, Godfrey Fletcher wrote:
> Just saw this on the 3rd party forum
> http://www.habarisoft.com/habari_webcomponents.html
>
> Thanks Bob
>
> I dont mind paying for components.  I just want the quickest simplest way to develop.  I dont have the time
> to spend learning complicated tools.
>
> Godfrey
>

yes it's fair to say that some of the data access
frameworks have a steep learning curve, but are very powerful.

Hi Bob

What data access framework do you recommend?

Can Datasnap be used for this?

Thks
Godfrey