Static field in list 1

[kimchavis]

I was hoping that someone could help me with this next problem Im having:

My report is set up as such:

Group(by loan id) loan # 12345 days old 3
Det. loan # 12345 in 05/12/99
loan # 12345 comp. 06/15/99
loan # 12345 in 07/20/99

I have a running total to base the days old on the second detail in the list. I want the minimum status date in the Summary section. Status = comp. in the Evaluate section and reset on change of group loan id.

This works except for when a status of comp. is not the first in the list. Even if the minimum is at the bottom of the list. The days old appears as blank or null if the status is anything other than "comp." Anyone have an idea on how to combat this?

Any suggestions would be appreciated.

Thanks,
Kim

 

[synapsevampire]

None of the dates in your example less any other date would be 3 days, so it's pretty confusing.

You might ordder by status to make sure that comp is first in the list, but I've no idea of the goal given your example.

Rather than explaining how you want to solve it, please explain using data examples what you have and what you need.

-k

 

[kimchavis]

I didnt calculate the days old for the example. The days old should be 1677. I cant change the order of the list as it is in date asc order as they want it. I need to be able to calculate what the minimum date in the list would be given the status = comp. I have a feeling that this has something to do with the flow of data. As when I put my running total in the GH and GF, the minimum date populates for both except for when the comp. is not first in the list, it only populates for the GF. I may need to use a variable to accomplish this task. Does anyone have any ideas???

I appreciate any help with this. Thank you.

 

[lbass]

I think you could create a formula {@comp} for the detail section:

if {table.status} = "comp" then currentdate-{table.date}

Create a second formula for the group header:

"Days Old: "+totext(maximum({@comp},{table.loanID}),0)

-LB

 

[synapsevampire]

Looks right to me, LB, puuuuurdy slick.

-k

 

[kimchavis]

When I try that it tells me :

The summary/running total field could not be created.

Any thoughts??

 

[kimchavis]

Does anyone have any ideas on this one?

 

[synapsevampire]

Worked for me, show what you placed in the @comp formula.

-k

 

[kimchavis]

I tried it again, and it did work this time... I guess I messed something up the first time....

Now if I want to sort the loans by the Days OLD GROUP,, How can I do that??

If I just insert group based on Days old,,and put it above loan id, Its going to split out the details and have the same loan id listed more than once based on days old? Is there anyway to do this??

I would be forever grateful if anyone knows how to do this..

THANK YOU!!!!

 

[lbass]

Go to report->topN/group sort and select "Max of {@comp}". This will order the groups by the maximum.

-LB