Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by sofseattle

  1. sofseattle

    Crystal formula for barcode display shows extra characters in date format?

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

    Formula to convert value to run time time field

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

    Conditional suppression weirdness

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

    How to create value/page break for distinct number of records

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

    How to create value/page break for distinct number of records

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

    How to create value/page break for distinct number of records

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

    How to create value/page break for distinct number of records

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

    How to create value/page break for distinct number of records

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

    Variable reset in a cross tab report

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

    Variable reset in a cross tab report

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

Part and Inventory Search

Back
Top