Search results for query: *

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

Thanks for your help Tarwn! That's exactly what I needed.

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

Thanks for the advice rhinok! I'm going to look into these options. If anyone else knows other good options, please let me know! -marc

Sorry, I also forgot to explicitly state the I want the reports to be able to be distributed on the web (as with crystal enterprise).

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