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

    Formula to count and display to the Right

    Hi, Please help. I have a field {name}. In the {name} field is a city name and state in the following format: las vegas, nv I need a formula that will only display the city name, something like the Right function but to count the other way, four spaces to the right. Result should be: las...
  2. ronnutter

    Running total in a Cross Tab?

    Can a running total be placed in a cross tab? If no, any ideas for a work-around? thanks
  3. ronnutter

    Is there a contains function in Cry

    thanks for the responses: a KISS approach is to use like in the select expert. {bill_address.address} like "*glen*" for the above example. thanks,
  4. ronnutter

    Session Expire

    follow-up questions: Can you shorten the 20 minute automatic time-out for the standard enterprise? I would like to shorten it to like 3 minutes if possible. thanks,
  5. ronnutter

    Is there a contains function in Cry

    Is there a contains function in Crystal. I want to search on a string field that contains a certain phrase. ex. record1 - abc glen street, 23456 record2 - xyz glen street, 23457 record3 - glen 12457 st., 23456 i want the search to contain 'glen' so it will pull all three records. thanks,
  6. ronnutter

    Enterprise Date Paramater Formats

    I have published a crystal report onto enterprise and when a user goes into the report to change the date parameters, enterprise wants the date in a format like date[yyy,mmm,dd]. Is there an easier way for the users to enter dates, such as they would in crystal reports, using a calender...
  7. ronnutter

    Is TRACK-IT for CR deployment any good?

    Thanks, I understand what CR can and cannot do, but I am not familiar with what Track-It can do with CR. Does anyone use Track-It to view CR over the web? in need of guidance, Ron
  8. ronnutter

    Is TRACK-IT for CR deployment any good?

    My company just purchased Track-It ticketing software - Standard Version. I want to use the Track-It to deploy CR over the web. The reports are based on SQL so I will need to convince my company to upgrade to the Enterprise version, correct? Only standard can run reports based on Access...
  9. ronnutter

    Ends With search on numeric characters

    I'm searching on contract numbers on a report but there is no standard format how the contract numbers are entered. examples: 01-0230 010230 SC01-0230 Is there a way to only search for contract numbers that end with 0230? thanks, Ron
  10. ronnutter

    CountWorkingDays UFL Help

    Does anyone have a readme.txt file for the UFL: CountWorkingDays(startdate,enddate,bankHolidays) specifically, what value goes into the bankHoliday field. thanks
  11. ronnutter

    DateAdd Function Question

    yes, that is what i thought too. formula works barron, but i also need to subtract business days. also, sometimes the startdate may fall on a weekend, further suggestions appreciated
  12. ronnutter

    DateAdd Function Question

    i tried this formula: dateadd("w",5,{voyage_portcall.sail_date}) results should be a date that is 5 weekdays (business days) from the sail date, however the formula is adding 5 calender days. i need to add 5 business days to the sail date and i thought this formula would work...
  13. ronnutter

    DateAdd function only to add Business Days

    thanks Don, I went to the website but was unable to find the workday UFL you mentioned. Please list the file name. thanks for your help, Ron
  14. ronnutter

    DateAdd function only to add Business Days

    I've looked everywhere for this function. Is there a way to only add business days to a date? thanks, Ron
  15. ronnutter

    How to protect an RPT from being Modified after deployment

    Balves, I'm interested in giving reports to users but not having them able to modify them. Please explain a little further about making the reports as Read-Only. thanks, ron

Part and Inventory Search

Back
Top