Hello.
I have some problem in cross tab,
I'm creating cross tab like as follow.

On Row displaying s_Questions
On Column displaying d_Date
On Summarized field dispaying s_ScoreOfQuestion

On perticular date client will ask 10 question to it's user and give score betwen 1 to 10 for every question.

suppose if score is 0 for perticular Question then cross tab will not dispay those question which has Score 0 but it will dispay Question which has score anything apart from 0 even it will dispay -1.

even my stored procedure returns all the 10 question including 0 score but cross tab is not dispaying.

kindly help me to slove this problem as soon as possible

Regards
Amit Joshi