Report more one Section (Details a and Details b)
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10342
Printed Date: 29 Apr 2024 at 1:19am
Topic: Report more one Section (Details a and Details b)
Posted By: @n70n1
Subject: Report more one Section (Details a and Details b)
Date 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 |
Replies:
Posted By: Emir_W
Date 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
 )------------- Emir W |
Posted By: @n70n1
Date 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  |
Posted By: Emir_W
Date 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.
------------- Emir W |
Posted By: @n70n1
Date Posted: 27 Jun 2010 at 8:18pm
|
Wow... Thanks for your help Mr. Emir it's run perfectly.. Success 4 u...  |