We've implemented the use of the query governor on our SQL 2000 database for our Crystal report queries. The problem I'm having is trapping the returned error code, before crystal displays an unfriendly .dll error message. When I run a report in designer which is killed by the governor, I get a...
Does anyone know of a way to "schedule" an un-managed report? Most of our reports are not run from within CE but via a URL command. Several of them have queries that will take longer than 1 minute to run as users can be pulling data across multiple years. We've been expirencing this...
In the format font section for the fields you want highlighted red, add code similar to the following:
if IsNull(Who_Acknowl) then
Color (255,0,0)
else
Color (0,0,0)
You may also need to check for Who_Acknowl = ''.
Are you trying to get the earliest or the most recent date? Your statement "where their max effective dates are earlier" indicates you want the earliest date, not the most recent. If that's the case, you need to look for the minimum date, not the maximum. Same code, just change the...
skulman is right on track here. What you need to determine is where is the report being executed from, your workstation or a server. If the execution happens on a server, then the SQLSVR.err file will be on that box. This may be why your not seeing it on your workstation.
Once you locate the...
One thing I forgot to mention, if the table contains records with identical effective dates (no time stamps) and the Like clause is going to return more than one value, this code will not work. The sub-select has to return a single value from the table.
If I'm reading your question correctly, I believe the code below should work...
SELECT
PS_ADDRESSES."EMPLID", PS_ADDRESSES."EFFDT"
FROM
"SYSADM"."PS_ADDRESSES" PS_ADDRESSES
WHERE
PS_ADDRESSES."EMPLID" LIKE '______002' AND...
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.