Thava's Software Blog: August 2008

Exporting crystal report as PDF and sending via email as attachment - Filename Issue? : Crystal Reports for Visual Studio : Visual Studio : MSDN Forums: "Dim repdoc As New CrystalDecisions.CrystalReports.Engine.ReportDocument()

Dim diskOpts As New CrystalDecisions.Shared.DiskFileDestinationOptions()

Dim ExpOpts As CrystalDecisions.Shared.ExportOptions

Dim MailOpts As New CrystalDecisions.Shared.MicrosoftMailDestinationOptions()

repdoc = Me.CrystalReport11

repdoc.Load('C:\Documents and Settings\User\My Documents\Visual Studio 2005\Projects\WindowsApplication3\WindowsApplication3\CrystalReport1.rpt')

ExpOpts = repdoc.ExportOptions

With ExpOpts

.ExportDestinationType = CrystalDecisions.[Shared].ExportDestinationType.MicrosoftMail

.ExportFormatType = CrystalDecisions.[Shared].ExportFormatType.PortableDocFormat

End With

With MailOpts

.MailMessage = 'Message'

.MailToList = 'enter email adress here'

.MailSubject = 'Attached is a PDF file - .net Export test '

End With

ExpOpts.DestinationOptions = MailOpts

Try

repdoc.Export()

Catch err As Exception

MessageBox.Show(err.ToString())

End Try"

Crystal Reports version	Path to tutorials' sample code
Crystal Reports 11	C:\Program Files\Business Objects\Crystal Reports 11\Developer Files\Help\En\CR_NET_SDK_Tutorial_Sample_Code.zip
Crystal Reports for Visual Studio 2005	C:\Program Files\Microsoft Visual Studio 8\Crystal Reports\Samples\en\Code\TutorialSampleCodeProjects.msi
Crystal Reports Basic for Visual Studio 2008	C:\Program Files\Microsoft Visual Studio 9.0\Crystal Reports\Samples\En\Code\

private void ResetConnectionString()
       {
           string dbDir = this.GetDBDirectory()+ @"\JSNorthWind.MDB";
           this.nWindConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbDir + ";";

       }
       private string GetDBDirectory()
       {
           System.IO.DirectoryInfo currentDirectory = new System.IO.DirectoryInfo(Application.ExecutablePath).Parent;

           while (currentDirectory!=null)
           {
               System.IO.DirectoryInfo[] childDirectories = currentDirectory.GetDirectories();
               foreach(System.IO.DirectoryInfo childDir in childDirectories)
               {
                   if(childDir.Name=="Data")
                   {
                       return childDir.FullName;
                   }
               }
               currentDirectory = currentDirectory.Parent;
           }
           return "";
       }

Send instant messages to your online friends http://uk.messenger.yahoo.com

Aug 30, 2008

Aug 27, 2008

Aug 26, 2008

Aug 19, 2008

Aug 18, 2008

Aug 15, 2008

Aug 14, 2008

Aug 13, 2008

Aug 12, 2008

Aug 11, 2008

Aug 6, 2008

Aug 5, 2008

Aug 1, 2008