Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Repeating a Group Based on multiple options

Status
Not open for further replies.
Feb 2, 2005
54
US
I'm stuck. I'll do my best to explain what I'm trying to do.

Crystal 11
ODBC datasource

I am developing a report that prints labels for items that have been received against a purchase order. The receive record contains the item, and quantity received.

I am also being passed a parameter that tells me how the labels need to be printed. Option #1 would be for one label per item. Option #2 would be for one label per quantity received per item. Meaning if I received itemA (quantity 2) and itemB (quantity 3) Option #1 would result in two labels printed - itemA and itemB. Option #2 would result in 5 labels printed - 2 of itemA and 3 of itemB.

I was thinking of accomplishing this somehow with two groups One group would be the item and the second would be an loop formula that takes into consideration the parameter passed to me. Here are the fields involved:

~TEXT2 (parameter that tells me Option #1 or Option #2 - values = 1 or 2)
item
rec_qty

Thanks for any help or insight you might be able to provide.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top