How can I sort data by a calculated field in Report Writer?

(0) Share

Report

Posted on by Richard Sun

190

I need create a header by using a calculated field. If the field is not a key, a sort definition has to be created first. But it looks to me that there is no way to create a sort definition with calculated field.

Any suggestions would be greatly appreciated.

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Richard Sun 190 on at

Like (0)

Report
Copy link

Link copied!

Is there anyone helping on this?

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Hi Richard,

I'm not going to be any help - but I don't know of a way to do this in Report Writer.

Kind regards,

Leslie

Was this reply helpful? Yes No
Richard Sun 190 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response, Leslie. Since there is no way to do this in Report Writer, does VBA help in this case then?

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report
Copy link

Link copied!

Hmm,

I'm not sure about sorting, that's pretty hard coded in Report Writer. Perhaps someone out there knows a secret method. I do not, short of a third-party solution that is.

Kind regards,

Leslie

Was this reply helpful? Yes No