Showing a field based on another being the min 1

[LikePork]

hi,

I'm creating a report with the CR bundled in Visual Studio 2003.

I want to show a string based on another field in the same record being the Min value in that group. I have a group footer where I display the min date by using

Insert->Summary-> min of {table}.{date}

in my group's footer. What I'd really like is for the {table}.{string} value that is in the same record as the min {table}.{date} value to be displayed.

I've been playing with a formula to get this

Minimum ({table}.{date},{table}.{groupID}, "")

but I can't find anywhere what that 3rd argument is used for. I was hoping the 3rd argument could be the field to pull from the record which matchs this critieria .

Any ideas would be greatly appreciated

 

[synapsevampire]

I guess what you mean is that you want to show the for a row which has the lowest date for a given grouping.

Go to the Report->Selection Formulas->Group and enter:

{table.date} = minimum({table.date},{table.groupfield})

Now the report will only show those rows, so just palce the data in the report header or footer.

-k

 

[LikePork]

Got it working thanks!