Recent content by gsomerville

If uppercase(left({field},2))="IT" then mid({field},3) else {field}

We're in the process of upgrading from Info 7.5 to CE10 and have a similar problem. As DTaylor92 mentioned, it is a manual process. The method I've used is to copy the SQL from the crystal query into a SQL Command. In the DB Expert connect to the datasource as normal (eg using ODBC). The...

We had similar problems upgrading to 7.5. Try running the reports in design mode. If the reports run to completion then look at the formulas, as some of the functions perform differently (eg DTSDatetoTime). If you have migrated to a new server as well as upgrading, it's possible for the report...

You can display more than 255 characters by splitting the field in the SQL Procedure and returning 255 character "chunks". e.g. SELECT Table.Longstring FROM Table could be coded as: SELECT decode(truncate(length(Table.Longstring)/255)-10,-1,'', substr(Table.Longstring,2550,255))...

Hello, A stupid question, but are you sure you're connecting to the right APS? If so, when a report is deleted from the Info desktop, the entries in the CINFO database are removed. (CI_INFOOBJECTS for the report and (CI_RUNTIMEIMAGE) any scheduled results or recurring schedules. It certainly...

Hi Chris, Base the report on the crystal query and not the instance. When the SQL query is built it should have "Save data with report" disabled. If there are any instances the report will use the latest instance as the datasource. If you don't schedule the SQL query, the query will...

Hi Steve, Have you tried refreshing the recurring schedules by modifying and rescheduling them? The only report path I'm aware of is the CI_Filepath field in the CI_InfoObjects table, which is joined to the CI_RuntimeImage table on the CI_ID and CI_ReportID fields, with recurring schedules...

Hi, If a report is based on a crystal query or crystal dictionary, the datasource link of the report is to the specific file which contains the SQL query/dictionary. Copying the report to a new location and changing the report location in the APS does not change the source reference of the...

Hi, Dim CrAppl As CRAXDRT.Application Dim CrRep As CRAXDRT.Report <Set CrRep = CrAppl.OpenReport(file path as string) The problem is that you haven't created the CrAppl object yet. Regards, Gavin

A number of our systems run on Oracle 9i databases and I have connected to them without difficulty. The only problem I've encountered has been the use of the CLOB data type, which was unsupported by the old ODBC driver. (An Oracle and not an Info issue) It would be prudent to run a trial copy...

Hi MVisconte, I haven't come across this problem before but have a couple of comments which hopefully aren't too inane. From the description: &quot;SELECT CI_ID, CI_Name, ... etc FROM CI_INFOOBJECTS WHERE 0=1&quot; is a typical query within a report where the user wants to create a custom...

Hi, There is a way you can tackle this using formulae. Firstly, group the rows by the ticket number (if you haven't done so already). Place an initialise formula in the group header: {@Initialise} //Start Numbervar counter:=0; Stringvar ticket:=&quot;&quot;; //End In the detail section...

Hi Ksquared, According to Crystal Decisions, V9.0 is compatible with all previous versions (i.e. it registers and stores it's components outside of the system32 folder, so it doesn't interfere with the files of the older version) Regards, Gavin

Hi, Yes, you can. The report must be opened in Info Designer and saved to the APS. After entering the Logon details in the server page of the report properties (using Info Desktop), the report can then be scheduled. Please note that the report will fail if a data source is used where the APS...

Hi, It is possible to use the SQL UNION statement by creating a report in report designer and manually editing the SQL statement using the &quot;database show query&quot; option. Insert the line &quot;Where 1=0&quot; at the end of the query. Crystal will evaluate the first section of the SQL to...