Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: can you help Post Reply Post New Topic
Author Message
ksmanyam
Newbie
Newbie


Joined: 06 May 2008
Online Status: Offline
Posts: 1
Quote ksmanyam Replybullet Topic: can you help
    Posted: 06 May 2008 at 11:22am
Data Stored in a oracle table in the following format
Acno Year Apr may Jun Jul Aug Sep Oct Nov Dec
1 2000 20 20 20 20 20 20 20 20 20
1 2001 20 20 20 20 20 20 20 20 20
2 2003 20 20 20 20 20 20 20 20 20
3 2000 20 20 20 20 20 20 20 20 20
4 2007 20 20 20 20 20 20 20 20 20
3 2001 20 20 20 20 20 20 20 20 20
3 2002 20 20 20 20 20 20 20 20 20
3 2003 20 20 20 20 20 20 20 20 20
And I want to present data in crystal reports in following format using acno as parameter field
acno 3
  2000 2001 2002 2003
Apr 20 20 20 20
may 20 20 20 20
Jun 20 20 20 20
Jul 20 20 20 20
Aug 20 20 20 20
Sep 20 20 20 20
Oct 20 20 20 20
Nov 20 20 20 20
Dec 20 20 20 20
Yours
Subramanyam K
IP IP Logged
solent
Newbie
Newbie


Joined: 07 Apr 2008
Location: United Kingdom
Online Status: Offline
Posts: 22
Quote solent Replybullet Posted: 07 May 2008 at 2:53am
I would recommend looking at Cross Tab reports, as what you are trying to accomplish fits nicely into this scenario. 
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 08 May 2008 at 6:14am
After that, shoot your database developer.

That table structure is straight out of Example #1 of how not to build tables.
IP IP Logged
Post Reply Post New Topic
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



This page was generated in 0.026 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2025 Brian Bischof. All Rights Reserved.