Suppressing Formula in Cross-tab 1

[tcgoth]

Crystal XI
SQL 2005

I am displaying the results of survey responses in the Detail Section of the Report and then summarizing those results using a Cross-tab in the Report Footer.

The survey responses that are being summarized are a mix of Scaled Scores (1-5) and Yes/No responses. Based upon the selection criteria there may be 50-60 DIFFERENT Scaled Score Questions and 30-40 DIFFERENT Yes/No questions.

For the Yes/No Summaries, I am using the posted strategy of calculating a % ("Yes" responses as a percentage of total responses.) As mentioned above, I also have Scaled Scores to Summarize.

My current output in the Cross-tab Summary looks like this:

Scaled Score Summary Question #1 Yes Count
Yes/No Total
% Yes
Scaled Score Avg.

Yes/No Summary Question #1 Yes Count
Yes/No Total
% Yes
Scaled Score Avg.

Question: Is there a way to Suppress the formula results based upon the "Type" of question being summarized so that Yes/No Summaries show ONLY the Yes/No Results and the Scaled Score Summary displays the Scaled Score Average?


Desired output in the Cross-tab Summary would look like this:

Scaled Score Summary Question #1 Scaled Score Avg.

Yes/No Summary Question #1 Yes Count
Yes/No Total
% Yes


Thanks!

 

[lbass]

You could suppress them, but you would not be able to suppress the corresponding space. You might want to not suppress, but instead display "N/A" for summaries that don't apply to the current row. You could select the summaries->format field->display string->x+2 and enter, e.g.,:

If gridrowcolumnvalue("answertype") = "Scaled Score" then
"N/A" else
totext(currentfieldvalue,1)// 1 for 1 decimal

...where "answertype" is your crosstab row with the curly brackets replaced by double quotes.

-LB