I am importing a file into a microsoft access database that includes a unix timestamp which is in UTC (for example: 1066038603 = 10/13/2003 09:50). How can i convert this number into a date and time that can be recognized by microsoft access. Is there an access function that can convert this...
Here is my situation. I have dates for transactions that are stored in the db. These dates are in GMT (greenwich mean time) and i want to convert the dates to EST(eastern standard time) or EDT (easter daylight time) according to the date. If the date occurs in February, i want a query that...
Hi,
I'm trying to select mulitple records from an XMLType file. Here is my code:
SELECT
report_date,
EXTRACTVALUE(tr.trx_data , '/trx-report/body/line/external-id/text()') "External ID"
FROM
TRX_REPORT tr
The error i get is:
ORA-19025: EXTRACTVALUE returns value of only one node...
This worked great for my form that only displayed one record at a time. I also have a form that displays multiple records at a time. Where can I put this code so it will also work on this form for each record that is displayed? Thanks!
-marc
I have a text box on a form that I only want to be able to edit if a combo box has a certain value. Does anyone know how I can do this? Thanks for your help!
-marc
I've created a report that is an asp page that uses vbscript. It pulls data off of a database and displays it in a table. I want to be able to run the report once and then allow users to access the html output intead of continuously pulling the same data off of the database.
Is there a way...
I am wondering what other good software is out there that I can use as an alternative to Crystal Enterprise and/or Crystal Reports (i'm shopping around). I Need the software to be able to do the following:
-Automatically generate reports for set times at least once a day (pulling data from an...
Thanks, but that service pack actually just contains a patch for Crystal reports that i've already installed which fixes a different problem. I can export into excel 8.0 from crystal reports without any errors. I just can't export from crystal enterprise because the option isn't listed (i need...
Yes, I can open the 7.0 versions of the excel file, but the formatting is different than the 8.0 version. I need the specific formatting that occurs when the reports are exported as excel 8.0 files. Crystal Reports allows me to export in excel 8.0 format, but crystal enterprise doesn't give...
I need to be able to use crystal enterprise 8 to access excel versions of my reports. These reports must be in excel 8.0 format. Unfortunately, crystal enterprise 8 only gives the option to export to excel in 7.0 format. Does anyone know if and how I can export from Crystal Enterprise 8 in...
Thanks for the advice.
I actually just got it working. I was given some patches to install along with installing CE. It turns out that the patches (i don't know which ones yet) were causing the problem. I reinstalled CE without installing the patches and now it works fine. I guess when they...
I have recently installed Crystal Enterprise 8 and CANNOT view reports through Crystal Enterprise, but CAN view the reports through Crystal Reports 8.5. I have both installed on the same computer. I am connecting to an Oracle Database using an ODBC connection (system DSN).
When I try to view...
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.