Crystal Report - multiple crosstabs with various record selection criteria

Question

Im using Crystal Report 2011 and I would like to know if it is possible to generate two crosstab tables with different record selections in the same report?

For example, I have the following data set:

SchoolID QuestionID AnswerValue ++++++++ ++++++++++ ++++++++++++ 1 Q2 3 1 Q2 4 3 Q2 7 3 Q3 5 1 Q5 6 

I would like to create two crosstabs, the first will display questions 2 and 3, and the second crosstab will display only question 5. Can you help with this?

thanks

Asma

Answer 1

Create a formula field:

 // {@question} // dummy grouping; formula results are irrelevant SELECT {Table.QuestionID} CASE "Q2" OR "Q3": "A" CASE "Q5": "B" 

Create a group based on this field.

Move the cross-tab to the group header section.