sap - Crystal 2008 section export group selection -


I'm working with SAP Bio Crystal 2008 data table from ERP system

Here's what I have in the table, general laser magazines, description entries, grouped by general number showing the general laser account number, year, month, and value.

This is what I am trying to choose:

All magazines have a specific GL code. I need all journal entries for other GL codes, as long as I see the specific code (7000-00) is included in the magazine.

This is an extract of data:

378 GL code included in the journal / Price / Leave 2015 1 7000-00 378 855.15 2015 in 1 7200-00 378 -855.15 included 2015 1 3200-00 37 9 -41.06 2015 excluding 1 3210-00 37 9 -0.47 2015 excluding 3220-00 37 9 -26.51 2015 except 1 7200-00 379 except 380 2015 1 7000- 00 380 866.75 includes 1 7200-00 380-866.75 in 2015 2015 except 1 3200-00 381-2.88 2015 except 1 3210-00 381 -0.27 2015 1 3220-00 381 -1.84 except 2015 7200-00 381 4.99 Exclude

As you can see I have a Group Header Showed tap number if the journal group 7000 -00 but I can not suppress data for any magazines with no 7000-00 ?

i.e. I do not want to see 379 bit 379 data from the journal. I have to see 380, but not 381.

Any help would be appreciated. I think this section needs a formula in the specialist but it is on the loss of how to do it.

Thanks guys

>

  1. journal and keep all your files that you want to see in the Details section.

  2. Now create the formula @ count below and keep it at the end of the detail section. 

      if (code = 7000-00) then 1 and 0

in the group footer using the inserted summary Calculate the count.

Now group headers, descriptions and groups 

  if (amount ({count}}, {Journel})) gt0; Then lie and true

Change the formula according to your report.


Comments

Post a Comment