Search results for query: *

Hi, I need to create a report to show the amount my client is supposed to pay for vehicles provided to transport their staff. We have a table that holds contract details for the vehicle. 1) the contract has a start and end date and this is held in Contract.Start_Date and Contract.End_Date 2)...

You really are a super star LB[flowerface]! It has done the trick! After I made the changes as you have suggested, I viewed the result and it was just 1 long string. After a long while of trying to figure out what was wrong, I realised that I have not change the Text Interpretation to HTML...

Hi LB The raw data is as follows: <value type="simple" label="Service Reg Hist ID">7207</value><value type="simple" label="ServiceID">f30dba55-f45c</value><value type="simple" label="End Date">27/03/2017</value><value type="simple" label="Registration Type">AS Directory</value><value...

Hi LB <value type="simple" label="Application Type" /><value type="simple" label="Application Status" /> If there is no value in the particular heading, ie Application Type or Application Status, it will just be a blank space after the heading followed by a /. With your latest solution, I am...

Hi LB Thank you for your speedy reply. if there is no data, then it will be: <value type="simple" label="Application Type" /><value type="simple" label="Application Status" /> and the output will be just: Application Type Application Status Thank you. LG

Hi LB Sorry to bother you again. What should I do if I have the below: <value type="simple" label="Service Reg Hist ID">7486</value><value type="simple" label="Initial Contact Date">09/04/2018</value><value type="simple" label="Start Date">09/04/2018</value> and I would like it to appear as...

It worked! You're a super star LB [medal]! Thank you so much [thumbsup2]

Hi Ian I tried that and the y in the 7th line is still being highlighted with a message: An array is required here. Thank you. LG

Hi lbass Thank you so much for your reply. I replaced the {table.field} with my field, however the y in the 7th line is being highlighted and a message saying 'The ) is missing'. [sadeyes] Thank you. LG

Hi, we are using CR XI and our audit table holds old and new values that has been changed, deleted and added. We need to show which data has been changed/deleted/added under each heading. The data is stored as a long string and it looks something like this: <Value label="OpeningDate"><OldValue...