Dynamic reports from the Web using Java/Tomcat

[twiggy182]

Hi all,

I have a complicated request to fulfill and I don't want to re-invent
to wheel for it.

I have a database with customer information ( name, city, bill,
etc...) stored in many tables

What I want to have in the end, is a page where end users can generate
a report by picking any column they want based on the information
available. For exemple, they could get customer list by selecting only
the "name" column. Or they could also pick only the "city" column to
know where we have customer.

All this would need to run on Tomcat with Oracle.

Anyone can help?

Thanks a lot.

 

[avinash.fearfear]

Hi all,

I have a complicated request to fulfill and I don't want to re-invent
to wheel for it.

I have a database with customer information ( name, city, bill,
etc...) stored in many tables

What I want to have in the end, is a page where end users can generate
a report by picking any column they want based on the information
available. For exemple, they could get customer list by selecting only
the "name" column. Or they could also pick only the "city" column to
know where we have customer.

All this would need to run on Tomcat with Oracle.

Anyone can help?

Thanks a lot.

Are you using any web-app tools like Spring or Tapestry?

-Avinash

 

[twiggy182]

Are you using any web-app tools like Spring or Tapestry?

-Avinash- Masquer le texte des messages précédents -

- Afficher le texte des messages précédents -

Hi,

no, I'm not using any of these, but I could always move to it. Any
suggestion if I use these?

I realised that what I need is a Report Builder directly available
from the web for end user.

thanks,

 

[David Segall]

Hi all,

I have a complicated request to fulfill and I don't want to re-invent
to wheel for it.

I have a database with customer information ( name, city, bill,
etc...) stored in many tables

What I want to have in the end, is a page where end users can generate
a report by picking any column they want based on the information
available. For exemple, they could get customer list by selecting only
the "name" column. Or they could also pick only the "city" column to
know where we have customer.

All this would need to run on Tomcat with Oracle.

You are the target market for Oracle Application Express
<http://www.oracle.com/technology/products/database/application_express/index.html>.
I have not used it so I cannot assert that it will actually produce
the application you want.

Application Express is "off topic" for this group but I can't suggest
a Java based solution that does not require a substantial amount of
extra code from you. You could try JDeveloper
<http://www.oracle.com/technology/products/jdev/index.html> and see if
they have a tutorial that produces an application similar to yours.