Torna al Thread

Private Sub CaricaReport() Dim strProvider As String = "Provider = Microsoft.Jet.OLEDB.4.0;" Dim NomePerc As String = CStr(Me.txtNomePerc.Text) Dim strOrigine As String = "Data Source=" & Application.StartupPath & "\dbTEMP.mdb" Dim strConnessione As String = strProvider & strOrigine Dim Conn As OleDb.OleDbConnection Conn = New OleDb.OleDbConnection(strConnessione) 'Carica la tabella articoli per il report' Dim cmdArt As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Articoli", strConnessione) Dim objTable As New DataTable() cmdArt.Fill(objTable) 'Carica la tabella cliente per il report' Dim cmdCliente As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Cliente", strConnessione) Dim objTableCliente As New DataTable() cmdCliente.Fill(objTableCliente) 'Carica la tabella scadenze/importi per il report' Dim cmdScadImp As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM ScadImp", strConnessione) Dim objTableScadImp As New DataTable() cmdScadImp.Fill(objTableScadImp) 'Carica la tabella trasporto per il report' Dim cmdTrasp As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Trasporto", strConnessione) Dim objTableTrasp As New DataTable() cmdTrasp.Fill(objTableTrasp) 'Carica la tabella Note per il report' Dim cmdNote As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM NoteDoc", strConnessione) Dim objTableNote As New DataTable() cmdNote.Fill(objTableNote) 'Carica la tabella Iva per il report' Dim cmdIva As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Tot_Iva", strConnessione) Dim objTableIva As New DataTable() cmdIva.Fill(objTableIva) 'Carica la tabella Totale a pagare per il report' Dim cmdPagare As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Pagare", strConnessione) Dim objTablePagare As New DataTable() cmdPagare.Fill(objTablePagare) 'carica la tabella documenti e la inserisce nel report' Dim cmdDoc As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Documenti", strConnessione) Dim objTableDoc As New DataTable() cmdDoc.Fill(objTableDoc) Dim RepPath As String = Application.StartupPath & "\FT2.rpt" Dim Report As New CrystalDecisions.CrystalReports.Engine.ReportDocument() Report.Load(RepPath) 'Alimentazione del report con le tabelle caricate' Report.Database.Tables("Articoli").SetDataSource(objTable) Report.Database.Tables("Cliente").SetDataSource(objTableCliente) Report.Database.Tables("Documenti").SetDataSource(objTableDoc) Report.Database.Tables("Trasporto").SetDataSource(objTableTrasp) Report.Database.Tables("NoteDoc").SetDataSource(objTableNote) Report.OpenSubreport("PagTrasp").SetDataSource(objTableTrasp) Report.OpenSubreport("Scadenze").SetDataSource(objTableScadImp) Report.OpenSubreport("Iva").SetDataSource(objTableIva) Me.CrystalReportViewer2.ReportSource = ReportEnd Sub
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5