Search results for query: *

Hi All, Crystal 2016 SP8 in use with SAP Business One. We have 2 date fields that we are converting to a barcode using the "*"+ (@date)+"*" format. The date field formula basically is just taking a date/time field from the database and converting to text in the proper date format(s)...

Hello, I am working with SAP Business One production orders and am trying to get report to display a "run time" field that is displayed as time: I have this formula to calculate the value and the result is a number. ( example 2.5) I now need to try and convert this into a field that shows the...

Hi All, This one has me stumped. I have a SAP Business one print layout that should work for 2 locations. For the Logo and for the company address, I have conditional suppression formulas that should show logo and address 1 if it is warehouse x and logo and address2 if it is warehouse Y. Here...

Is there a way to create a sectional page break based on the results of a formula? I would like to have a separate page each time the "batch" changes, but am not getting good results. I have a running total formula that counts the distinct # of sales orders and then assigns a value which I am...

Hi All, I have a cross tab report where we have a formula that displays a row count next to the customer in the cross tab object. The crosstab report is currently grouped by customer code. I need to figure out how to reset the row count on the change of the group. I tried creating variable...