I am translating a group of reports from CR.8.0 to CR.NET.
Several use
... AND {STATUS.STATUS_DT} >= {?StartDt}
AND {STATUS.STATUS_DT} <= {?EndDt}
in the query.
In the CR8 version the query returns data from the day of EndDt. The CR.Net version returns only up to the day BEFORE; as if the...
I'm trying to reinstall the basic XP files to a SATA drive, but get this error: 0x0000000 (0x80000003,0x809F1575,0xF79C5840,0xF79C5540). I have done this several times witout problem. I have gotten the teh same message while trying to install a new SATA drive. The only reference I find to the...
I recently had a machine crash and wipe out my Oracle install. I have copies of the admin and oradata directories and was able to restore them. The example.dbf must be damaged. Startup goes as far as mounting, then errors when it tries to open.
ORA-01122 database file 5 failed verification...
I pretty much copied this straight from Ken H's FAQ:
BeforeReadingRecords;
DateVar Array Holidays := [
Date(2005,05,30),
Date(2005,07,4),
etc
];
It gives an error saying, "The result of a formula cannot be an array" on both CR8.0 and CR.Net. I'm using CR syntax.
Ideas?
Thanks
Bob Hagan
I created a stored procedure with a query containing a nested subselect:
SELECT C.CLIENT_NM, C.CLIENT_ID,
Max(decode(substr(s.STATUS,1,2),'N-', s.Status_dt, null)) "LastRefer_Dt",
Max(decode(substr(e.ENC_TYPE,1,4),'INIT', e.END_DT, null)) "LastInitVisit_Dt",
[COLOR=red] (select...
I've seen several questions about this that refer to a Crystal White paper. The example uses
TYPE REFCURSOR cursorblah RETURN basetable%ROWTYPE;
and then SELECTS * from that table.
I'm using Oracle 8i and CR.NET. I need to SELECT some fields from a parent table and then a set of dates from...
I have a report where my details section has so many elements it needs to display in landscape, but the summary must be in portrait to follow a pre-exisitng layout. Is this possible?
Bob Hagan
I have a group of reports I'm converting from CR 8.0 to web CR.NET. All the reports but one convert and run from my machine as localhost and when copied to our server. One report works on my machine, but gives an "invalid field name" error when run from the server.
This report is slow (15...
I'm trying to set up a Shuttle SB62G2 with an F62 motherboard. This has a SATA controller with an ICH5R chipset, and both an onboad Intel graphics chip and an added Asus GeoForce Fx5200 graphics card.
I'm using whatI think is FC1 from the book, "Linux for Non-Geeks". When I try to install from...
I have an exception report with a group header that looks for missing client information (SSN,DOB etc) and then in details, a set of status records (Referred, Opened, Transferred, Closed) that must be in this order.
I want to suppress all clients with no errors, but show all the records for...
I work for a group that's been using 8i and is converting a Windows/ASP app to ASP.NET. I tried running 8i on a new
Pentium4/XP machine at home. It died frequently so I downloaded 10g personal. Now the application, which worked when 8i did says, "can't load oci.dll".
How do I get this...
I'm trying to run an update from an ASP.net application, using the MS Oracle Provider. The stored procedure is generated from a CodeSmith template. I'm getting an Oracle error "Wrong number or type of parameters"
For test purposes I reduced the table to two fields, the primary key - client_id...
I installed Oracle 8.17 on a Pentium 4/WIN XP box following the instructions here. However, I can't keep it running. If I shut down the machine, the next time I try to restart DBA_Studio, etc., I get a no listener message.
The listener and the database services are on automatic and are...
I have a report where I need to select for and display running totals on a group level for Worker, Supervisor, Boro, and City. I thought that changing the group with a parameter was the ideal solution (otherwise I need to maintain multiple versions of the report). However the run goes from...
I have a report where I need to select for and display running totals on a group level for Worker, Supervisor, Boro, and City. I thought that changing the group with a parameter was the ideal solution (otherwise I need to maintain multiple versions of the report). However the run goes from...
I have a table that records contacts with clients. The filter is contacts for the last month. There are groupings by client, worker, supervisor, site and a total.
For each client I have one formula that records successful contacts and and one that records unsuccessful attempts. (There is...
I did a SQL Expression fn UCase({staff.staff_name})
and used it on an Oracle table:
{%staff_nm} startswith UPPERCASE(?staff_nm)
What's very strange is that it always fails the first time - whether using mixed, upper or lower case - and always works on any subsequent run of the report. If you...
We have some old reports where we added a parameter to search records by worker. The report is CR 8.0 and is used in a third-party application that calls the report viewer. the report works fine in Crystal, but when run in the application, the parameter dialog comes up only at the very end...
I'm trying to calculate clients' age ranges and then sum them.
CREATE VIEw V_FOODROLLUP (ENC_DT, ELDER) AS
SELECT e.enc_dt,
SUM(IIF (((current_date - c.CLI_BDATE)/365) > 65 ,1,0))
FROM encountr e, client c
wHERE c.client_id = e.client_id
GROUP BY e.enc_dt
I...
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.