Search results for query: *

Looks OK to me... - Russ

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

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

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 :=...

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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