Crystal Report

HI I am doing an Invoice approval form, on my detail section I have 1 invoice No. with 2 details, I want to show only 1  item per Invoice Number (sometimes there are two or many items in an invoice), how do I do it, creating group by invoice number doesn't work.


romeo BallesterosAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Try grouping by item number.  That should give you 1 per group.

YOu could also modify the invoice number to include a detail count.

romeo BallesterosAuthor Commented:
I tried to create a Group but it is still the same, it is still showing detailed result with the same invoice number.

I create group using either Invoice Number or item number, I even do the Control Account Number which is the same per invoice number.


It should work to group on invoice number then group on item number.

Can an item appear several times in an invoice?

You said "I want to show only 1  item per Invoice Number", but do you actually want to see an invoice item, or do you just want one line (line, not item), with totals for the invoice?

 If you're just looking for invoice totals, you can group on the invoice number, suppress the detail section, and put the totals and any other required fields in the group header/footer.

 If want to see an invoice item, but only one item, how do you decide which item to show?


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.