Sub Reporting

[GerBear]

I have a reporting requirement that I just can't figure how to do. I know that I can do it in two stages, but there has got to be a way to make this work.

Data tables:

Sales detail file.
Invoice XXXX
1. Product Code 10 Service Fee
2. Product Code 20 Main Sales Item
3. Product Code 30 Insurance

The purpose of the report is to determine which products are most likely to have the insurance added on.

I generated a report that summarizes by invoice and product code. With a subreport, I determine the main product code. In the example above it would be product code 20.

I was able to return the main product code to the main report but I can not group the report on this value.

Can someone tell me how I can produce this report?

Thank you

 

[synapsevampire]

As I stated in your last post, we'll need more technical information.

Crystal version
Database/connectivity
Example data
Expected output

The above post doesn't begin to describe a requirement, and as you go through the above exercise, you kmay discover hwo to code it yourself.

What does grouping have to do with the requirement of determining the most likely of <some undefined requirement>.

You're going to have to be more technical in your posts, and more thorough in your descriptions. Trying to learn how to group via a subreports value over and over won't help, Crystal can't do that, you would use the subreport as the main report if you wanted to group by the subreports value.

My favorite definition of insanity is to repeat the same process over and over again and expect a different result.

Looking oddly familiar for both of us so far...

-k

 

[GerBear]

thank you for responding...
I will try again...

Crystal Reports V10
The Database is an ODBC relational database
Software is GBO

Sample Data

Invoice Detail File

Invoice# LineItem ProductCode Description SalesValue
10000 1 20 Flight 1000
10000 2 30 Cruise 1500
10000 3 40 ServiceFee 50
10000 4 50 Insurance 200
10001 1 20 Flight 1100
10001 2 40 ServiceFee 50
10002 1 30 Cruise 2000
10002 2 50 Insurance 300

Example of Output

ProductCode Description SalesValue Insurance
ValueByProductCode
20 Flight 2200 200
30 Cruise 3500 300
40 ServiceFee 100 0

Flight and Cruise would be the primary sales items with flight having priority over cruise.

I don't understand how making the subreport the main report will solve the problem but I am not a pro at this either.

I hope this is clear enough.

Thank you