SAP Business One SQL Prompt Variables /* SELECT FROM [dbo].[OSLP] T1 */ declare @slpName as varchar(155) /*WHERE*/ set @SlpName = /* T1.SlpName */ ‘[%0]’ /* SELECT FROM [dbo].[OCRD] T2 */ declare @CardCode as varchar(15) /* WHERE */ set @CardCode = /* T2.CardCode */ ‘[%1]’ SAP Business One HANA Prompt Variables /* select from [dbo].[OINV] T0 */ /* select from [dbo].[OSLP] T1 */ Declare FromDate timestamp; Declare ToDate timestamp; Declare SALESEMP char(155); SALESEMP := /* T1.”SlpName” */ ‘[%0]’; FromDate := /* T0.”DocDate” */ ‘[%1]’; ToDate := /* T0.”DocDate” */ ‘[%2]’; !! Remember to end your HANA SQL Script with a semicolon and replace the single and double quotes above which are enforced formatting !!
Tag: SAP Business One HANA
An SAP Business One Stock Report with All Items The following stock report will display all Items with or without quantities in Stock. select t0.ItemCode, t1.ItemName, isnull(t3.OnHandQty,0) as ‘In Stock’, t2.BinCode, t2.SL1Code, t2.SL2Code from OITW T0 inner join OITM t1 on t0.ItemCode = t1.ItemCode inner join OBIN t2 on t2.AbsEntry = T0.DftBinAbs left outer join OIBQ t3 on t0.ItemCode=t3.ItemCode and t0.WhsCode = t3.WhsCode where t2.BinCode between [%0] and [%1] order by t2.SL1Code, t2.SL2Code, t0.ItemCode
This is a short and to the point Crystal Reports post to assist anyone trying to count the number of Groups in a report. If you are using Crystal Reports you will know that the Summary does not work on Groups. We hope you find the following useful! Crystal Report Group Count To count the number of Crystal Report group entries in a report, rather than the entries within a Group, use the following process: 1) Create a formula @GroupCountReset and place this formula in the page header and make it suppressed (hidden) whileprintingrecords; numbervar i:=0; 2) Create another formula @GroupCountEval place this in the group header where you want to count the entries and suppress if required whileprintingrecords;…