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.
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...
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...
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 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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.