Recent content by adnil

Hi Charliy I have sorted this now. I created formula for each field as per your advise and I used the following to pull them together: stringvar x:=""; if not isnull({@tst_abc}) then x:=x+{@tst_abc}&', '; if not isnull({@tst_def}) then x:=x+{@tst_def}&', '; if not isnull({@tst_hij}) then...

Hi Charliy Thank you for your advise. I have tried and if only 1 of the fields is True, then @tst_all works fine. However, if 2 or more fields are True, @tst_all becomes blank. Thank you.

Hi, I have some fields (in the same table) with a True/False value and I need to get the field names appearing in a string only if their value is True, ie: ABC True DEF HIJ False XYZ True I need the above to appear in the report as: ABC, XYZ. How can I get this done please? We...

Hi SkipVought The reason why I am getting fever is because the report groups the data by the reason of the incident that has a start date that falls in between the selected date range. in the details section, the report will then show the name of the employee, the start date and end date of...

Hi all, We are using Crystal Xi and we have the following data: Employee name Start date End date Reason ABC 09/09/2010 11/09/2010 Fever ABC 01/05/2011 07/05/2011 Migraine XYZ 05/05/2011 05/07/2011 Depression We need the...

Hi, we are using Crystal XI and we have the following data: Employee name Start date End date Reason ABC 10/9/2010 12/9/2010 Fever ABC 15/9/2011 16/9/2011 Migraine DEF 10/10/2011 30/11/2011 Depression that needs to be...

Thank you Charliy Lin

We have the following fields in a table: Team name Year ID Figure ABC 2015 0 ABC 2014 160 ABC 2013 160 XYZ 2015...

Hi Pete Thank you for much for your suggestions. The 3 components are separated by carriage return. When I try your first suggestion, it did not work. However, your 2nd suggestion work perfectly. Thank you. Lin

Hi We have the following string: Learning Objective - To consolidate knowledge and understanding of electricity generation. Activity - Generation of electricity. Resources provided by company. Read, discuss then employee to complete set tasks. Evaluation - Objective achieved What we need is...

Hi all, {@datediff} DateDiff ("d",{@start date} ,{@end date} )+1 {@start date} if {NEW_BASE_TIME.START_DATE} >= {ROUTE_COST.START_DATE} and {NEW_BASE_TIME.START_DATE} in {?Start date} to {?End date}then {@term start date} else if {ROUTE_COST.START_DATE} >= {NEW_BASE_TIME.START_DATE} and...

Hi I have the below formula: WhilePrintingRecords; local stringvar marks:={NEW_BASE_TIME.TERM_TEXT}; local numbervar A; local stringvar display; local numbervar iloop; local numbervar startpos; local numbervar endpos; //start position of slice of string required if {NEW_BASE_TIME.START_DATE}...

Hi Dell and Charliy, thank you for your suggestions. I have got it sorted now. Lin

Hi CRY XI and DB. We have a string that consists of X, A and H. Each string has it's own start and end date and the length of the string varies. For example: XAAHHAAAAAHHHHHHHXAAAA How can I calculate the number of As in a defined start and end dates? So if the above string has a start...

I have to calculate the number of times character A appear in a string between 3 different date ranges. My data consists of contracts and each contract has string fields with a start and end date and each day contains a different character. Contract: 123 Contract start date: 3/9/2013...