Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-27-2020, 05:52 AM
Naveen Dhanaraj Naveen Dhanaraj is offline split table rows based Dynamic values generated for row Windows 10 split table rows based Dynamic values generated for row Office 2019
Novice
split table rows based Dynamic values generated for row
 
Join Date: Jan 2020
Posts: 20
Naveen Dhanaraj is on a distinguished road
Default split table rows based Dynamic values generated for row

I have a table in which all the row values are coming dynamically, In table i need to control only at certain level of page row should have values, if the values are more than expected it should print the values in the next page only at certain level as printed in the first page...


From Top to middle of the page all invoice line items will be available and at the end of the check will be printed.But if the invoice line items in row is higher, remaining table rows should be printed at next page and check should also skip first page and should be printed at the second page...


Please check attached image for reference





Thanks,
Naveen
Attached Images
File Type: png excel-invoice-template.png (72.5 KB, 14 views)
Reply With Quote
  #2  
Old 02-29-2020, 03:55 PM
Guessed's Avatar
Guessed Guessed is offline split table rows based Dynamic values generated for row Windows 10 split table rows based Dynamic values generated for row Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 1,705
Guessed is a glorious beacon of lightGuessed is a glorious beacon of lightGuessed is a glorious beacon of lightGuessed is a glorious beacon of lightGuessed is a glorious beacon of light
Default

Why are you using Word for this?

If you want Word help, post an example of what you already have and the source data that is being automated.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 03-04-2020, 11:55 PM
Naveen Dhanaraj Naveen Dhanaraj is offline split table rows based Dynamic values generated for row Windows 10 split table rows based Dynamic values generated for row Office 2019
Novice
split table rows based Dynamic values generated for row
 
Join Date: Jan 2020
Posts: 20
Naveen Dhanaraj is on a distinguished road
Default

Yes, you can refer above attached image.I was able to get this.But my problem is when invoice line items more than hundred line items check has to print in second page.Right now in above attached image we have only three line items....
Reply With Quote
  #4  
Old 03-05-2020, 12:16 AM
macropod's Avatar
macropod macropod is offline split table rows based Dynamic values generated for row Windows 7 64bit split table rows based Dynamic values generated for row Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,446
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

You haven't told us anything about how the document is being created or where the data come from. Nor have you supplied an example document as Andrew suggested. Images or documents are not the same.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 03-05-2020, 02:39 AM
Naveen Dhanaraj Naveen Dhanaraj is offline split table rows based Dynamic values generated for row Windows 10 split table rows based Dynamic values generated for row Office 2019
Novice
split table rows based Dynamic values generated for row
 
Join Date: Jan 2020
Posts: 20
Naveen Dhanaraj is on a distinguished road
Default

Data come from database....Values come from merge fields as previous post i have asked you..Assume in each page from mid portion to bottom of each page by default check outer or border line will be drawn. so we need to skip values to next page and if line items are completed printing on second page... check has to be printed inside the border line of second page... Only once check has to be printed not on both pages...
Attached Files
File Type: docx My New Template.docx (16.6 KB, 2 views)
Reply With Quote
  #6  
Old 03-05-2020, 04:31 AM
macropod's Avatar
macropod macropod is offline split table rows based Dynamic values generated for row Windows 7 64bit split table rows based Dynamic values generated for row Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,446
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

You are using 3rd-party software for your merge, not just Word, so we can't help you with that. In any event, the 'cheque' that you showed in post 1 doesn't appear in the document.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 03-05-2020, 05:17 AM
Naveen Dhanaraj Naveen Dhanaraj is offline split table rows based Dynamic values generated for row Windows 10 split table rows based Dynamic values generated for row Office 2019
Novice
split table rows based Dynamic values generated for row
 
Join Date: Jan 2020
Posts: 20
Naveen Dhanaraj is on a distinguished road
Default

yes merge field values are coming from different system.. because cheque has some client information so attached sample check. how could we control values printed on each page if the value exceeds it has to be printed on the next page.
Reply With Quote
  #8  
Old 03-05-2020, 02:15 PM
macropod's Avatar
macropod macropod is offline split table rows based Dynamic values generated for row Windows 7 64bit split table rows based Dynamic values generated for row Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,446
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

It doesn't matter that the merge field values are coming from a different system. That is to be expected. What matters is that you're using 3rd-party software (Aspose?, Conga?, RSA Archer?, Salesforce?) for your merge and you're limited to whatever options that software allows; it has nothing to do with Word.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #9  
Old 03-06-2020, 02:13 AM
Naveen Dhanaraj Naveen Dhanaraj is offline split table rows based Dynamic values generated for row Windows 10 split table rows based Dynamic values generated for row Office 2019
Novice
split table rows based Dynamic values generated for row
 
Join Date: Jan 2020
Posts: 20
Naveen Dhanaraj is on a distinguished road
Default

I'm using Conga
Reply With Quote
  #10  
Old 03-06-2020, 02:14 AM
macropod's Avatar
macropod macropod is offline split table rows based Dynamic values generated for row Windows 7 64bit split table rows based Dynamic values generated for row Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,446
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

In that case, ask on a Conga forum.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #11  
Old 03-06-2020, 03:23 AM
Naveen Dhanaraj Naveen Dhanaraj is offline split table rows based Dynamic values generated for row Windows 10 split table rows based Dynamic values generated for row Office 2019
Novice
split table rows based Dynamic values generated for row
 
Join Date: Jan 2020
Posts: 20
Naveen Dhanaraj is on a distinguished road
Default

Thanks Paul
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
split table rows based Dynamic values generated for row How to Split Dynamic merge field values to multiple columns Naveen Dhanaraj Mail Merge 17 02-19-2020 01:18 AM
Get all rows based on input values from a list soolsen Excel 1 03-27-2016 08:11 PM
Hide rows in multiple columns based on zero values Deane Excel Programming 19 06-23-2015 11:24 PM
split table rows based Dynamic values generated for row Insert values from multiple rows based on value in one column pachmarhi Excel 3 07-18-2014 09:57 PM
How to auto-split a table at FULL rows? pstein Word 5 03-27-2012 02:48 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft