Search results for query: *

Hi, When I add a simple calculation to a formula field in crystal 8.5 and also crystal XI it calculates the wrong result e.g. 8/9 = 89 instead of 88 I suspect it a rounding problem but I can’t resolve this. Can anybody help?

Hi, I am trying to create a query in crystal that will return a list of all records that does not have a bracket at the start of the field. The following query returns all records that do have a bracket at the starts {REGISTRATION.NARRATIVE} STARTSWITH '{' But can anybody tell me how to make...

Hi, I am new to SQL and have created the following trigger in MS SQL Express but can't get it to work in MYSQL 5.0 Can anybody tell me what is wrong it say the sytanx is wrong create trigger totalcost_c on contacts_cstm for insert,update as if update (hatcost_c) or update (shipping_c) begin...

I have a crystal report (version 8.5) that is summing an amount of money. e.g Mr Smith Amount Due Received to date Outstanding 100 50 50 200 175 25 300 225...

Hi, I need to export 136000 records into a CSV file. I have tried doing this using crystal but it says excel can only support 62000 records. Can anybody tell me how I can do this? Many Thanks

Hi Guys I new to SQL plus and was wondering if anybody can help with the following query? The following query returns the information needed SELECT SEARCH."SEARCH_NUMBER", SEARCH_TYPE."PLANNING_HISTORY" FROM "SEARCH" SEARCH, "SEARCH_TYPE" SEARCH_TYPE WHERE...

Hi, I have just started teaching myself SQL plus and was wondering how I can update multiple records (application numbers that I can define) E.g. update application_table Set closed ='Y' where application_number = '20008121' What I would like to do is to be able to define multiple application...

Hi, I’ve got the following scrip (SQL Plus) that works like a charm but I have noticed that is duplication some records. SET ECHO OFF set pagesize 0 set feedback off set heading on set validate off set termout off set trimspool on set markup HTML on spool c:\ApplicationInfo.HTML SELECT...

Hi Guys I am trying to search a memo file in Crystal XI I have tried the following formulas {Description} like “Brown” {Description} like “*Brown*” {Description} like “ * Brown * ” But get no results? I know there are records with this in the description? Can you help?

Hi I have the following query that publishes the results to a HTMl file. How can I make this not publish the query at the top of the HTMl file? Also every 14 rows it publishes table headings e./g Application Number, Application type Development address etc? How can I only make it publish...

Hi I have created a crystal report in crystal XI and copied and pasted the SQL query generated by crystal into SQL plus in oracle 9 SELECT PA_VIEW."APPLICATION_NUMBER", PA_VIEW."APPLICATION_TYPE", PA_VIEW."DEVELOPMENT_ADDRESS", PA_VIEW."DEVELOPMENT_DESCRIPTION", PA_VIEW."RECEIVED_DATE"...

Can anybody help me with the following Excel Formula? I have three columns Reference Received Closed EN990620 01/07/2003 16/07/2003 EN000344 01/07/2003 16/07/2003 EN000905 07/07/2003 30/07/2003 I want to create a formula that will count the number of reference numbers (Applications) that have...

I copied a formula for calculating the number of working days between to dates from the following website http://www.kenhamady.com/form01.html The main formula is as follows //Main formula WhileReadingRecords; Local DateVar Start := {PLANNING_APPLICATION.REGISTERED_DATE}; Local DateVar End :=...

Hi Guys, I need some help (Crystal 7.5 on an oracle database) I have created a report that lists the total number of applications received by an agent. When I first did this I realised it was displaying and counting duplicate applications, so I inserted another group (application Number) and...

Hello all, I am relatively new to crystal (8.0) and have the following problem. I have a created a report which displays the total number of Applications Received. Initially the information was duplicating so I grouped it by Application number and dragged the fields into the group footer...