Print Page | Close Window

Pivot table in Crystal reports

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
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=2982
Printed Date: 28 Mar 2024 at 3:04pm


Topic: Pivot table in Crystal reports
Posted By: Pooja
Subject: Pivot table in Crystal reports
Date Posted: 20 Apr 2008 at 10:13am
Hi There,

I am trying to create a Pivot Table in a Crystal Reports within Visual Studio.Net 2005.  The data is from an Access 2003 database.

There are 4 tables in the database:  Age, Gender, Clinic and Details.
The Details table has feilds to link it to each of the other tables.

Age has entries for Under 2, 2-5, 5-18, 19-64, Over 65
Gender has entries for Male, Female

I want to create a Pivot Table that gives a count of the ages to gender for each clinic.  I have done this, no problem, but if there are not any entries for an age group, or gender then that entry is not displayed on the Pivot Table.  I need to display all ages, and genders even if they don't have any values in the details table.

How is this done?

Thanks,

Pooja



Replies:
Posted By: Savan
Date Posted: 21 Apr 2008 at 2:58am
Pooja,
 
U can do this by using cross tab report. Can u give some more information, like how is the data stored in Access table


-------------
Thanks
Savan



Print Page | Close Window