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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.