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. rheard

    Conversions between UNIX time and normal time

    Looks OK to me... - Russ
  2. rheard

    Conversions between UNIX time and normal time

    Hi goduke, You may be able to adapt my formula to fit your timezone. begin_date - gets the year of your date field, then sets itself to 1st Jan on this year at 02:00am (UK clocks change at this time in Spring & Fall) work_date & DLSStart - combine to get the last Sunday in March (US use 2nd...
  3. rheard

    Conversions between UNIX time and normal time

    Umm, just thought - I should perhaps explain why we need to convert DLS times... Our data source (CA-USD) stores date/times in unix, but the browser app that allows the users to manage their incident/change tickets will 'helpfully' examine your pc clock to determine your timezone and convert the...
  4. rheard

    Conversions between UNIX time and normal time

    Just to make things more difficult... are you based in the UK? If so, we use the following code to allow for Daylight Savings Clock Changes in Spring/Autumn... local datetimevar rec_date := DateAdd("s",{table.datefield},DateTime(1970,01,01)); local datetimevar begin_date :=...
  5. rheard

    Manual Xtab conditional formatting not working

    Try - if {@Product Type} like "*MozzPS*" and totext(val({#FS MFF})) in "000" to "62.10" then crRed else if {@Product Type} like "*MozzPS*" and totext(val({#FS MFF})) in "63.81" to "1000" then crRed else CrWhite You need () around the object of the Val function, and move the final ) from...
  6. rheard

    Dates and Strings

    Try - if isnull({PEM_KC135_OPEN_ITEM_MVW.CURRENT_PROM_DATE}) then "No EDD Date" else totext({PEM_KC135_OPEN_ITEM_MVW.CURRENT_PROM_DATE}) The first part of your formula is trying to resolve to a string value, so the second part needs to as well - confused me for a while too! This will allow you...
  7. rheard

    Crystal Reports XI default template

    I found actually starting a report from scratch the hardest most time-consuming part, especially as reports required from our ticketing system generally require 7-8 tables. So one day, I just stripped the details from an old report, kept the Header/Footer, and saved it as a blank report...
  8. rheard

    Schedule Crystal Report in Business object Enterprise

    Choose the 'Monthly' option, then click the drop-down arrow where the Run option currently says 'on the nth day of the month' - this will give some more options, one of which is 'every n months'. Choose N = 3, then set the first run to be on the 1st of the next month.
  9. rheard

    exprot to editable rtf

    Also suffering from this 'feature' - anyone got any ideas? (apart from Export to PDF...) :-) Cheers, Russ
  10. rheard

    Scheduling Daily and Hourly

    I 'inherited' an Access app with a ton of complex VBA code which I found to be slow when running reports from our ticketing system. I modified the VBA to run the queries in Access creating temp tables with the results, then it creates dummy files that Crystal Events was looking for. The files...
  11. rheard

    Scheduling Daily and Hourly

    I'd be interested to find out how you do this... other than defining 10 daily schedules to run at each relevant hour.
  12. rheard

    BOXI Inventorying Report Objects

    OK - ready for a really convoluted solution? I found something similar to this a couple of years ago here on tektips, cant find it again so cant give a credit (sorry!). I've modified it slightly for my needs ie Report Name, Relevant Dates, Email Recipients... once you understand how it works you...
  13. rheard

    12-Month availability report

    Hi - unable to modify the db, but I'll try setting up an table or spreadsheet and use that as an additional datasource... Thanks
  14. rheard

    12-Month availability report

    OOPS - perhaps should have mentioned that the date in Grp3 is the downtime ticket open date set as a group, formatted into MMM-YY...
  15. rheard

    Locking the computer causes a "Not Supported" error

    I've seen both errors, but not put much thought into what caused them or why they occur. I know its annoying having to re-run the report... sorry not much help...
  16. rheard

    12-Month availability report

    Hi, report originally written in CR X now using CR X1; datasource is CA-Unicentre Service Desk. I have a report that shows, for the last 12 months,: {Grp1} - Client {Grp2} - Client Service {Grp3} - MMM-YY Total_mins_available_this_month Total_Mins_Downtime_per_month %age_Uptime_this_month...
  17. rheard

    FREE Photoshop E-Book (available until 13th June)

    Thanks for that, I'll have a look when I get home...
  18. rheard

    Storing and using variables

    Thanks Lbass, worked a treat (I still don't profess to understand it, but it works.. :-) ). Ian, thanks for your time as well, I've got something else in mind to try your solution on...
  19. rheard

    Storing and using variables

    Thanks guys, I'll try these later...
  20. rheard

    Storing and using variables

    Using Crystal X against CA-USD incident-logging database Each incident or 'call' (in a call-ref table) has a link to the 'actions' table, and each call will have multiple actions during its lifetime (open, transfer assignee, log comment, field update, close call, being the most simple of...

Part and Inventory Search

Back
Top