By castudil on

Hi All:

I am evaluating different CMS and drupal is on the final list.

one thing I am concerned is SQL FORMS and REPORT GENERATION.

does Drupal or any Plugins allow me to do this?

thank you!

⋅ Categories: Drupal 5.x

Comments

nevets’s picture

nevets commented

With Drupal you can define new content types using CCK and view the information in a variety of ways using the views module. You can also define your own modules with which you can do almost anything.

If you are looking for a tool more like crystal reports (that is what I think of when I see SQL forms and report generation) there is module for viewing/editing the database but no general pupose report module.

castudil’s picture

castudil commented

HI!

thanks for the answer!

basically what I am looking for is :

i) to create forms that users can fill, then that info goes to a DB.

ii) another kind of user can do queries to the database. after a query is done I need to post-process the result in order to present it in a printable way.

can I use CCK for that purpose?

can I manage that user and their permissions directly in the Drupal Admin Panel?

thanks a lot!

nevets’s picture

nevets commented

Depending on exactly what you might want to do you might consider either the webform module or a combinition of CCK and views module.

While I have not used the webform module from you question it may do what you need. You can read more about it at http://drupal.org/project/webform. Not sure about permission when it comes to webforms.

You could also use CCK to define a new content type and the views module to generate the report. With CCK you can control which roles can add (and/or edit) the new content type and you can restrict who can see a view by role also. There are several ways to construct a view and you can in addition theme the output to your needs.

And there is always the custom module route to get what you are after.

castudil’s picture

castudil commented

very complete answer! Thanks again!

if someone else is interested, this links may help:

cck module:
http://drupal.org/project/cck

views:
http://drupal.org/project/views

and perhaps this modules also

viewfield:
http://drupal.org/project/viewfield

CCK field permissions:
http://drupal.org/project/cck_field_perms

castudil’s picture

castudil commented

I was investigating a bit more.

from the webform page ( http://drupal.org/project/webform ) :

1) ... Typical uses for webform are to create questionnaires, contact or request/register forms....
2) ... Submissions from a webform are saved in a database table...
3) ... Past submissions are viewable for users with the correct permissions...
4) ...Webform includes some simple statistical tools to help in form design...

1,2,3 is what I need, the only concern is respect to 4. I will experiment a little more with this.