CRYSTAL REPORT 2010 - SHOW FIELD IN GROUP HEADER BASED ON THE DATA IN GROUP DETAILS

[former_member1051876]

I have a problem that needs to resolve. Please help me experts.

*I have group header and group details.

*I wanted to put a field in group header inside a textbox based on the data that has on the group details.

see picture for more details:

[DellSC]

This is just a tweak on the formula I gave above. It will look like this:

{@MPL Amount}
If {loan type field} = 'MPL' then 
  {start term field}

{@CAL Amount}
If {loan type field} = 'CAL' then 
  {start term field}

You would then put a summary in the header that is the minimum of each of these formulas to show the earliest start date for each type.

-Dell

[DellSC]

This would be fairly easy to do with summaries of a couple of formulas. It would look something like this:

{@MPL Amount}
If {loan type field} = 'MPL' then 
  {Amortization amount}
else 0

{@CAL Amount}
If {loan type field} = 'CAL' then 
  {Amortization amount}
else 0

You would then create two summaries that are the sum of each of these formulas and place the summaries in the group header.

-Dell

[former_member1051876]

Hi! Thank you for your time answering my question. But I need futher assistance because it is not the summarize that I want, it is the 'Start_term' field to be display in group header under textbox paragraph.

*Table scheme sample:

Pagibiger, eyername, midno, loantype, start_term

*It is group by eyername

*Every eyername with id 'pagibiger' has many midno data

*Every midno data has specific loantype and start_term

*So if the eyername have only MPL loantype based on midno data MPL in group header will set start_term and CAL will be NONE

*If eyername have on CAL, then MPL set to NONE then CAL set to START_TERM

*If eyername have both CAL and MPL loantype based on its midno, then all will set to start_term.

Note:

start_term data if MPL is 11/15/2020

start_term data if CAL is 12/15/2020