Sorry about the misleading, my old stored procedure doesn't work either now.  I must have ? changed the layout of the report just by clicking around.  But does anyone know...

Thank you for the reply.  But I don't quite understand.  Could you please explain it more?  I was adding 'AS description' at the end of the case when, but got...

Hi all,

I think I got the second question solved.  The reason is one of the missing value I have is located at the first column. I think it is this...

Hi,

Thank you very much for the reply.  I gave up the hiding parameters task at the moment.  I got the report to work to the point which shows the 3...

Thank you very much for the reply. I have tried various things, I found out the problem is I have checked the fit into one page if possible and...