crystal report format subreport/group

[Tbirdbully]

I am using crystal report XI (11).

I have a excel database with certain fields listed below:

Product
Additional Product
Software_Code
Description
Manufacturer


I need to form a report that will place the product with its information on page 1 listing the additional products that relate, and on the 2nd page would be additional product with its own information.

The software code is what is going to organize where the data goes. 0411 would be page 1
0411a page 2
0411b page 2 (under product above)

My question is how is the best way to produce this report. Should I go along with separate groups or subreports. I need have a formula to search for the char a, b to add the additional page if not keep adding Main Products pages.

(if Right({Sheet1_.SW Dir Code},1)="a" then (subreport)

I am confused on how to do set up a formula for a subreport to execute if needed.

To give more a visual of what I am looking for:

Page 1:

Product Name
SW Code
Product Description
Additional Products (if any)
Versions

Page 2 : <Top half of page>
Additional Product Name
SW Code
Product Description
Additional Products (if any)
Versions

<bottom half of page>

2nd Additional Product Name
SW Code
Product Description
Additional Products (if any)
Versions

Page 3:
Product Name
SW Code
Product Description
Additional Products (if any)
Versions


any ideas?

Thanks

 

[Madawc]

A crystal report asks the server for data at the start of the run, and then processes it. A subreport does its own request to the server, so if you put a subreport at detail-line level, this will be very inefficient.

Sections can be conditionally suppressed, right-click and choose Section Expert. You can also add the same table/dataset twice, the second time as an alias

With Crystal, it is best to use trial-and-error rather than trying to pre-plan.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Tbirdbully]

is there a way to put a formula for a separate subdetail. I want so only sub detail b shows up if there is a letter at the end of the code. so 0411k would show up but not 0411.

I know there is a selection expert for group, but how do you have it filter with multiple groups. I dont know how to specify which group or subdetail (depending on which works best) ties to each formula.

 

[Madawc]

Running totals can add using a formula.

For group selection, use Report > Selection Formulas > Group. The 'expert' functions are useful when you're starting out, but it is better to code directly

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10