Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Best Way to Recreate a "Pivot Table" Post Reply Post New Topic
Author Message
Luis2101
Newbie
Newbie


Joined: 14 May 2008
Online Status: Offline
Posts: 18
Quote Luis2101 Replybullet Topic: Best Way to Recreate a "Pivot Table"
     Posted: 14 May 2008 at 9:17am

Hello everyone. I have to create a series of reports that have pivot table functionality (the user can select and update the various fields the table shows).

At first I thought a Cross-Tab would be a good way to go, but I've realized that a cross tab is very different from a pivot table, and I don't think it can be used for what I'm trying to do.
 
I know I probably have to use Parameters, but is that the best way? And if so, how would I be able to allow the user to enter a new set of parameters once they've already generated a report?
 
Thanks for the help.
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 14 May 2008 at 9:52am
This is going to be a challenge.  It's possible, but not easy, and will likely be tedious to create.

A cross-tab is likely to be key to your solution in some way.  It's just the easiest way to break data down in that fashion.

Your best option is likely to be creating multiple detail sections, each with a cross-tab in a different configuration (assuming you have a relatively small number of possible configurations).  Then, use parameters to suppress all the sections that you don't want to see.

As for changing the parameters, the only way to do that is to refresh the report.  At that point, the user will be prompted as to whether or not they want to change the parameters.
IP IP Logged
Tim Wise
Newbie
Newbie
Avatar

Joined: 29 Apr 2008
Location: United States
Online Status: Offline
Posts: 31
Quote Tim Wise Replybullet Posted: 14 May 2008 at 10:51am
Originally posted by Luis2101

Hello everyone. I have to create a series of reports that have pivot table functionality (the user can select and update the various fields the table shows).
Yes, the Excel interactive pivot tables and charts are nice. I'm trying to do something similar. Keep in mind that I'm relatively new to Crystal and that I'm using CR 2008.
 
My example is displaying computer utilizations for many computers for every hour of every day last month. There are too many computers and too many times to display it all at once, so give the user control to zoom into time periods and computers of interest.
 
I was thinking to get all the data for last month then use parameters to filter the saved data (datetimes and computers) before it is put into a cross-tab and charted.  So users pick and enter parameters, refresh the report, and see new charts and tables.
 
I've prototyped this, but I was using the parameter values to filter the records retrieved into the report; i.e., changing the parameters caused new data to be reselected. Can I use parameters to filter the 'saved data' and not have to be connected to the data source?
I'd like to have users be able to view and interact with the report without having to be connected to the data source and without needing to have Crystal Reports.  Can this be done say with the Report Viewer?
 
I also had the parameters (datetime and computers) dropdowns fixed; I'd like to have the initialized from the retrieved data. How to do this?
 
Hope this helps.
 
 
 
 
--
Tim
IP IP Logged
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.