Installation problem

Hello Gerhard,

I am not familiar with RS-Form, but I can give you a 'general' answer. You can use TableJX to display data from table in database. If RS-Form stores entered data in database table and each field in RS form is stored in its own column in a table then you can display it with TableJX. All you have to do is to know the name of the table for specific form and select the table from dropdown list.

If RS-Form doesn't store data for each form in its own table, then you may be able to create view that collects data from RS-Form for specific form.

I will be able to offer you more help, if you can inform me where the data entered in RS Form is stored and what is the structure of such table.

Best regards,
Bostjan

Hello Gerhard,

Yes, I see your problem. You may be surprised but this is a known problem in information science. You can solve it by table transponation. One way may be to create a view with multiple joins of the same table. For example:

Select
Rasse.FieldValue,
Geschlecht.FieldValue,
Hundename.FieldValue,
from RCFormTable Rasse
inner join RCFormTable Geschlecht on Rasse.FormId = Geschlecht.FormId and Rasse.SubmissionId = Geschlecht.SubmissionId
inner join RCFormTable Hundename on Rasse.FormId = Hundename.FormId and Rasse.SubmissionId = Hundename.SubmissionId

I have not tested it but it may be a solution for you.

On the other hand we plan to release FormJX component which will be fully compatible with TableJX at the an of the February. I'm sure you cannot wait that long, but just to let you know...

Best regards,
Bostjan

I used a wrong term.. it is actually a 'table transposition'... google aroud and you may find some solutions... e.g. szeryf.wordpress.com/2007/09/09/table-transposition-in-sql/

Regards,
Bostjan