Crystal Report Generic Text Printer - Printing Problem

Hi
I am using vb6. Crystal Report 9. I use Generic / Text Printer to print Invoice. It shows everything ok in preview but when it prints, printing goes outside the printing area. I use mostly 10cpi fonts and for figures 17cpi fonts.Install the latest CR9 service pack. If problem remains, use another printer driver.

Crystal Report

I'm using Crystal Report 7.0, I have the following SQL expression

SELECT Invoice.`RG_Price`, Invoice.`RG_Item`
FROM ItemMaster INNER JOIN Invoice ON ItemMaster.`IM_Description` = Invoice.`RG_Item`
WHERE ItemMaster.`IM_ClassK1` IN ( "Wine (1)", "Wine (2)", "Wine (3)", "Wine (4)", "Alcohol Drinks");

However I'm getting a syntax error. I tried adding {} to the fields however it didn't make a difference. I also read in a google search that CR at times adds the SQL keywords like "SELECT", so I removed the keywords sequencially. But, no success.

If anyone can help me on this issue I would appreciate it.

Thank you,
Vinny PI read that adding the code into a formula may help. However, I did so and still got syntax errors. I also seuqentially remove the keywords as another alternative.

If anyone can help I would appreciate it :)

Thank you,
Vinny P|||Waht is the error you are getting?|||Would you loke to post the error message?
I use crystal report 10,I nver use Crystal Report 7.0,maybe it's so old

Crystal Design

Hi,
I've a standard Invoice template with Page header, Group Header and Detail section. Invoice can be of one page or multiple pages depending on the number of invoice line items. I want to print Customer service and payment details (fixed text of about 40 lines) on the back of every page. How do I achieve this. Any help is much appreciated.

thanks & regards
radhastart a new page after group footer. if ur invoice is of one page , then this new page can be printed on back.|||Thanks for this. It works fine when the invoice has one page.
My report is grouped by Invoice Number so for an Invoice with multiple pages group footer prints on the last page of the invoice and the balnk page prints after the last page of the Invoice. My requirement is to print the details on the back of each page. Any help would be much appreciated.

thanks & regards

radha