In my case, I couldn’t proceed like that. So I looking for other way to do it; please tell me if it’s possible or give me your opinion.
1/ Event on Execute.
I will try it:
Exectue an event on excuteMailMerge where I execute an other Exectue mailMerge, but I’m not sure it will works.
2/ SQL Request
I modify my requests to get all information, then I Check all data and I put Blank or Null value. To finally get something like that:
# Original DataSet:
[Level1][Level2][Level3][Level4]
[Level1][Level2][Level3][Level4]
[Level1][Level2][Level3][Level4]
# Checked DataSet:
[Level1][Level2][Level3][Level4]
[][][][Level4]
[][][][Level4]
# To Display:
Level1.value
Level2.value
Level3.value
Level4.value
Level4.value
Level4.value
I’d try it, but with blank value it lets Fields blank so I obtain something like that
Level1.value
Level2.value
Level3.value
Level4.value
Level4.value
Level4.value
3/ Made ExecuteMailMerge by mySelf
Clone section mySelf then fill them for each row. In fact made my own ExecuteMailMerge. I’m working on it.
4/ Virtual Template
Make as in Catalog Demo but with virtual template (new Doc, without Template file) to combine them. And apply good Formatting for each section.
Thanks for your feedBack
Francois