Search results for query: *

Dear All, Well there not really strange just not what I've seen before. I've come across a couple of formulas in some sample Crystal Reports and I'm just wondering what it is they are doing and what language they are referencing. Here is the first example, which I don't know what its doing...

Dear All, Sorry if this has already been answered, I've done a search and can't find anything. I've given a user view on demand permissions to a set of reports, what I don't want them to have is delete permissions. Is it possible remove restrict this option/button from there infoview window...

Think I've sorted it. Just needed to change the multiselect property of the listbox to simple or extended. Cheers

I'm doing something similiar but I am making selection, but it doesn't seem to register the selection. This is the code is below the if statement (If Me.List39.Selected(intCounter) = True) never seems to be true and therefore the strCriteria is not constructed correctly. For intCounter = 1 To...

GoStillers, If you down load SQL Developer (free) from here: http://www.oracle.com/technology/products/database/sql_developer/index.html Once installed do a check for update under Help option and and it should it should give you the option of installing some migration tools including 1 for...

Dear All, I've tried to use the formula in thread183-1148071 Changing the table and the fields of course select dateadd(d,convert(int,MCD2J) % 1000,convert(datetime, (convert(varchar,convert(int,MCD2J) /1000 + 1900) + '/1/1'))) From PS_TEST.TSDTA.F0006 I keep getting an error message of...

Thanks for the reply Ken, I figured it out, by having a look at some of the system dbms_scheduler jobs set up, you've got to enter the date for the start date as '08-AUG-06 11.15.00.000000000' I'm hoping that this equates to 11.15 am if not back to the drawing board. Once I get it working I...

Dear All, I'm trying to create the following job using dbms_scheduler begin dbms_scheduler.create_job( job_name => 'DEMO_JOB_SCHEDULE' job_type => 'PLSQL_BLOCK' job_action => 'declare x varchar2(1); begin select * into x from dual; dbms_output.put_line(x); end;' start_date => '08/08/2006...

h3nd, As you've logged into the database, I would think you'd know what database you were in Number of tables: select count(*) from all_tables; Name of tables: select table_name from all_tables Look at the data dictionary for a wealth of tables that provided database information. [afro]

replace WHERE H.DOCKET_NO = :DOCKET_NO1 with WHERE H.DOCKET_NO = DOCKET_NO1 if you really what to use bind variable then in sqlplus you need to put in something like variable DOCKET_NO1 NVARCHAR2(14) [press return] begin select '2005-001-00001' into :DOCKET_NO1 from dual; end; [type /...

tekkerguy, SQL Developer. 1) Free 2) From Oracle 3) Automatic Updates 4) Platform independant 5) Simple install - just unzip files to folder http://www.oracle.com/technology/products/database/sql_developer/index.html TheEntertainer [afro]

bmanning2, I to work with Crystal Reports XI and Oracle and my understanding is that for Crystal to read/see a recordset it has to be in a package. You need to search for a document called cr_oracle_stored_procedures.pdf on business object website. You should also look at this...

Hello, Thanks for your responses. I've now tried both an OLE and Oracle Server connection, the oracle server connection was based on a SP as well to see if that was quicker. I'm not scheduling the report, just running. The 600,000 being 10 mins makes sense as it takes around 15 mins to start...

Stefan, Thanks for that, I've been trying to figure it out and just couldn't. You'd think whoever wrote it would have tested it and then they would come up with the same error. Anyway it working now, it even returning data into Crystal. Just one question for anyone. This seems very...

Hello, I've not even got as far as crystal! I'm just trying to create a simple package with which to report off. This is what I've got so far: CREATE OR REPLACE PACKAGE Test_Package AS TYPE Test_Type IS REF CURSOR RETURN table%ROWTYPE; PROCEDURE Test_Procedure ( Test_Cursor IN OUT...

I've had a look and can't quite find an answer to this problem. I've got a report based on a query which does some complex number crunching on the database and the returns the records. It takes around 15 minutes to return, if you run it for data running back from August 2004 to today in Crystal...

Yeah, I saw that in another tread, but I'm fairly new with Enterprise and when I went to change the setting it said that the server had to re-boot and I chicken out until I'm sure that it will not affect anything else Thanks to you both for your help. Cheers

Hi, I've just installed raptor and I'm finding that it runs the same as in TOAD! Although I've not run anything complicated. I've found it useful in that we don't have full TOAD here and the free new version restricts number of row exported etc so I've been using an old, old version that...

Turkbear, Thanks for your response on this. I've followed your suggestion and I've managed to get the database to do most of the calculations. Reduced the number of records from 3 million plus to 19! (With 48 columns). BOXI is still timing out as the database has got to do some churning...

Thanks, For the replies. -k you are right in the sense that it is a recordset. If I explain what I'm after then you guys could probably point me in the right direction. I've got a report which contains around 18 months worth of data which produces 3 million plus records. The sql starts...