Want to display set of records in one page instead of each record in one page

Aspose.Words Product Family
1

Hi,
I want to display all the invoice details in a single word document instead of display single record in each page in word document. How can i do this?

Thanks,

Prakash

2

Hi Prakash,
Thanks for your request. Could you please attach your template and the output document and the expected output here for testing? We will check the issue and provide you more information.
Best regards,

3

Hi,
As per your request, i have attached my template, output format and expected format.

Thanks in advance,
Prakash

4

Hi,
Thank you for additional information.
You need to use nested mail merge regions.
Details you can be found here in this article: https://docs.aspose.com/words/net/nested-mail-merge-with-regions/. I am a little changed your template, I used a table instead of positioning by spaces.
If you still have questions after reading, do not hesitate to ask.

5

Hi,
Thanks, Its Working fine.
But instead of using tables i need to use Stored Procedures in sql server to display my records in the word document.
How it can be done?
Thanks in advance,

Prakash

6

Thanks for your additional information.
It’s great that everything is going well.
Under the “table” I meant markup in a document using tables. That how you get the data for your report does not really matter. You could just as easily can use the data stored in files as well as receive data from the database through stored procedures.
If you have any questions with regards to mailmerge, fell free to ask.

7

Hi,
Is there any sample Invoices or codes available like sales invoice which is using the Stored Procedures to show the Report document? Is so please send me the link. Actually we won’t database tables to populate reports, we use only the stored procedures, In stored procedures we will get the required columns from the required tables with some conditions but its not possible if we use the tables directly to fetch data s.

Thanks,

Prakash

8

Hi
Thanks for your request. You can use any data source to execute mail merge. For instance, in case of using Stored Procedure, I think you can easily use IDataReader as a data source. Please see the documentation for more information:
https://docs.aspose.com/words/net/types-of-mail-merge-operations/
Best regards,