Questions About Data Report

[thay]

I have two questions about data report:

- It is possible to print multiple records of the same field in the same line?
- How can print a data report with the page in horizontal automatically?

Anybody can help me?

[Shafee]

Hi there,

I have also been having the same problem with the orientation of a data report. From what I have learnt, the orientation of a data report depends on the default setting of the printer. This can be set from the control panel. However, you can use CommonDialog control to do this for you. Set the PrinterDefault Property to true, Orientation Property to 2 (in this case), and then use ShowPrinter method before showing the data report.

You can learn more about the CommonDialog control from the link below.

http://msdn.microsoft.com/library/de...mmondialog.htm

Regards,
Shafee

Hi

I can help you with the Landscape part, especially for network printer. First register the Pageset.dll. Let me know if you need it.Here are code that you can use:

Public gprinter As PageSet.PrinterControl (under option Explicit - module)

Call this on you report_Initialize

Public Sub Set_Landscape()
On Error GoTo SetLandscapeError

Set gprinter = New PrinterControl
gprinter.ChngOrientationLandscape

Exit Sub

SetLandscapeError:
MsgBox Err.Description & "Error setting Printer to Landscape"
gprinter.ReSetOrientation

End Sub

Just remember, if you are using Windows NT on a network, you must add a dummy printer that point to the network printer. NT does not allow you to change printer directly (must probably be administrator of network for access).

Hope this helps