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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
looping through detail section? 1
- Thread starter TheBeef
- Start date
synapsevampire
Programmer
Crystal doesn't allow you to loop through a recordset, though you can use subreports for the same effect.
Crystal has many automated functions that may allow you to avoid looping, so if you state the requirement, supply sample data, state which version of Crystal and Database that you're using, someone here will likely help you.
-k kai@informeddatadecisions.com
Crystal has many automated functions that may allow you to avoid looping, so if you state the requirement, supply sample data, state which version of Crystal and Database that you're using, someone here will likely help you.
-k kai@informeddatadecisions.com
I have a similar situation where I would like to create a set of labels for an order. I get data representing an order and I need to print out a header label with all of the information from the record. Then I also need separate labels containing a reduced amount of information from the same record. I need a quantity of these "sub labels" equal to the quantity of items in the order.
I can create the header label with no problems and I have created a separate section to hold my reduced info. I am thinking of using the Suppress checkbox and a formula on the Section Expert page to control the display of the "sub label." How would I get only this part of the report to print multiple times?
Thanks for any help!
-bdw
I can create the header label with no problems and I have created a separate section to hold my reduced info. I am thinking of using the Suppress checkbox and a formula on the Section Expert page to control the display of the "sub label." How would I get only this part of the report to print multiple times?
Thanks for any help!
-bdw
-
1
- #4
bdway,
Create a table with the numbers 1 thru 300 in it - or some other number that is the maximum number of labels you would ever reasonably expect to print. Join your order table to this table on the quantity field using a less than or equal to join.
This will return 8 labels if the qty ordered is 8, 20 labels if the qty ordered is 20, etc. This is the record inflation that we often experience and work hard to avoid in reports with tables with many to one relationships, but in this case we are doing it on purpose - to get multiple labels.
Credit for this goes to Ken Hamady who gave me this technique some time back. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
Create a table with the numbers 1 thru 300 in it - or some other number that is the maximum number of labels you would ever reasonably expect to print. Join your order table to this table on the quantity field using a less than or equal to join.
This will return 8 labels if the qty ordered is 8, 20 labels if the qty ordered is 20, etc. This is the record inflation that we often experience and work hard to avoid in reports with tables with many to one relationships, but in this case we are doing it on purpose - to get multiple labels.
Credit for this goes to Ken Hamady who gave me this technique some time back. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question