Sage 100 Reporting Object

SOLVED

Posted By Justin K over 4 years ago

I use this reporting object frequently to print custom reports from button scripts in Sage. Below is an example of the object being used.

Set report = CreateObject("Sage100ERP.Reporting.Report")

report.Load("C:\MYREPORT_custom.RPT")
report.PrinterName = "My Printer"
report.PrintToPrinter 1, 0, 0, 0, 0

Does anyone know if there is a method available that will let you know export the report (to PDF or otherwise)? I've used actual reporting objects in Sage (i.e. SO Printing) to export using methods like the below, but I believe these are completely different objects that the reporting object. Any help would be greatly appreciated!

soPrint.nReportType = 6

if not cbool(soPrint.nInitReportEngine()) then
MSGBOX("Init report engine: " + soPrint.sLastErrorMsg)
end if

if not cbool(soPrint.nSetExportOptions(5, file1)) then
MSGBOX("Set export options: " + soPrint.sLastErrorMsg)
end if

if not cbool(soPrint.nProcessReport("EXPORT")) then
MSGBOX CSTR("Process report: " + soPrint.sLastErrorMsg)
end if

Top Replies

Justin K over 4 years ago +1 verified

Found the answer in this post:

https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-personalization-customization-and-productivity-tools/37484/crystal-report-2011-no-longer-provides-runtime…

Parents

+1 Justin K over 4 years ago

verified answer

Found the answer in this post:

https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-personalization-customization-and-productivity-tools/37484/crystal-report-2011-no-longer-provides-runtime-component---can-t-create-runtime-object
Cancel
Vote Up +1 Vote Down

Sign in to reply

Reject Answer

Cancel

0 David Speck over 4 years ago in reply to Justin K

Justin, those answers look rather outdated,you may want to consider using one of the methods in my answers to these posts.

https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/131242/button-to-run-ap-aging-from-vendor/

https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/131553/error-attempting-to-open-crystal-reports-via-script

The former is for running a standard report off the menu that uses a selection grid, the latter is for running reports that have been added to the menu as CUSTOM reports.

The export options should be the same since it is going through crystal reports who's constants that set the export format appear to have remained the same.

Kent Mackall posted the following format types in this post.

https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/78293/export-report-using-boi

‘nSetExportOptions(nOuptutFormat, sOuputPath) is called to set the output format and path.  

'nOuputFormat is a numeric value and can be one of the following values/export types:

'  Ouput Format Values/Types

'  2 Rich Text

'  3 Microsoft Word

'  4 Microsoft Excel

'  5 PDF

'  9 Text

'  10 CSV

'  11 Tab Separated

'  12 Editable Rich Text

'  13 XML

'nOuputPath is the path where the file will be exported/created. This should be the full path and filename

EDIT: After a little more digging, i found the following table here.

EDIT: Had a reason to test some of these today and not every entry in the table below is accurate. Probably best to stick with the format types in the script example.

https://help.sap.com/doc/javadocs_bip_40/4.0/en-US/ras/en/constant-values.html#com.crystaldecisions.sdk.occa.report.exportoptions.ReportExportFormat._RTF

com.crystaldecisions.sdk.occa.report.exportoptions.ReportExportFormat
`public static final int`	`_characterSeparatedValues`	`8`
`public static final int`	`_crystalReports`	`0`
`public static final int`	`_editableRTF`	`10`
`public static final int`	`_HTML`	`4`
`public static final int`	`_MHTML`	`15`
`public static final int`	`_MSExcel`	`2`
`public static final int`	`_MSWord`	`1`
`public static final int`	`_paginatedTtx`	`14`
`public static final int`	`_paginatedTxt`	`13`
`public static final int`	`_PDF`	`5`
`public static final int`	`_recordToMSExcel`	`6`
`public static final int`	`_recordToMSExcel2007`	`16`
`public static final int`	`_reportDefinition`	`12`
`public static final int`	`_RPTR`	`17`
`public static final int`	`_RTF`	`3`
`public static final int`	`_tabSeparatedText`	`9`
`public static final int`	`_text`	`7`
`public static final int`	`_XML`	`11`

Reply

0 David Speck over 4 years ago in reply to Justin K

Justin, those answers look rather outdated,you may want to consider using one of the methods in my answers to these posts.

https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/131242/button-to-run-ap-aging-from-vendor/

https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/131553/error-attempting-to-open-crystal-reports-via-script

The former is for running a standard report off the menu that uses a selection grid, the latter is for running reports that have been added to the menu as CUSTOM reports.

The export options should be the same since it is going through crystal reports who's constants that set the export format appear to have remained the same.

Kent Mackall posted the following format types in this post.

https://www.sagecity.com/support_communities/sage100_erp/f/sage-100-business-object-interface/78293/export-report-using-boi

‘nSetExportOptions(nOuptutFormat, sOuputPath) is called to set the output format and path.  

'nOuputFormat is a numeric value and can be one of the following values/export types:

'  Ouput Format Values/Types

'  2 Rich Text

'  3 Microsoft Word

'  4 Microsoft Excel

'  5 PDF

'  9 Text

'  10 CSV

'  11 Tab Separated

'  12 Editable Rich Text

'  13 XML

'nOuputPath is the path where the file will be exported/created. This should be the full path and filename

EDIT: After a little more digging, i found the following table here.

EDIT: Had a reason to test some of these today and not every entry in the table below is accurate. Probably best to stick with the format types in the script example.

