Results 1 to 2 of 2

Thread: [RESOLVED] Crystal Report Page header and formatting for the other records missing

  1. #1

    Thread Starter
    New Member
    Join Date
    Sep 2019
    Posts
    8

    Resolved [RESOLVED] Crystal Report Page header and formatting for the other records missing

    Please help when I export my reports to excel only the first set of data have the formatting and page break but the succeeding data have no formatting whatsoever only their dates and time data. I already searched google but I can't find what I am looking for. I already tried creating a export button but somehow I can't access the default formatting options of crystal report. I attached the resulting excel file exported for your reference and also the code that I tried to work on.

    Code:
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
            Try
                Dim CrExportOptions As ExportOptions
                Dim CrDiskFileDestinationOptions As New  _
                DiskFileDestinationOptions()
                Dim CrFormatTypeOptions As New ExcelFormatOptions
                CrDiskFileDestinationOptions.DiskFileName = _
                                            "d:\crystalExport.xls"
                CrExportOptions = cryRpt.ExportOptions
                With CrExportOptions
                    .ExportDestinationType = ExportDestinationType.DiskFile
                    .ExportFormatType = ExportFormatType.Excel
                    .DestinationOptions = CrDiskFileDestinationOptions
                    .FormatOptions = CrFormatTypeOptions
                End With
                cryRpt.Export()
            Catch ex As Exception
                MsgBox(ex.Message)
            End Try
        End Sub
    Attached Files Attached Files

  2. #2

    Thread Starter
    New Member
    Join Date
    Sep 2019
    Posts
    8

    Re: Crystal Report Page header and formatting for the other records missing

    I already saw what made my report not exporting as I wanted. I inserted 3 group section and put the group data inside the page header section. I now corrected it and remove the other 2 group section because one is already enough and I put the user details inside the group section. Now it exporting as the way I wanted. Thanks by the way

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width