Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Horizontal Crystal Reports of Centres Post Reply Post New Topic
Page  of 2 Next >>
Author Message
asif_14443
Newbie
Newbie
Avatar

Joined: 14 Jan 2008
Location: Pakistan
Online Status: Offline
Posts: 7
Quote asif_14443 Replybullet Topic: Horizontal Crystal Reports of Centres
     Posted: 14 Jan 2008 at 10:19pm

I am facing problem to use the CRSTAL REPORTS reports.

 

I am working on a finance related project, I have a relational database in MS Access with 4 tables named, ACC_MAIN, ACC_SUB, CENTRES, DATA

 

Tables details are as under:

 

1) ACC_MAIN

ACC_MAIN      ACC_TITLE

1000 (PK)          Expense

1100                   Capital

1200                   Revenue

1300                   Liabilities

.

 

2) ACC_SUB

ACC_MAIN   ACC_SUB       ACC_TITLE

1000  (FK)           1001            Telephone Exp

1000                     1002            Gas Expense

1100                     1101            Shares 100 each

1100                     1102            Shares  200 each

1200                     1201            Revenue from Sales

1200                     1202            Revenue from Services

.

.

3) CENTERS

CENTRE_ID       CENTRE_NAME

1 (PK)                   Karachi

2                            Lahore

3                            Islamabad

4                            Quetta

 

4) DATA

ACC_MAIN   ACC_SUB  CENTRE_ID   DR1  CR1  DR2  CR2   DR3   CR3  BALANCE

1000                 1001              2                   1000     0      200    0       1200   0          1200

 

Now I want a report which contains all centres records HORIZONTALLY based on centres:

 

                                                                   Lahore

                                           Dr1     Cr1       Dr2       Cr2         Dr3      Cr3        Balance

1000       

1001              Rs.1000        0            200          0       1200       0              1200

1002                    600         0                0      200         400       0                400

1003                    800         0            400          0       1200       0              1200

1100

            1101                        0           2000         0    1000             0    3000           3000

1102                        0           1000       200         0             0      800             800

1003

 

Continued ………… horizontal page

 

Karachi

                                           Dr1     Cr1       Dr2       Cr2         Dr3      Cr3        Balance

1000       

1001              Rs.100        0            100          0           200       0               200

1002                  1600       0                0       200          1400       0            1400

1003                  1800         0            100         0        1900       0              1900

1100

.

.

.

.

. and so on ……………………

 
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 15 Jan 2008 at 4:12am
This is a classic application of a cross-tab.  Look that up in the help file, or, better yet, in Brian's book.  You should be able to create this with the Cross-Tab Expert very easily.
IP IP Logged
asif_14443
Newbie
Newbie
Avatar

Joined: 14 Jan 2008
Location: Pakistan
Online Status: Offline
Posts: 7
Quote asif_14443 Replybullet Posted: 16 Jan 2008 at 12:51am
I have searched from help, but I dint get the solution, n I dont hv Brain's book, if you have this book in PDF format please send it to me at asif_14443@yahoo.com.
 
please try to solve my problem. my all project depends on reports, because i am working on financial reporting system. the management ask different reports regularly, so therefore i am in great trouble.
IP IP Logged
Savan
Senior Member
Senior Member
Avatar

Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Quote Savan Replybullet Posted: 16 Jan 2008 at 1:14am

hi Asif

Is this a summary report ?
Thanks
Savan
IP IP Logged
asif_14443
Newbie
Newbie
Avatar

Joined: 14 Jan 2008
Location: Pakistan
Online Status: Offline
Posts: 7
Quote asif_14443 Replybullet Posted: 16 Jan 2008 at 1:52am
No Sir, this is not a summary report. I just want to print data on report in Horizontal and Vertical format, Centrewise.
IP IP Logged
Savan
Senior Member
Senior Member
Avatar

Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
Quote Savan Replybullet Posted: 16 Jan 2008 at 4:38am
Asif,
please follow the below steps
 
add all tables. create links between them as follows
   centre.centreid  ---> data.centreid
   acc_main.accmain ---> data.accmain
   acc_sub.accsub  ---> data.accsub
  acc_main.accsub ---> acc_sub.accsub
 
once u create links create group in following order
  
    data.centerid
          data.accmain
            data.accsub
 
now supress the group header #3
 
in the details sections  place the following fields
   data.accsub  data.dr1  data.cr1 .........................................
 
and the following report is generated
 
                                  karachi
--------------------------------------------------------------------------------------
1000
           1001     100     0       100  0         200     0         200
           1002   
 
 
                                  Lahore
--------------------------------------------------------------------------------------
1000
           1001     1000   0       200  0         1200   0         1200
           1002
 
1100
           1101     0         200   0      1000    0        3000   3000
           1102    
 
 
please let me know if this solves your problemThumbs%20Up
Thanks
Savan
IP IP Logged
asif_14443
Newbie
Newbie
Avatar

Joined: 14 Jan 2008
Location: Pakistan
Online Status: Offline
Posts: 7
Quote asif_14443 Replybullet Posted: 16 Jan 2008 at 10:41pm
Dear Savan,
 
Let me use this method, I am using crystal reports 10.0, in which I use Cross Tab wizard to create the report.
 
my database is relational, and when I run CR cross tab wizard, in 3rd step when it ask for add Columns and Rows, there is also a SUMMARY FIELDS, in which we have to add atleast one row or column to make it summarized format. (that I don't want to summarize)
 
The method you told me about relations, so where i hv to put these relations? as my database is already relational.
IP IP Logged
Lugh
Senior Member
Senior Member
Avatar

Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Quote Lugh Replybullet Posted: 17 Jan 2008 at 4:46am
As a note, if either your row or column identifier includes a value that is unique to each row (e.g., ACC_SUB), then the "summary" is just the value of the record.  A Sum of one value is just the value.  Used this way, the cross-tab can be used to provide a slightly different view of the data.  You may need to play around with the cross-tab expert, and try out different configurations, to get what you want.
IP IP Logged
asif_14443
Newbie
Newbie
Avatar

Joined: 14 Jan 2008
Location: Pakistan
Online Status: Offline
Posts: 7
Quote asif_14443 Replybullet Posted: 19 Jan 2008 at 8:29am

Well Mr.Lugh

The record is not a unique, ACC_SUB may have the same value, because this is an accounting and finance related project, two accounts may have the same amount,.

The cross tab report also donot provide the entire solution of my problem, it just provide for a summary of some records in group format, therefore I am stilling searching the solution of my problem because my whole project depends on reports, as this is a financial reporting information system.
 
Mr. Lugh if you kindly send me your email i would like to share some information with you pertaining to this matter.
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet Posted: 20 Jan 2008 at 8:11am
Have you found a solution to this problem? If not you may be able to handle this through multiple groups levels.
 
Regards,
 
John W.
 
IP IP Logged
Page  of 2 Next >>
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.