id     question                                answer       student ID 

 

1      What is your name?              peter                1

2      What is your weight?            150 lbs             1

3      What is your age ?                24                    1

 

 

 

The actual table is much longer and has many more student IDs.

 

If I want to design a report based on student 1 only, but want to format the report and put the question field where ever I want on the report from any ROW. 

 

I do not want it to be printed out like it shows above, but instead I want to be able to jump to any ROW in this table and select that data for the row.  

 

For instance.  I am a good PHP MYSQL writer.  Once you connect to the database and run your SQL, you can do anything you want to that data.  The bracket [] below represent what ROW I want to print data from.

 

 

Test1.Question [3]  would represent What is your age.

 

Test1.Question [1] would represent  What is your name.

 

 

Can you do coding like this in crystal, if not how can I print out my list in a nice formatted way?

 

There has to be a way to do this?

 

Thx in advance.