missing graphic in report

[Lewy]

Hi everyone,

I have a report that prints out a single Invoice using a 'shadow table' technique. The report is on one sheet of A4 paper and includes a graphic object in the Page band (our Logo) along with our address details. When using a pushbutton to print out the invoice the graphic is missing. However if I print the report direct from the original table the graphic IS printed but the length of the report doesn't give one record per page. Any suggestions would be much appreciated.

Many thanks,

Paul Lewis

 

[Snah]

paul,

is you logo in the report header or the page header?
is it linked to the table or just a graphc object?

hans

 

[Lewy]

The graphic object is palced in the Page Header and viewing properties says it is an OLE object. It is not attached to a table.

Trust this helps.

Thanks,

Paul

 

[Snah]

Paul,

1. The logo should be a graphics object, NOT an OLE object.

2. When you view the report on the screen is there a gray dotted line (page boundery)though the logo? If so make sure that the object is within the page bounderies. Otherwise you probably get the message 'clipping to page with, possible data loss'

hope this helps
hans

 

[Lewy]

Many thanks Hans,

A quick 'Cut & Paste' did the trick. Now all I have to do is to work out all the invoice breakdowns, still it keeps me off the streets (grin)

Regards,

Paul

 

[Snah]

Paul,

have you tried to group on invoice number?

hans

 

[Lewy]

Hans,

It's not so simple as that. I have 4 categories of products that I provide.

1. Eye Examinations with No sales tax
2. Cash Sales, such as cleaning cloths with full Slaes tax
3. Spectacle & contact lens sales with 36% of retail cost with sales tax.
4. As 3. but with the remaining 64% of retail cost with no sales tax.

The invoice has to show the complete breakdown.

ie. Eye Exam £20.00
Cleaning cloth £3.00 £0.47 sales tax incl.
Value of spectacles £32.40 £4.83 sales tax incl
Exempt professional fee £57.60
Total £113.00
Less deposit £50.00
Balance £63.00

I have developed a form to enter the invoice with calculated fields showing the breakdown of spectacle and contact lens sales, but it doesn't includes cash sales yet. I also want to generate a report each day showing what has been paid, by what method (cash, cheque, credit card) and in the relevant tax categories. Finally I shall need to clear the balances on collection of their spectacles.

Easy to do manually, just breakdown the figures and write them on pre-printed receipts, gets tricky on the old Pc.

If you have any thoughts you can help me with it would be much apreciated.

Thanks,

Paul

 

[Lewy]

Hans,

It's not so simple as that. I have 4 categories of products that I provide.

1. Eye Examinations with No sales tax
2. Cash Sales, such as cleaning cloths with full Slaes tax
3. Spectacle & contact lens sales with 36% of retail cost with sales tax.
4. As 3. but with the remaining 64% of retail cost with no sales tax.

The invoice has to show the complete breakdown.

ie. Eye Exam £20.00
Cleaning cloth £3.00 £0.47 sales tax incl.
Value of spectacles £32.40 £4.83 sales tax incl
Exempt professional fee £57.60
Total £113.00
Less deposit £50.00
Balance £63.00

I have developed a form to enter the invoice with calculated fields showing the breakdown of spectacle and contact lens sales, but it doesn't includes cash sales yet. I also want to generate a report each day showing what has been paid, by what method (cash, cheque, credit card) and in the relevant tax categories. Finally I shall need to clear the balances on collection of their spectacles.

Easy to do manually, just breakdown the figures and write them on pre-printed receipts, gets tricky on the old Pc.

If you have any thoughts you can help me with it would be much apreciated.

Thanks,

Paul