Sub Reports 2

[sclark415]

Crystal 10 - Enterprise 10 - SQL Server.
I have a report with number type fields example below

PD TO Date PD this month Reserves
---------------------------------------
Indemnity Indemnity Indemnity
Expense Expense Expense
TPA TPA TPA
---------------------------------------
0.00 0.00 80,000.00
1,843.75 1,843.75 656.25
0.00 0.00 425.00

I have to create 2 sub reports splitting each number field into a 70/30 split. SubA = 70% SubB = 30% splits. Any assistance would be greatly appreciated as I don't even know where to start.

Thank you in advance for your help!

 

[dgillz]

Why do you feel you need a subreport to do this?

Just create formula fields as folloes:

{FieldA}*.3
{FieldA}*.7
etc., etc.



Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[sclark415]

Thank you for your quick response. I need subreports because I have to have a master report, then 2 reports that tie into the master (column headings etc) almost the same except for the money. The sub reports will have a different header because subA is one company, subB is a different company. Is this even doable?

 

[Crystalyzer]

I agree with dgillz. There is no need for sub reports. You could create a group for the different companies and use conditional formulas for your amounts

If {Group1}="CompanyA" then {fieldA}*.7 ELSE ({FieldA}-{FieldA}*.7)

Note: I used the total minus 70% in the else statement to eliminate totals that would not add back to the original amount.

 

[sclark415]

Thank you to both of you. I appreciate your help. I will use groups to get my 70/30 splits. I REALLY appreciate your help!