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

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

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

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

Hello, Just a quick question, we've got Enterprise XI and I've just added sqlplus in as a program object is it possible to specify a script to run and send the output to a particular network drive? Oracle 9 client is installed on my machine, does it need to be installed on CE XI server? Thanks

Dear All, I apologise if this is covered elsewhere I've had a look and can't find the answer to this question. Can PL/SQL tables be generated containing data from multiple tables? I've got this simple script below: -- Declare the PL/SQL table type testarr is table of title%rowtype...

Dear All, I apologise if this question has been asked and answered elsewhere on this forum, I've tried to look but can't find anything that explains it (simply enough anyway!). After diming the appropriate objects : Sub luck() Dim application As CRAXDRT.application Dim report As...

Hello All, Does anyone know if there is a limited to the number of commandbuttons you can add to a Excel Userform? I ask this because in Excel 2000 using the the toolbox I've added 6 commandbuttons, If I add a 7th and then view code for the 7th, while it opens the module it doesn't insert your...

I'm using Access 2000 and Excel 2000. I have created 3 reports these are listing, sub-summary, summary reports, these filter on a couple of fields (class and year) and I've sent up a loop to produce the required report per class and year. What ideally I would like to do is as the report is...

Crystal 8.5, Oracle 7.3, RDC, odbc connection. VB form with a number of textboxes, after the report is selected each parameter name in the report is assigned to a text box on the form, so the user can see what that text box is for. The user puts in the information required and then it loops...

Hello, I've been reading various threads about Crystal Licensing and think just about follow them! But if someone could confirm my understanding, if a list what I intend to do. Basically I wish to develop a VB app which will use the CRAXDRT library, it will be based on V8 or V8.5. This app...

Hello, We produce reports for 10 different sites using the compile/distribute feature that was in V7 and which can be downloaded as an addin for V8 and V8.5. We use V8 for development of reports although most of the sites have dlls etc from V7, as we just identified the minimum dlls that were...

I've recorded and mangled the following VBA code and it works fine in Excel 97 querying a Oracle 7 database: Sub recon() Dim StartDate Dim EndDate Dim UserID As String Dim PassW As String Dim sACCOUNT As String sACCOUNT = InputBox("Enter Account") sBNKCOD =...

Hello All, Can I use/register the file crxf_pdf.dll in Crystal 8.0 and use it to export to PDF. I know this is available in version 8.5 and above, but I was wondering if I could just download the dll and use it with version 8 (or 7?). Thanks [afro]

I have a sql statement which I would like to alter into an Oracle Stored Procedure on an Oracle 7 database. Although I'm fairly good with sql and have worked in SQL Server prior to Oracle I can't get my head around how to construct Oracle SPs. I attach an example below basically I want to...

Hi, This probably is fairly simple. but I've got a userform which kicks off on the workbook open event on this is 2 labels into which the user enters their password and username. When they click a command button this is passed to a logon string. This works fine. But what I'm trying to do is...

Hello, Simple question, probably a simple answer! How can you tell which version of crystal you have i.e. Developers, Professional etc? Thanks [openup]

Hello All, We have created executable files stored on the server along with crf and rpt files the exe is then kick started using a excel macros attached to a button. However one or two users have recently report the above error message when they try to run certain reports. There doesn't seem...