▪ Sample2: Range:| will give all values between values entered in the variables. ▪ Sample1: Range:1|10 will give all values from 1 to 10 In order to specify such a value you can write Range:| or RangeSql: O Use this if you have a Crystal Parameter that require a range value (from/to (both inclusive)). O Use one of the 20 input variables((,, , … )) § Sample: SQL:SELECT DocEntry FROM OINV WHERE DocNum = $ O Use the SQL: syntax to execute your SQL where the result of the SQL will be passed along as the value. O This special keyword defined by SBO8.8 you the object-type of the document type O This special keyword defined by SBO8.8 will give you the DocEntry-field of all sales and purchase documents § Sample: $ to pass the document number on a Sales Order. For more information on the dynamic syntax, see the dynamic syntax guide O Use the common dynamic syntax ($ or $) to pass along data from the active window in SAP Business One. O Enter the special keyword $ to pass along a NULL value O You can enter any fixed value (123, abc and so on all depending on your report parameters value) O If you leave the value empty, the report at launch ask you for a value before showing the report
You have several options on how to pass along parameters Here you enter the value that you wish to send along to the report. Here the names of the parameters in the report is automatically drawn and shown switch to add mode and choose the type Crystal Report type. To do so, go to Administration > Add-ons > B1 Usability Package > Module Configurations > Universal Function > Universal Function Configuration. When your report is ready you will need to set the configuration to launch it. If you do not provide this information you will experience that each time you run the report it will ask for database login information. These information is entered in the B1 Usability Package Main configuration by navigating to Administration > Add-ons > B1 Usability Package > B1 Usability Configuration (Under the options tab). If that is the case, it is needed that you provide information about the database login. NB: BOYUM IT DOES NOT HANDLE SUPPORT ON CREATING THE CRYSTAL REPORT LAYOUT FILES.ĭepending on the crystal report that you have created, you might have set the report to connect to the SAP Database. In order to design reports to use with the functionality, you will need to have the Business Objects Crystal Reports designer (Not included with B1 Usability Package) where you design the report you which to launch With the Crystal Report Function type you are able to launch Crystal Reports which are an external Reporting program from Business Objects that are owned by SAP (For more information on crystal reports see ).
0 kommentar(er)
