Sorting Data problems .

[mudflap]

I have 5 columns of data that appear after running 5 separate forumlas..I am unable to sort any of that data.
How do I go about do this..
Regular sorting only allows you to choose your fields and not data that was created by a forumla..How do I get around this?

Thanks
Peter Harrison

 

[dgillz]

You can sort most formula field, provided that they do not have a summary operation in them such as sum, count, maximum; they do not use the previous() or next() functions; or are not evaluated WhilePrintingRecords.

Please post the formula of a field you want to sort on and lets see what we can do with it. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[mudflap]

Ok, here is one of the formulas I am using.

whileprintingrecords;
stringvar job2;
stringvar job2a;

If {Prepress WIP.Production Status (User Defined)} in [&quot;Out on Proofs (No Film Imaged)&quot;,&quot;Out on 2nd Proofs (Film Imaged)&quot;,&quot;Out on 2nd Proofs (No Film Imaged)&quot;] and {Prepress WIP.Proofs Due (Date) (User Defined)} < currentdate -1 then
job2 := job2 + {Prepress WIP.Docket (User Defined)} +chr(13)
else job2a := job2;

I want to sort the list I get from this formula.

Thanks
Peter

 

[dgillz]

You cannot do it because it is WhilePrintingRecords. Write this formula without variables and you should be fine. I do not know what you arew trying to accomplish, if you give me some more background I may be able to help you. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Naith]

You can't do this in this formula, Peter, because this formula - as all your totalling formulae do - use WhilePrintingRecords to deduce their values.

The only way you can realistically get their output to appear sorted, is to first sort the fields the running totals are processing against, but this may conflict with the order hierarchy you have at present - like dates.

Naith

 

[mudflap]

Ok, thanks guys I won't bother. Its not that important.

Peter