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.

Thanks.

Romeo
Capture.PNG
romeo BallesterosAsked:
Who is Participating?
 
James0628Commented:
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?

 James
0
 
mlmccCommented:
Try grouping by item number.  That should give you 1 per group.

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

mlmcc
0
 
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.

Thanks.

Romeo
0
 
mlmccCommented:
It should work to group on invoice number then group on item number.

Can an item appear several times in an invoice?

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.