I want to have a report with the following layouts in this sequence:
tdcms060.reln
tdsls040.ccur
tdcms060.orno
tdcms060.pono

Doing this I have a problem with the sequence of the layouts. They are sorted in alphabetic order:
tdcms060.orno
tdcms060.pono
tdcms060.reln
tdsls040.ccur

Is there a way that the layouts can be sorted in a way I want??

All help is appreciated...

In the report fields u can specify the sort order and ascending /descending . Isnt that suffcient .

If there is still problem , please elaborate .

Hi Hitesh,

Long time not seen.... (1996/7 Baan Barneveld.....)

In my opinion the sort method ascending and descending is related to the sort of the records and not to the sequence of the individual layouts.
There is no problem in generating the report but when I do a ' Maintain all layouts' then the layouts are sorted in alphabetical order and not in the sequence I want.

This is what I want:
header
before.field tdcms060.reln
before.field tdsls040.ccur
before.field tdcms060.orno
before.field tdcms060.pono
detail
after.field tdsls040.ccur



Thanx in advance,

ONNO

I have noticed that before - as far as I know there is not a way to change it.

I think you can create external Variable (alphabetical) and assigned to the table fields of your sorted orders. Then use these External Variables to build your report layout.

Example:

extern domain xxxx var.1 | tdcms060.reln
extern domain xxxx var.2 | tdsls040.ccur
extern domain xxxx var.3 | tdcms060.orno
extern domain xxxx var.4 | tdcms060.pono

Good-Luck

If I am correct and understood, Can you select those layouts by control + clicking and Edit Layout? Isn't enough?

regards,

-Suhas

If I am correct and understood, Can you select those layouts by control + clicking and Edit Layout? Isn't enough?

regards,

-Suhas

No, that's not enough. I want the layouts printed in a not-alphabetic order.

I think you can create external Variable (alphabetical) and assigned to the table fields of your sorted orders. Then use these External Variables to build your report layout.

Example:

extern domain xxxx var.1 | tdcms060.reln
extern domain xxxx var.2 | tdsls040.ccur
extern domain xxxx var.3 | tdcms060.orno
extern domain xxxx var.4 | tdcms060.pono

Good-Luck

Do I have to assign the table fields to the variables in the programscript or in the report script? I assume the first and I don't want to maintain the program script...

Hi Onno ,

I am fine . Hope u too r fine .

U have to assign the same in program script . I think after.receive.data also will not help as that works after report tmp file sorting .

Onno,

if you don't want to change the session script and you need to do all within your report, maybe my thread
http://www.baanboard.com/baanboard/showthread.php?t=9090&highlight=advanced might be useful. That principle works if your report requires sorting.

But I'm not sure if it will help you regarding your original problem.

Günther

No, that's not enough. I want the layouts printed in a not-alphabetic order.
I have read this thread several times and I still do not understand what you are asking for. The layouts print based on the sort order of the report - not the way you see the layouts in the maintain layouts session. Why does it matter what order you see the layouts in, if they print in the correct order? I have several reports that use mainwc and subwc as the first and second sorts. When I look at the layouts I see detail, after field main wc and after field subwc. I know that the subwc layout will print before the main wc layout - so I do not care what order I see the layouts when designing the report. And yes - even if I switch the sort to sub.wc and main.wc I see them in the same order. Am I missing something? Why do you have to see the layouts in any certain order?

If there is something printing incorrectly that is a different matter, then you might need to change the sort to get things group correctly.

@Mark_h
You are right stating that the report is printed in the way I want but when I do a "Maintain all layouts' the layouts are displayed in an alphabetical sequence. When I do so I suppose that Baan gives me a kind of preview of the report layout (WYSIWYG). That's not the case and that's clear to me now.

Thanks for all your effort!