Merge in single document

Aspose.Words Product Family
1

Hello,
how to merge sql request result into array of a single document and insert total section for each group of this request ?

Thanks.

2

Hello

Thank you for your interest in Aspose.Words. Could you please provide me more information about your requirements? I think, in this case, you can use simple Mail Merge. Please follow this link to learn more:
https://docs.aspose.com/words/net/types-of-mail-merge-operations/
Best regards,

3

Thank for your prompt reply,

i’ m working with vs2005 / asp.net, sqlserver in fact, that would like to is to have same result than a report tool with grouped sql request result, i.e. :

col1 col2 col3 col4
A xxx xxx 999
A xxx xxx 999
A xxx xxx 999
TOTAL A 999

B xxx xxx 999
B xxx xxx 999
TOTAL B 999

is it possible to do that with aspose and if yes, what is the best way ?

thank

4

Hello

Thank you for additional information. I think, you can use nested mail merge regions in order to generate such reports. You can find a simple example here:
https://forum.aspose.com/t/79905
Hope this helps. Please let me know in case of any issues, I will be glad to help you.
Best regards,