Search results for query: *

How do I decrypt?

I am receiving files from an external source which are zipped and encrypted. Is there a way to unzip them in unix? I tried unzip, but it said encrypted files are not supported.

The report is based on a single query which sums a value. It joins 2 tables, one of which contains all the categories that could possibly exist. The highest 'group by' field is category, and there are 4 other group by fields that follow it. Does this answer your question?

I have an Oracle report whose query is grouped by a category. Sometimes there is no data for a particular category, and I would like to print a page that says there is no data for that category, rather than not printing a page at all for that category. Is there any way to do that in Oracle...

How can I convert a database created in Access 2000 to one that I can open with Access 97?

I tried your suggestion, but I am still having the same problem. The button works the first time, but then the file name gets assigned to it, and it doesn't work again until I re-assign the correct macro name to the button.

I am using Excel 97. I have a macro called CopyMultFiles that ends with a SaveAs command like this one: ActiveWorkbook.SaveAs FileName:="ftp://someunixservername/dir1/dir2/dir3/dir4/somefilename", FileFormat:=xlTextPrinter The macro is assigned to a button which I have added to a...

I am running reports 6i, and I would like to take an existing report and view it through a web browser. When I test the report in oracle reports, it looks fine, but when I open it in a web browser, it gets squished to the left and the font appears to be much smaller. It prints like that also...

That's perfect! Thank you very much!

There are always 6 columns, A through F. There would be about 15 files, give or take a few, and I would want all of the data to end up in the same 6 columns of the master file, underneath each other.

I would like to combine multiple excel files into one worksheet using an automatic process in Excel 97. The number of rows in each file can vary, but the columns are always the same. I can create multiple sheets instead of multiple files, if that makes it any easier, but I need to end up with...

I am trying to record a macro in Excel. I am poplulating a worksheet with a variable number of rows from an external source, and I want to go to the next empty row to perform the next action. Is there a function in Excel that will get me there?

Is there a simple way to get the fields from one report onto another report? I need to merge 2 reports with a lot of data and pl/sql code behind the scenes. I didn't see a copy and paste function. Is there another way to handle this without re-typing everything?

I am using Oracle Reports 6i, and I am trying to SUM fields that are selected from a database. Although the fields are defined as VARCHAR2, they usually contain a number. I tried to convert the fields using to_number in the SELECT statement, but the report prints a box with an X in it, and the...