Author |
Message |
jona
Newbie
Joined: 14 Nov 2008
Online Status: Offline
Posts: 8
|
Topic: Creating hierarchical groups at same level Posted: 28 Nov 2008 at 4:21am |
Hi everyone,
I am trying to do this in my report :
Let assume :
- group 1 has 1 record
- group 2 has 2 record
- group 3 has 2 record
And in this moment i get this report(if i use group by )
Group 1 record 1 Group 2 record 1 Group 3 record 1 Group 3 record 2 Group 2 record 2 Group 3 record 1 Group 3 record 2
What i want to show in my report is this one
Group 1 record 1 Group 2 record 1 Group 2 record 2 Group 3 record 1 Group 3 record 2
Only after all records of group 2 are shown i want to show the records of group 3 .
Is this so difficult to be done in CR? Can anyone help me on this?
THanks a lot :)
Edited by jona - 28 Nov 2008 at 4:26am
|
IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 28 Nov 2008 at 4:54am |
Hi
Can you post some sample data with the required output
cheers
Rahul
|
IP Logged |
|
jona
Newbie
Joined: 14 Nov 2008
Online Status: Offline
Posts: 8
|
Posted: 28 Nov 2008 at 5:04am |
ok let suppose this scenario:
You have an invoice. And for this invoice you have a list of creditors wich are part of this invoice and you also have a list of debtors wich are alsi part of this invoice.
And i want to have a view like this of my report:
Invoice
________________
Invoice number: X
Invoice date : X
_______________ Creditor_______________(Wich is in fact group 2)
1. Creditor 1
2. Creditor 2
3. Creditor 3...
_______________ Debtor_______________(Wich is in fact group 3)
1. Debtor 1
2. Debtor 2
3. Debtor 3...
As you can see Creditor And Debtor are group but not under each others they are at same level with invoice .
Do you understand me?
THanks a lot
|
IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 28 Nov 2008 at 6:21am |
Hi
Correct me if I am wrong you want to dispay Creditor and Debtor details as per Inovice Numbers.....
What I think is you create separate reports for Creditors and Debtors and then include them as subreports in your Main Invoice Number reports link then using the Invoice Number ,place those reports in in two separate groups ,which you can create as FakeGroups using the code below
Whilereadingrecords;
""
Cheers
Rahul
Edited by rahulwalawalkar - 28 Nov 2008 at 6:21am
|
IP Logged |
|
jona
Newbie
Joined: 14 Nov 2008
Online Status: Offline
Posts: 8
|
Posted: 28 Nov 2008 at 6:30am |
Hi , thanks for your reply. The problem is that i cant use subreports because this report is being called in another report as a subreport. In CR subreport after subreports are not allowed. What you think ?
Thanks :)
|
IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 28 Nov 2008 at 6:44am |
Hi
You are correct,can you mail me the sample data ,as i can play around to see if a solution could be found
cheers
Rahul
|
IP Logged |
|
jona
Newbie
Joined: 14 Nov 2008
Online Status: Offline
Posts: 8
|
Posted: 28 Nov 2008 at 7:00am |
Hi, what you meen by sample data? I cant sent you my report in rtf becuse i would have to sent you my schema database aslo. But you can generate a schema like mine if you use a database and choose 3 tables wich have dependence between each others.
I would really appreciate if you try it because i have been searching so much for this problem. Or if its not a problem for you i hav sent you an invite in yahoo messenger.
Thanks a lot !
|
IP Logged |
|
rahulwalawalkar
Senior Member
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
|
Posted: 28 Nov 2008 at 7:07am |
What I meant by sample data is
Few Records with Invoice Numbers with Creditor and Debtor details not entire schema.... also explaining the dependencies so that I can build the tables accordingly with your sample data and test .......
Cheers
Rahul
|
IP Logged |
|
jona
Newbie
Joined: 14 Nov 2008
Online Status: Offline
Posts: 8
|
Posted: 28 Nov 2008 at 7:20am |
Ok assume you have 4 tables
Table 1
Invoice Table
-id_invoice (PK)
-Date
Table 2
Creditors Table
- Id_Invoice(PK)
-Id_person (PK)
Table 3
Debtors table
-id_Invoice(PK)
-id_person (PK)
Table 4
Person table
- id_person(PK)
1.U can add an invoice number in the invoice table.
2. And then you add some persons in the person table
3. with same invoice number add some persons in the creditors and debtors table
and then try to generate the raport with the schema i have told you in the post before
Am i clear enaugh?
Thanks a lot :)
|
IP Logged |
|
Savan
Senior Member
Joined: 14 Dec 2007
Location: India
Online Status: Offline
Posts: 162
|
Posted: 28 Nov 2008 at 11:26pm |
i think u can get the report using the sorting option your sort order should be invoice number -> creditor -> debitor.
|
Thanks
Savan
|
IP Logged |
|
|