Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Report more one Section (Details a and Details b) Post Reply Post New Topic
Author Message
@n70n1
Newbie
Newbie


Joined: 23 Jun 2010
Location: Indonesia
Online Status: Offline
Posts: 7
Quote @n70n1 Replybullet Topic: Report more one Section (Details a and Details b)
    Posted: 23 Jun 2010 at 10:33pm
Hi Bos...

I create a Crystal Report, that will show the report contains more one Transaction every day and Group by Status.

And here I want split the report detail like this :

Group Header #1 (by Status)

Detail a
         : contains the record from yesterday and previous date Transaction
Detail b
         : contains the record today's Transaction only

Group Footer #1 (by Status)

I have use Format Section, and use Suppress (No-Drill-Down), but I don't get the result that I want. Someone can help me please..

Thanks b4




Edited by @n70n1 - 23 Jun 2010 at 10:35pm
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 23 Jun 2010 at 10:47pm

hi boss...

create a formula to identify for previous trx (trxhist) and also for current trx (trxcrnt).
 
then you can play around in Section expert with Suppress condition for those formula.
where:
- Detail a is for previous/yesterday trx (trxhist true or vice versa)
- Detail b is for current trx (trxcrnt true or vice versa)
 
 
hope it help.
 
(mas, kalo sudah dicoba kabari ya Wink)
 
 
Emir W
IP IP Logged
@n70n1
Newbie
Newbie


Joined: 23 Jun 2010
Location: Indonesia
Online Status: Offline
Posts: 7
Quote @n70n1 Replybullet Posted: 25 Jun 2010 at 4:29pm
Hemm, thanks Mr. Emir...

Yeah, I have tried this b4 I posting this topics, but the problem is :
How the Group can Split between Detail a and Detail b ?
Group is by Field Status (Pending and Not Pending Trx)

I want the Result Like this :

Date Print Report : 26/06/2010

            --------       --------
            Date Trx       Inv. No     
            --------       --------
Group Status : Pending and Previous/Yesterday trx (Detail a)
            01/06/2010   02xx
            01/06/2010   02xx
            25/06/2010   02xx
            25/06/2010   02xx
Group Status : Pending and Today trx (Detail b)
            26/06/2010   02xx
            26/06/2010   02xx


Group Status : Not Pending and Previous/Yesterday trx (Detail a)
            23/06/2010   02xx
            24/06/2010   02xx
Group Status : Not Pending and Today trx (Detail b)
            26/06/2010   02xx

Thanks b4

Trims Mas Emir... Hehehe Big%20smile



Edited by @n70n1 - 25 Jun 2010 at 4:54pm
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet Posted: 26 Jun 2010 at 10:52pm
have you try this:
1. create a formula to check the trx pending or not (trxpending)
2. make a group (G1) based on formula trxpending
    till this stage you'll see which is pending trx and which not
 
3. create another group (G2) to specify the trx is history or current
 
then you can change the group name as you wish.
 
 
hope it help.
 


Edited by Emir_W - 26 Jun 2010 at 11:01pm
Emir W
IP IP Logged
@n70n1
Newbie
Newbie


Joined: 23 Jun 2010
Location: Indonesia
Online Status: Offline
Posts: 7
Quote @n70n1 Replybullet Posted: 27 Jun 2010 at 8:18pm
Wow... Thanks for your help Mr. Emir
it's run perfectly.. Success 4 u... Thumbs%20Up


Edited by @n70n1 - 27 Jun 2010 at 8:21pm
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.031 seconds.