I wish to customize a report from a LN standard report, but the field i need to set as GROUP (before.field) is not the input field of the standard report, tried to insert it at input field but the field didn't show in the report.

my scenario is:

1. Duplicate a standard report <tfacr243813000> to a new customize report.
2. Add in field "tfacr200.dim1" in <Report Input Fields>, and set it to "Presorted".
3. Set field "tfacr200.dim1" as "Before.Field", insert the field in report layout.
4. Add the report to be printed from session <tfacr2438m000>.
4. Run the report, "tfacr200.dim1" not show in report.

We don't have license for viewing and amending the session script, so, i am guessing whether the field "tfacr200.dim1" is not selected from the print session script, thus, it can't be shown and set as before.field in the report?

In this case, how should i do to amend this standard report for grouping the report by tfacr200.dim1?

Yes - it can be done. See performance dll (http://www.baanboard.com/baanboard/showthread.php?t=28569) or this this thread (http://www.baanboard.com/baanboard/showthread.php?t=55850&highlight=Add+sort+fields+reports) - post by me. Never really used the performance DLL and the one we used here is not exactly the easiest to work out. In my case we had to look up a field, add to report datafile, resort the file and then print it. Not easy to do.

Seems like there was another solution somewhere, but I did not see it.

Found it http://www.baanboard.com/baanboard/showthread.php?t=9090 - see this post by gunther.

Hello,

i'm able to choose the field tfacr200.dim1 as report inputfield.

So be more specific, please.

Regards

Hello,

i'm able to choose the field tfacr200.dim1 as report inputfield.

So be more specific, please.

Regards

i can choose the field tfacr200.dim1 as report inputfield as well. But, the field data is not displayed after i run the report.

Hi,

you can choose every(!) table field as input field, so that's not the point.

If the session does not support (fill) that field, one typical work-around is to read the data within the report. That is done very often. But sometimes it can be very tricky, e.g. if you want to sort on such a field. In that cases see my thread "advanced report customization" already noted by mark.

günther