[SOLVED]After days of searching, I found this solution obviously being new to this field, it's an inelegant solution but it works. However I will look for a better solution. Hope it helps someone.
private void btnPrint_Click(object sender, EventArgs e)
{
try
{
DGVPrinter printer = new DGVPrinter();
printer.Title = "INIT PAGE";
printer.SubTitle = string.Format("Date: {0}", DateTime.Now.ToLongDateString() + " Time: " + DateTime.Now.ToLongTimeString(), printer.SubTitleColor = Color.Black, printer);
printer.SubTitleFormatFlags = StringFormatFlags.LineLimit | StringFormatFlags.NoClip;
printer.PageNumberAlignment = StringAlignment.Near;
printer.HeaderCellAlignment = StringAlignment.Near;
printer.PageNumbers = true;
printer.PageNumberInHeader = true;
printer.PorportionalColumns = true;
printer.printDocument.DefaultPageSettings.Landscape = true;
printer.Footer = "END PAGE";
printer.FooterSpacing = 15;
this.dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("tahoma", 6, FontStyle.Regular);
this.dataGridView1.DefaultCellStyle.Font = new Font("tahoma", 6, FontStyle.Regular);
this.dataGridView1.Columns["ID"].Visible = false;
printer.PrintPreviewDataGridView(dataGridView1);
this.dataGridView1.ColumnHeadersDefaultCellStyle.Font = new Font("tahoma", 8, FontStyle.Regular);
this.dataGridView1.DefaultCellStyle.Font = new Font("tahoma", 8, FontStyle.Regular);
this.dataGridView1.Columns["ID"].Visible = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Information);
conn.Close();
}
}