Print Page | Close Window

manual crosstab

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=358
Printed Date: 05 May 2024 at 8:51am


Topic: manual crosstab
Posted By: ljrussell
Subject: manual crosstab
Date Posted: 20 Mar 2007 at 4:23am
I am trying to create a manual crosstab so I can show the rows that have zero values.  I thought this would not be hard to figure out but since I am relatively new to Crystal Reports, I am not finding a great deal of information on manual crosstabs.  I am using Crystal Reports XI and SQL Server.  The original crosstab I created reads one table and creates the report with the exception of the zero rows.  Any guidance would be appreciated.
Thanks - this is a great website.  


Replies:
Posted By: BrianBischof
Date Posted: 20 Mar 2007 at 12:04pm
If you want zero values in a CR crosstab, create a table that just has the column headers in it. Then link to that table doing an outer join. This forces that rows that have zero values to be displayed since the row headers are now part of the result set. The other option is to search Google and there are posts for how to do a crosstab as a stored procedure and you have more control over the data. Then you can just print the results from CR.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: ljrussell
Date Posted: 20 Mar 2007 at 5:56pm
Brian,
  Thanks so much for the suggestion.  I have googled manual crosstab and did not find this recommendation.  I will try it first thing in the morning.  Thanks again for your help.

Posted By: BrianBischof
Date Posted: 20 Mar 2007 at 6:06pm
I did a search on SQL pivot tables. The first result looks pretty darn good. You can search for more if this doesn't work for.

http://www.sqlteam.com/item.asp?ItemID=2955 - http://www.sqlteam.com/item.asp?ItemID=2955


-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: ljrussell
Date Posted: 21 Mar 2007 at 4:46am
Thanks - didn't think to try a search on pivot table.  I appreciate your help.


Print Page | Close Window