Print Page | Close Window

Multiple Cross Tab Entries

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=20747
Printed Date: 05 May 2024 at 6:27pm


Topic: Multiple Cross Tab Entries
Posted By: Dr4ke
Subject: Multiple Cross Tab Entries
Date Posted: 16 May 2014 at 5:45am
Afternoon all,

I have tried many different method to make this graph work but it seems impossible!! I have a number of servers, which each have multiple Disk ID's, and at the moment the best way I've found to represent this is like the below; where the date is merged over the Disk_ID's (A & B), Server 1 and Server 2 in different columns and the disk_utilisation_% being in the middle as a calculated average figure for that day.

When I graph this I can only chose two selection points; The Date has to be one and the other either Server_Name or Disk_ID. Here lies the problem, I want to report on Server_Name AND Disk_ID so I can graph more than 1 server at a time!! So I could have a graph with 5 servers, for example, all the dates in the report and the legend would show which line colour matches to which server/disk combination.... am I asking too much or am I trying to achieve this using a really complicated method when there is something much easier?

Server 1         Server 2
01/04/2014        A                    85                   70
                           B                    70                   74

02/04/2014        A                     86                  74
                           B                     90                  75

03/04/2014         A                     83                 80
                            B                     86                 79


Replies:
Posted By: Dr4ke
Date Posted: 19 May 2014 at 4:31am
Is anybody able to assist?


Print Page | Close Window