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 John Tel 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: *

  • Users: sugabutt
  • Content: Threads
  • Order by date
  1. sugabutt

    Scheduling a bunch of reports to run after one another

    I have about 50 reports in Crystal Reports Server (11.5) that I have individually scheduled to run, on the 1st day of the month. I'd like to put these in a group somehow where when 1 finishes running, the next one will start. I'm thinking it has something to do with an Event, but not sure how...
  2. sugabutt

    Trouble with UTC to EST/EDT time formula

    I have a database with a UTC date. I have converted it to GMT format (i.e. 4/12/2010 5:30:18PM). I'm using the following ShiftDate formula to convert the GMT to Eastern time. ShiftDateTime ({@dateutc}, "UTC,000,UTC", "EST,300,EDT") It works but it's not taking into account Daylight Saving...
  3. sugabutt

    What is the latest version?

    Which is the latest version of Crystal Reports - XI (11) or 2008?
  4. sugabutt

    Convert number in an array

    I have a field that is numeric that holds our fiscal year and period, but I want to convert it a month in it's word format, and skip the date, and display the year. Data example: 10901 is the period number for July 2008. We run our fiscal year from July to June. Today, for example, is August...
  5. sugabutt

    Convert number to a readable date

    I think I need to use an array for this, but I really am clueless on how to start it. I have a field called date, but it actually looks like this (just an example): 1090812. I want to display as August 12, 2009 on the report. How do I setup a formula to look at the 2nd and 3rd position for the...
  6. sugabutt

    Select on comparison of detail records?

    I need to be able to do a selection based on a comparison of the salesman number that re in 2 separate records, where the saleman number doesn't match. Currently I have the data grouped by customer number. And I'm selecting on Type (1 and 7). If the salesman number for these two records do...
  7. sugabutt

    Unmanaged Disk - setting up the job server defaults

    Hi, I'm in a mess... need your help please. Our CMC was setup with many reports being run on a schedule, and the PDF files were automatically saved to a network drive/folder. In each report, the destination was set to "unmanaged disk" and the 'save to job server defaults'. Everything was...

Part and Inventory Search

Back
Top