 | cooper collier 9/29/2023 9:22:04 AM I do not think there is a way to force a new page code for each record. You may be able to have it create a doc for the parent record, then a new document for each child record. So if you have 3 child records, you would get 4 files, Parent.doc + child1.doc .... I know this is not the best Idea...
There may be another way, but I need details.
How many records would be in the child table. Would it possibly a fixed number. If it was always 3 records, no less no more, that would be significant.
Can you give an idea or example of what is in the child table?
Maybe you can attach or email me a sample of the final document if you have a sample of what you need?
cooper@frobbit.com
|
 | Rebecca Sell 9/29/2023 9:24:40 AM Thanks Cooper
That's a shame ... really limits the application of the system
R
|
| Rebecca Sell 9/29/2023 9:25:45 AM Should have added .... no the number of child records would vary. Its a contract layout, 1 page for the header and 1 page for each service sold.
regards
|
 | Slava Shinderov 9/29/2023 9:26:16 AM @Rebecca if you've needed a separate page/document for each child record maybe you should build your document using child record instead of parent record.
|
| cooper collier 9/29/2023 9:36:03 AM Slava.
Printing from the child record table would still result in separate documents.
I am thinking a work around, if there was a limit to how many child records. You could do an index summary and get thhe info for each child record and then put that on the document.
But this would be a hassle for programming and each index summary would slow down the performance a bit. At some point it would make your database so slow as to be unusable.
Still, I have regularly performed, 3-4 index record summaries without noticeable performance impact.
Rebeca, do you have a sample document or template we can look at for you?
|
| Rebecca Sell 9/29/2023 9:36:04 AM Hi Slava
How would that work please? 1 parent/3 child so want 1 x 4-page document ...
Regards
|
| Rebecca Sell 9/29/2023 9:39:15 AM Thanks for the offer but I cannot share for confidentiality reasons.
I have an idea .... I'll report back! :-)
|
| cooper collier 9/29/2023 9:46:50 AM If your idea works tip us on what you did, we all can learn something new.
If you still need some help, there are still a few options.
1. I can sign a NDA and then help.
2. You can make a copy of your database without data in it. Then you can put some fake data in, then we can do some tests and maybe help you out.
|
| Rebecca Sell 9/29/2023 9:54:13 AM OK ... I am wondering if we can use the document from TD as a 'raw' report but then use that document to create a more sophisticated presentation in Sway.
I'll let you know if it works.
R
|
 | basenine 9/29/2023 10:02:32 AM Hello Rebecca,
How much information per row will there be?
Perhaps a row can be set with a defined height and to not break across page(s). The first row can be set as a header row (check the box for repeat across pages).
Best regards
Brett
|
| basenine 9/29/2023 10:03:41 AM You’d also put a page break after the information from the parent record and before the child record data
|
| Rebecca Sell 9/29/2023 10:04:51 AM Hi Brett
My conclusion is that we need something way more sophisticated in presentation that TD allows. I thought I be able to use Word to design a pretty layout and slot in the fields. But this isnt the case sadly.
Admitting defeat.
Thanks guys.
R
|
| cooper collier 9/29/2023 10:11:51 AM I would not admit defeat.. yet..
How many columns are in the Child Table?
What would be a reasonable maximum of child records for a parent?
|
| basenine 9/29/2023 10:14:08 AM Hello Rebecca,
Are you able to mock up a sample of what you’d like and send it through
My email is brett@basenine.com.au
I’ll be able to tell pretty quickly if it’s possible or not😊
|
| basenine 9/29/2023 7:01:10 PM |
| Rebecca Sell 9/30/2023 4:58:48 AM Thanks to everyone who has contributed to this challenge!
Forced to work within the limitations given, I have produced a professional looking document by:
Going to landscape rather than portrait mean that the child columns across the page look more in proportion
Using the 'tall row' suggestion given above
Stacking fields on top of each other within one column reduces the number of columns across the page and looks much neater
Thanks again all!
R
|
| basenine 9/30/2023 6:54:46 AM Outstanding
|
