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 Rhinorhino 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 ARRao

  1. ARRao

    List the group and their group total in the report footer

    It works!!! Thank you very much. ARRao
  2. ARRao

    List the group and their group total in the report footer

    I have a report that has Client Names as a group with a group total on their purchase values. I want to list all the Clients and their respective purchase totals in the Report footer. Is this possible? thanks.
  3. ARRao

    Sorting of a currency field incorrect when values are negative

    Thank you all!!
  4. ARRao

    Sorting of a currency field incorrect when values are negative

    That worked beautifully. Thank you!!!! [thumbsup2]
  5. ARRao

    Sorting of a currency field incorrect when values are negative

    Thank you, but I still get the error. I do display the {sp_spname;1.FieldName} in the report and they show up as currencies. The negatives show up as ($180.33) etc. When i strip the function and place val(toText({sp_spname;1.FieldName})) in another formula, i get the same error.
  6. ARRao

    Sorting of a currency field incorrect when values are negative

    Tried the last code posted. Still get the Division By Zero error.
  7. ARRao

    Sorting of a currency field incorrect when values are negative

    I am currently not handling nulls but they show up as 0.00 in the report. You think that could be the problem? If so, I can convert all the nulls to 0 within my stored proc.
  8. ARRao

    Sorting of a currency field incorrect when values are negative

    Thanks for the suggestion but the abs function requires a number. {sp_spname;1.FieldName} is of Currency Data type.
  9. ARRao

    Sorting of a currency field incorrect when values are negative

    I have a parameter @SortField that allows users to pick the field they want to sort on. The fields could be of a string, number,date or currency data type. The sort works perfectly fine for all datatypes except for currency. I have gone through the post by vshapiro but that did not help...
See more

Part and Inventory Search

Back
Top