Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Deleting a particular row based on conditional

Hello Experts,

I'll like to take advantage of the known expertise that all of you have on this topic to ask a question regarding data-handling in Crystal Reports.

Currently, I have an Account table, but there is one condition that I need to validate in order to complete the report itself.

Please check the following table as an example.

nbr(*)Account IDGroup CategoryAccount AreaAmount
110001General70102300
210002Costs80905000
310003General1100
410004Costs70109000
510001Sales2300
610005Sales80901050
710001Sales8090540
810001General2300

*the nbr(*) is just as reference to identify every line.

Based on that table, check the Account ID 10001, the idea of the condition is that it validates per row if the Account Area is set, then take the corresponding Account ID and remove or hide the rows where the Account Area is blank (So they won't be valid in grouping or summarizes)

nbr(*)Account IDGroup CategoryAccount AreaAmount
110001General70102300
210002Costs80905000
310003General1100
410004Costs70109000
510001Sales2300
610005Sales80901050
710001Sales8090540
810001General2300

So the result will be the following:

nbr(*)Account IDGroup CategoryAccount AreaAmount
110001General70102300
210002Costs80905000
310003General1100
410004Costs70109000
610005Sales80901050
710001Sales8090540

Check that the rows 5 and 8 are no longer in the table, then with that table it's only matter for me to group by Category and make some other validations but that's the one that is getting me crazy.

I'll really appreciate if someone could take a look and give me some advices.

Best regards and thanks in advance,

Melvin

Not what you were looking for? View more on this topic or Ask a question