Recent content by sofseattle

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)...

Any ideas please?

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...

worked like a charm, thanks so much!!!

Is there a way to do this as a distinct count? The sales order's may appear multiple times within a batch, so when I try this it is counting each individual sales order instead of distinct sales order numbers whileprintingrecords; numbervar cnt; cnt := cnt + 1

LOL I do tend to over think things sometimes I will give that a try Thanks

Sorry about that LB. I will try to be more clear on what I am trying to do.... I created the batch formula that creates the " batch " of 12 unique sales orders and that value is placed in a formula called batch. The batch formula can hold up to 10 unique batch numbers and anything else is...

Hey LB, Thanks so much, this got me pretty close but not quite there. I still see batch 2 and batch 3 on 1 page. I am trying to get it to page break by batch number. The orignal post was how to get it into the batches which I got figured out. I have attached a snipet of the preview page and...

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...

Screen shot of formula attached https://files.engineering.com/getfile.aspx?folder=c6dda3ce-713f-49b0-9b04-3e386ebcd1c0&file=crystal.PNG

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...