https://help.sap.com/doc/javadocs_bip_40/4.0/en-US/ras/en/constant-values.html#com.crystaldecisions.sdk.occa.report.exportoptions.ReportExportFormat._RTF

com.crystaldecisions.sdk.occa.report.exportoptions.ReportExportFormat
`public static final int`	`_characterSeparatedValues`	`8`
`public static final int`	`_crystalReports`	`0`
`public static final int`	`_editableRTF`	`10`
`public static final int`	`_HTML`	`4`
`public static final int`	`_MHTML`	`15`
`public static final int`	`_MSExcel`	`2`
`public static final int`	`_MSWord`	`1`
`public static final int`	`_paginatedTtx`	`14`
`public static final int`	`_paginatedTxt`	`13`
`public static final int`	`_PDF`	`5`
`public static final int`	`_recordToMSExcel`	`6`
`public static final int`	`_recordToMSExcel2007`	`16`
`public static final int`	`_reportDefinition`	`12`
`public static final int`	`_RPTR`	`17`
`public static final int`	`_RTF`	`3`
`public static final int`	`_tabSeparatedText`	`9`
`public static final int`	`_text`	`7`
`public static final int`	`_XML`	`11`

Children

0 Justin K over 4 years ago in reply to David Speck

Thanks so much for the links/info David.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 David Speck over 4 years ago in reply to Justin K

FYI, Had a reason to test some of format types in the table from SAP today and not every entry in the table is accurate. Probably best to stick with the format types in the script example.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

0 David Speck over 4 years ago in reply to David Speck

Another update. Below are the valid export options and recommended extensions. I couldn't decide which approached i liked more but both work if you find yourself having to change formats and want a legend for the available options.

aExportFormat_CrystalReports = 				Array(1, 	"rpt", 		"Crystal Reports (RPT)"					)
aExportFormat_MSWordRTF = 					Array(2, 	"rtf", 		"Microsoft Word (97-2003)"				)
aExportFormat_RTF = 						Array(3, 	"rtf", 		"Rich Text Format (RTF)"				)
aExportFormat_MSExcel = 					Array(4, 	"xls", 		"Microsoft Excel (97-2003)"				)
aExportFormat_PDF = 						Array(5, 	"pdf", 		"Portable Document Format"				)
aExportFormat_RecordToMSExcel = 			Array(8, 	"xls", 		"Microsoft Excel (97-2003) Data-only"	)
aExportFormat_Text = 						Array(9, 	"txt", 		"Text"									)
aExportFormat_CommaSeparatedText = 			Array(10, 	"csv", 		"Comma Separated Values"				)
aExportFormat_TabSeparatedText = 			Array(11, 	"ttx", 		"Tab Separated Values"					)
aExportFormat_EditableRTF = 				Array(12, 	"rtf", 		"Microsoft Word (97-2003) - Editable"	)
aExportFormat_XML = 						Array(13, 	"xml", 		"XML"									)
aExportFormat_RPTR = 						Array(14, 	"rpt", 		"Crystal Reports Read Only (RPTR)"		)
aExportFormat_RecordToMSExcelWorkbook = 	Array(15, 	"xlsx", 	"Microsoft Excel Workbook Data-only"	)

aExportFormat = aExportFormat_RecordToMSExcel ' Set to one of the nExportFormat_* variables from the above list.
oReport_Rpt.nSetExportOptions aExportFormat(0), sReportExportPath & "\" & sReportExportName & " (" & aExportFormat(0) & "=" & aExportFormat(2) & ")" & "." & aExportFormat(1)
oReport_Rpt.nExport False ' Use False to suppress export options dialogue.

Dim aReportExportOptions(13)
aReportExportOptions(1 ) = Array("Crystal Reports (RPT)"				, "rpt" , 1 )
aReportExportOptions(2 ) = Array("Crystal Reports Read Only (RPTR)"		, "rpt" , 14)
aReportExportOptions(3 ) = Array("Microsoft Excel (97-2003) Data-only"	, "xls" , 8 )
aReportExportOptions(4 ) = Array("Microsoft Excel (97-2003)"			, "xls" , 4 )
aReportExportOptions(5 ) = Array("Microsoft Excel Workbook Data-only"	, "xlsx", 15)
aReportExportOptions(6 ) = Array("Microsoft Word (97-2003) - Editable"	, "rtf" , 12)
aReportExportOptions(7 ) = Array("Microsoft Word (97-2003)"				, "rtf" , 2 )
aReportExportOptions(8 ) = Array("Portable Document Format"				, "pdf" , 5 )
aReportExportOptions(9 ) = Array("Rich Text Format (RTF)"				, "rtf" , 3 )
aReportExportOptions(10) = Array("Tab Separated Values"					, "ttx" , 11)
aReportExportOptions(11) = Array("Text"									, "txt" , 9 )
aReportExportOptions(12) = Array("XML"									, "xml" , 13)

nExportFormat = 5 ' Set to one of the aReportExportOptions array indexes from the above list.
oReport_Rpt.nSetExportOptions aReportExportOptions(nExportFormat)(2), sReportExportPath & "\" & sReportExportName & " (" & aReportExportOptions(nExportFormat)(2) & "=" & aReportExportOptions(nExportFormat)(0) & ")" & "." & aReportExportOptions(nExportFormat)(1)
oReport_Rpt.nExport False ' Use False to suppress export options dialogue.

Sage 100

Sage 100 Reporting Object

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING