Query or Report? 1

[BLutgen]

I can approach this problem from two different ways, but only one may work. I currently have a query that searches for a certain range of order numbers. The query is then printed in spreadsheet format for office use. I either have to A: somehow put a footer on the bottom of the query when it is printed, or B: put the information into a report, but have the report print out like a spreadsheet, including the lines. Do I have to maually draw in all of the lines? I then could add a page footer to the report. How should I approach this, and then how do I do whichever one of these is the solution to my problem. Thanks a bunch for the help.

Brad

 

[Launcher6]

I have done this both ways through a query and a report. To use the query option I use the excel external data method and have the query import into excel then have the calculations I want done completed on a separate sheet within the workbook.
To use the report is a little more time consuming, but you don't have to have you calculations on a separate worksheet or elsewhere within the sheet. Yes, you do have to draw every line between the fields in the report, but I use the copy and paste command to copy one line then continue to paste for each line I need. You may also be able to use the group footer option to calculate on more data. You could try either way.

Hope this helped you.

 

[JoeMiller]

No, you do not have to draw the lines in between each field!! As a matter of fact, if you do the report will print slower than dirt because of all the .BMP objects that get sent to the printer.

Set your snap-to-grid on (Format-->Snap-To-Grid) if it isn't already, put the fields in the report. Size each control into the grid, placing them next to each other, then set the border of the controls to a color (most likely black. If all the controls are sized to meet the adjoining controls, when you print it it will look like a spreadsheet and will be a much smaller print job (in size).

HTH Joe Miller
joe.miller@flotech.net