'Maximum' Parameter

[ClowneUser]

Hi,

I'm using Crystal XI querying an Oracle 10g DB, I have a report, that contains a subreport, the main report gets info about a part, part no, description, issue number, unit of measure etc... the sub report gets routing information, I found the easiest way to get the info was to print a routing report from our erp system (IFS ) and this puts all the fields I need into one table/view, this works fine, the only problem is if someone prints the report more than once, then we get duplicates, and also there is more than one way to print the report, depending on the way the report is printed, will dictate the information we get in the table, there is a unique number assigned in the table for each print job which is given to each line.

So what i would like to do is have a select parameter that only brings back the maximum of this field ( i hope this makes sense ) because the user will run the IFS report, then print my report straight after, so this should work fine.

Thanks in advance for your help.

Mick.

 

[dgillz]

Use a selection formula in the subreport to return only the maximum of the routing info.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[ClowneUser]

Hi,

Thanks for your reply, I have tried to do this, but cannot find the correct syntax, what I have tried is:

{STRUCTURE_INFO_REP.RESULT_KEY} = (maximum ({STRUCTURE_INFO_REP.RESULT_KEY}))

but i get 'This function cannot be used because it must be evaluated later'

Is this correct or should i try some other parameter?

Thanks in advance,

Mick.

 

[dgillz]

How are you creating this formula? This should not be a formula field, it should be a group selection formula.

{STRUCTURE_INFO_REP.RESULT_KEY} = maximum ({STRUCTURE_INFO_REP.RESULT_KEY})

You get there by going to report->selection formulas->group.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[ClowneUser]

Thanks Dgillz, I'd just figured that out, added it as a group selection formula, now it works as i need it to.

Thanks for your time on this.

Mick.