Welcome to Forums Sign in | Join | Help | Forums
in Search





Make the world a better place.

Export reports

Last post 04-14-2008 9:24 AM by James Shuttlesworth. 0 replies.
Page 1 of 1 (1 items)
Sort Posts: Previous Next
  • 04-14-2008 9:24 AM

    Export reports

     I'm a farily novice coder when it comes to COM objects - I need to write a API based program to export reports automatically - i based it almost verbatim from the 'reports' sample provided with FE (relevant code below) but i can't seem to set anything with the 'exportoptions' propery that would allow it to export; the preview and print functions work great, but i really need to either e-mail the report or save it as a file.  can anyone provide a little guidance as to what i need to do with that 'exportoptions' property?

     

     

     'Cycle through each report and preview them
                    For Each oReport In oReports
                   
                        With oReport
                            .Init goFE_API.SessionContext
                           
                           'Process only the Profiles generated by the Supervisor
                            If .Property(REPORTPARAMETERNAMES_fld_ADDEDBYNAME) = "Supervisor" Then
                                .Process bbrep_ProcessOption_Preview
                            End If
                           
                            '... or you can process only selected reports based on the name
                            'If .Property(REPORTPARAMETERNAMES_fld_NAME) = "Balance Sheet by Fund" Then
                            '   .Process ReR_ProcessOption_Preview
                            'End If
                            .CloseDown
                        End With
                        Set oReport = Nothing
                    Next
                   
                    'Clean up the object references
                   
                    Set oReports = Nothing
     

Page 1 of 1 (1 items)