REPORT TEMPLATE

[bolognesiedalla]

Hello everybody. I set up these tables to build a fertilization plan.

The plan I would like to print should look like this

intervention 1
[]

[RIGAINT1] ....
[RIGAINT2] ....
[RIGAINT3] ....

intervention 2
[PERIOD]

[RIGAINT1] ....
[RIGAINT2] ....
[RIGAINT3] ....

ETC...

The INTERVENTION ROWS table is a part of the PLAN ROWS table which is a part of the PLANS table.

However, when I print the report, I would like the relative INTERVENTION ROWS to appear under each PLAN ROW. While set in this way, the report first puts all the PLAN LINES and then all the INTERVENTION LINE.

I don't know if I've made myself clear. Do you think it is possible?

[Suvrutt_Gurjar · Accepted solution]

Please try below.

You could have the INTERVENTI table columns outside the tabular format, something like 

<<START: [Related INTERVENTIs]>>

<<[ID INT]>>

<<[ID PIANO]>>

..........

............

RIGHE INTERVENTI

IDRIGA	IDINT			DOSAGGIO
<<START:[Related RIGHE INTERVENTIs]>> <<[IDRIGA]>>	......	.......		,<<[DOSAGGIO]>> << END >>

<< END>>

In short: please bring the INTERVENTI table outside the tabular format.

[bolognesiedalla]

ok. Thank you.
I have only one doubt.
How can I get this reported

[IDINT-1]
[IDRIGA1].[IDINT-1]
[IDRIGA2].[IDINT-1]
[IDRIGA3].[IDINT-1]

[IDINT-2]
[IDRIGA1].[IDINT-2]
[IDRIGA2].[IDINT-2]
[IDRIGA3].[IDINT-2]

[IDINT-3]
[IDRIGA1].[IDINT-3]
[IDRIGA2].[IDINT-3]
[IDRIGA3].[IDINT-3]

etc...

instead of this:

[IDINT-1]
[IDINT-2]
[IDINT-3]

[IDRIGA1].[IDINT-1]
[IDRIGA2].[IDINT-1]
[IDRIGA3].[IDINT-1]
[IDRIGA1].[IDINT-2]
[IDRIGA2].[IDINT-2]
[IDRIGA3].[IDINT-2]
[IDRIGA1].[IDINT-3]
[IDRIGA2].[IDINT-3]
[IDRIGA3].[IDINT-3]

etc...

always considering that both the number of INTERVENTIONS and INTERVENTION ROWS are both variable (they can be 2-3-5-7-10 or even more)

[Suvrutt_Gurjar]

You could try the template suggested.

[bolognesiedalla]

Great it works !!!! Thanks so much !!. How can I remove the repetition of the word "INTERVENTI"?

[Suvrutt_Gurjar]

The way your template is constructed, the word INTEREVENTI should not repeat. It is outside any repetitive <<START>> statement.

Are you sure it is repeating? It should just appear once below the column Note after which the two <<START>.> loops execute.