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!

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

Search results for query: *

  1. DannyDutch

    How to suppress a repeating value?

    Hi lbass, You've solved the problem, I'm very happy!!!! Also thanks for the contribution from SV!
  2. DannyDutch

    How to suppress a repeating value?

    Hi lbass, This solution works great! Thanks for your help. Now I have the last question regarding the report: For some items I see i.e. 50 lines. I like to add a parameter which asks for the maximum nuber of lines (invoices). How can I include this in your formula? Thanks again.
  3. DannyDutch

    How to suppress a repeating value?

    Hi Synapsevampire, I understand that the first formula sets the price to zero. The second formula checks if the previous item is equal to the current item. the third formula will suppress the section if Price = {table.itemprice}. I've tried your solution but it goes wrong with the second...
  4. DannyDutch

    How to suppress a repeating value?

    Hi lbass, This is the actual formula: if Sum ({gbkmut.aantal}, {gbkmut.bkstnr})= 0 then 0 else Sum ({gbkmut.bdr_hfl}, {gbkmut.bkstnr})/Sum ({gbkmut.aantal}, {gbkmut.bkstnr})
  5. DannyDutch

    How to suppress a repeating value?

    Hi All, I'm using Crystal XI on a MS SQL 2000 database with an OLEDB connection. I'm reading a table with purchase invoices. I have create a formula named ITEMPRICE (amount/quantity) to divide the field 'amount' by the field 'quantity' to calculate the itemprice per item. The report is...
  6. DannyDutch

    How to group per half hour instead of per hour?

    Hi, If you select a datetime field, you can group on this field. Crystal comes up with the option to group a datetime field by year, month, hour, etc. We need to group the datetime field per HALF hour. Is there anybody who can help us? Thanx, Danny

Part and Inventory Search

Back
Top