my variable name in my database is rsq01. the results for this variable are 0,1,2,3,4,5.
I need to setup a crosstab that only shows the results 1-5 and what percent of the total results they are, 0 needs to be excluded
from the crosstab and from the count that is used in figuring the percentage because 0 is actually null.
I have been told to do this I will have to make a manual cross tab using formulas.
Any suggestions/examples on how to do this? Thanks.

thanks, how do i tell it to exclude 0 values from the report?
my database actually have 18 questions that I need to make manual crosstabs for and not use the 0 values from any of them, so if i could tell it to exclude 0 values that would be great.

the 18 questions are in columns labeled rsq01, rsq02 etc. i need a separate cross tab for each question that excludes the 0 values in the count for the % values. I also need for all the crosstabs to show 1-5 in the columns even if 2 wasn't a result for that question, which is where i was told i would have to do a manual crosstab.
there is no unique key in the database, the first column of the database is a store id which is being grouped on so that each page of the form is a separate store that will have 18 crosstabs showing the % results for just that store.

thanks very much dblank. i'll start in on using what you've suggested. I have a couple crystal reports books and have watched numerous videos, but this is my first report and of course it would be alot more complex than most books/videos go into.
I will have to do all the running totals because we have to exclude the 0's, because the 0 values will deflate the means for each question. but the good news is once i have this all setup, it's done as we have hundreds of these to run against the one report setup.
Thanks again for your help.