Torna al Thread

Private Sub Anteprima_Software() Dim daT1, daT2 As MySqlDataAdapter Dim dtsReport As DataSet Dim strSQL As String Try strSQL = "Select software_licenza.Nr_Progres,Software.Programma,Software.Versione,Software.Tipo_Licenza,software_licenza.Chiave,software_licenza.Data_Licenza,software_licenza.Nr_Licenze_Totali,software_licenza.Nr_Licenza, " & _ "software_licenza.Licenza_Uso, software_licenza.Nominativo,software_licenza.Ubicazione,software_licenza.Nr_Apparato From software Inner Join software_licenza On sgri.software.ID = sgri.software_licenza.ID_Software Order By software_licenza.Nr_Progres" daT1 = New MySqlDataAdapter(strSQL, ConnMySQL) dtsReport = New DataSet daT1.Fill(dtsReport, "Registro_Software") strSQL = "SELECT * FROM timbri " daT2 = New MySqlDataAdapter(strSQL, ConnMySQL) daT2.Fill(dtsReport, "Timbri") Dim rpt As New rptRegistro_Software rpt.SetDataSource(dtsReport) Dim CRView As New Report CRView.CRViewer.ReportSource = rpt 'Creo la cartella System.IO.Directory.CreateDirectory(AppDomain.CurrentDomain.BaseDirectory + "\Report\Registro_Software\") 'Esporto il report in PDF rpt.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, AppDomain.CurrentDomain.BaseDirectory + "\Report\Registro_Software\" & Mese(Month(DateTimePicker1.Value)) & " " & Year(DateTimePicker1.Value) & ".pdf") Dim proc As New Process 'Apro il mio file Process.Start(AppDomain.CurrentDomain.BaseDirectory + "\Report\Registro_Software\" & Mese(Month(DateTimePicker1.Value)) & " " & Year(DateTimePicker1.Value) & ".pdf") 'Chiudo ed elimino il processo' proc.Close() proc.Dispose() Catch ex As Exception MsgBox(ex.Message.ToString) End Try End Sub
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5