Detail within Detail

[phoggy]

Hi all,

I am new to using Crystal and using Crystal 11. I have a lot of difficulty with something and hopefully someone can help. I have the following situation for the details section of my report:


Quote No Part No Qty. Requested Unit Price
1 2xcyu 10 $25
2 9it89 30 $200
Price Breaks: 10 $100
20 $150
30 $200
3 lkkuiu8 25 $1050


The Pricebreaks table is linked to the Quote Lineitems table. To display the data like this do I have to use subreports or is there another way of doing it?

ANY help appreciated,
Thanks
Anna

 

[phoggy]

Formatting got a little messed up

 

[synapsevampire]

If you link by the appropriate fields, and use a left outer join, you should get a similar output providing you right click the details and select insetr section below and place the price break data in the second details section, and then conditionally suppress the detail b section using a formula:

isnull({pricebreak.qty})

Details A section needs a suppress formula as well:

{main.partnumber} = previous({main.partnumber})
and
not(isnull({pricebreak.qty}))
and
not(isnull(previous({pricebreak.qty})))

So it there aren't any price breaks, you'll have the usual details, and when there are multiple rows returned, it will display both details on the first row, and subsequent price breaks will suppress detail A.

Should be close anyway.

-k

 

[phoggy]

Thank you so much for you response!

I'm still a bit confused though. When I link the tables and I put the pricebreak.qty field on the report, then only those Quote line items that have a price break will actually show, so I don't understand suppressing when there is nothing there to suppress in that case. Hope I'm not completely missing the boat here.

Thanks,
Anna

 

[synapsevampire]

Reread my post, you need to change the link to a LEFT OUTER join.

-k

 

[phoggy]

OOOps, not paying attention. Just one more thing, do have an idea how I can show the header: Price Breaks so it will only show once per detail?

Thanks,
Anna

 

[synapsevampire]

What header, the page header?

You need to take alittle more time on your posts and describe fully what you need.

Do you want a new page for each detail?

Or do you want a new set of labels above each detail line with multiples per page?

you can right click the details and select insert csection below and then place the labels in details A and the fields in details b if that's what you mean.

-k

 

[phoggy]

I meant the header "Price Breaks" the way I had outlined it above. It doesn't have to be on the side the way I have indicated, so your suggestion of adding another detail is what I should do.

Thanks again,
Anna

 

[synapsevampire]

The way you outlined it above would indicate that you just use a normal page header.

-k

 

[ianoctdec]

Hi Anna,
Right Click on Price Breaks label and check 'Suppress If Duplicated'.

Daniela

 

[synapsevampire]

Hi Daniela.

Try rereading the post, it's a tad more complex.

-k