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!

Recent content by 1973kk

  1. 1973kk

    Rows for Months with No data

    the prob is i am trying to create a report which shows particular months salary by pay group along with year to date salary on same line. some times i have a group which is not paid for the month. some where i am going wrong with my report
  2. 1973kk

    Rows for Months with No data

    is there a way to do this without creating another table for dates. Thanks, Kavitha.
  3. 1973kk

    Sort String with Alpha and Numeric Values

    replace 64 with the maximum lenght of the field.
  4. 1973kk

    Sort String with Alpha and Numeric Values

    is you prob solved. if not u can just use this simple formula instaed. space(64-length({tab1.fld1}))&{tab1.fld1} where tab1.fld1 is ur fieldname. i use this for my sorting in reports which have alpha numeric values.
  5. 1973kk

    Supress page footer if sub report is blank

    did you check the options supress black subreport and supress black sections with in the subreport and the place where the subreports are placed
  6. 1973kk

    conditional help

    near the suppress section of the details or what ever place where u keep these values write a formula like this. if ucase(left({invoicefld},1)) <> 'X' and left({outvaluefld},1) <> '-' then true else false here i am assuming out value field is a string. if its not then write as below if...
  7. 1973kk

    How to add Horizontal page number in a crosstab

    for version 9 u can create fake page numbers. if u goto business obk=jects.com and type fake page number in search u will get the solution. they have it
  8. 1973kk

    Resetting manual counters on change of Group?

    create a fromula using shared variable. and get ur totals here. create another formula with same shared variable and reset it here
  9. 1973kk

    split field

    try the split formula Split (inputString, delimiter)
  10. 1973kk

    Using Between Criteria

    try this If ( Sum ({review_answer.score}, {review_answer.REVIEW_HEADERREF}) >= 21 and Sum ({review_answer.score}, {review_answer.REVIEW_HEADERREF}) <= 40 )then "C
  11. 1973kk

    Problem with Sub-columns in Cross tab report

    insert a cross tab as follows select dept for column Employee name for row salary and Rate for summary values and select summary type as mode. In the customize tab, from the summerized fields select horizontal
  12. 1973kk

    Extract numbers from a string

    The Val (str) function reads a string containing Numbers (example: an address, phone number, or social security number) and converts them to a decimal value. Val stops reading the string when it finds the first character in the string that it finds that it can not recognize as a number or as a...
  13. 1973kk

    Extract numbers from a string

    i tried the followingformula u gave if {Sheet1$.Reference} startswith "s" then tonumber(replace(mid({Sheet1$.Reference},3,len({Sheet1$.Reference})),"-","")) else if {Sheet1$.Reference} startswith "r" then tonumber(replace(mid({Sheet1$.Reference},6,len({Sheet1$.Reference})),"-","")) else 0 it...
  14. 1973kk

    Counting Distinct by a Group

    create a running total. email me the report if possible with saved data
  15. 1973kk

    Formula help

    why don't you do totext(formulaname, 0) and then compare
See more

Part and Inventory Search

Back
Top