repeating the Detail Section 1

[raugi]

I'm an entry level report writer, I pull the table / field information through Crystal, not SQL.
I'm writing a report of labels, each detail section contains information found on various tables (not one single table). One of the fields is 'quantity' and I need the detail section repeated the amount of times in the 'quantity' field. whether that be by duplicationg / repeating the group, or the detail section.
ex. "item.num","item.price","invoice.quantity"

By suppressing the group header & footer I have managed to create the report listing each label 1 time, but do not know how to get them to repeat.

Any ideas would be greatly appreciated.

 

[dgillz]

Can you create a new table in your database?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[raugi]

I was thinking of going this route. Or wondering if there was a way to create a SQL view that would be like having the information in a new table.

We can create new tables on the database, the only problem is that I will be using this report through crystal enterprise to allow people to run the labels for whatever purchase receipt is needed.

The beginning of the report is a parameter field that asks which receipt # you need labels for, meaning the information will not be the same twice... I don't know if a new table would be much good for this process?

As I mentioned, my level of SQL is very limited and I would have to use our programmer to get anything along those lines completed. I am hoping there is a way in Crystal to get the detail section repeated 'x' number of times before moving to the next group...

 

[dgillz]

OK, create a table called 'numbers' and have one numeric field in it. Populate it with the numbers one thru say, 300,or whatever a reasonable maximum number of labels would be.

Link this table to your other table with the quantity field, using a less than or equal to link. Place the field from the numbers table on your label, suppress it if you don't want it to print.

Thats it, you are done.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[raugi]

dgillz...

thank you so much, that worked perfectly. It's always something nice and simple huh?..haha...

thanks again, perfect solution for what i needed.