Last post Jun 10, 2011 02:40 AM by nizam133
Jun 10, 2011 01:36 AM|LeftWinger|LINK
I have a table which contain Questions and Marks. The entries are arranged in ascending order of marks.There are variable number of questions of 1 marks,2 marks,3 marks, 5 marks and 10 marks. Now I want to put this questions into my crystal reports into
separate section based on marks.
Any help or suggestions would be appreciated..
Jun 10, 2011 02:40 AM|nizam133|LINK
I think the separation you can do in your query from database itlsef and get the records set and place the fields in corresponding columns accordingly.
your records set from database will return all question of 1 Marks in one column, 2 Marck in second colums ..... you might have to use pivoting here.