2 replies to this topic

[xsonline]

Hi all, I don't know if this is the right location to put this, but I have a little problem. I'm writing a software package for a company I work for.

Right now we have a very large database with lots of tables and data. Some users have access to other parts of the data than others, for example a teacher only has access to the information of his students and not even all of the information.

Now we want them to be able to generate documents, like contracts, reports,... The contracts are no probem, as they use single data. and example of how the document works:

Dear [first name],

Your company [company] was found in our database.

This would result in

Dear xxxxx,

Your company Xs0nline was found in our database.

Let's say we want a table with all contacts of the student in question in this document. How would we do this? We want to generate 1000 documents for each student.

The hard part is that a teacher (my grandmother) should be able to understand how to create this table or chart (if we have a pie).

I already looked at BIRT Studio, but it looks a bit too complex for the user. All of this has to be a web-based solution.

Anybody have any ideas? If it's not clear, please do not hesitate to ask.

[WingedPanther]

Do you know how to create SQL queries to get data from the database?
Do you know how to use SQL in PHP?
Do you know where the data you're after is located in the database?

[xsonline]

The answer to all questions is yes, but I don't want to use the database, but the models, as I have defined the relations in them. I was only thinking about a solution. Right now we have a solution. When I finished building this, I'll post the code ;).

Thx for your help!