Put duplicated data in a report (1 Viewer)

ariansman · Mar 20, 2019

Please help me to make this report:
We are making an invoice which should be split for the costumer and also the store. Can we design a report to have the same identical result in one page such as the following?

Code:

customer name: Akbar Bond  
Service-ID        product      adviser       cost
54                pencil         Jack        500
65                staple         John        350


                                           Sum: 850
---------------------------------------------------------
customer name: Akbar Bond  
Service-ID        product      adviser       cost
54                pencil         Jack        500
65                staple         John        350


                                          Sum: 850

June7 · Mar 20, 2019

It is possible to force a record to repeat but I've never tried for an entire section.

Possibly easiest to use 2 subreports.

Are you just trying to conserve paper? What if invoice extends over multiple pages?

isladogs · Mar 20, 2019

Can I ask why you don't just print or email 2 copies - one for the customer and retain or send one to the store

ariansman · Mar 21, 2019

isladogs said:
Can I ask why you don't just print or email 2 copies - one for the customer and retain or send one to the store

Some employees are too distracted. Making one click to make two record in a sheet is easy, but making the second click will need extra IQ and attention. I wish it was possible to be done in one sheet.

isladogs · Mar 21, 2019

You could use button event code so that it automatically prints two copies or if emailing use code to send to customer with copy to store. No need to depend on end user remembering to do so.
With your idea, it would mean cutting/tearing a sheet of paper into two pieces.
I'm sure its possible but I really don't see the point.
In fact someone appears to have provided an example for you at another forum where you crossposted http://www.accessforums.net/showthread.php?t=76170

Please see this link about crossposting https://www.excelguru.ca/content.php?184-A-message-to-forum-cross-posters

Put duplicated data in a report (1 Viewer)

ariansman

Registered User.

June7

AWF VIP

isladogs

MVP / VIP

ariansman

Registered User.

isladogs

MVP / VIP

Similar threads

Users who are viewing this thread