Can anyone tell me why I get a number, currency, boolean, etc is required here… error when what I need to put there is a carriage return code for the sake of formatting… CHAR(13) is flagged - in a formula… Used this elsewhere in reports OK
{vrAttendance.PatientNumber} + ', ’ + CHAR(13) +
{Demographic.PostCode} + ', ’ + CHAR(13) +
{vrGUAccessPhase2and3.PCTName} + ', ’ +CHAR(13) +
{vrDiagnosis.Diagnosis} + ', ’ + CHAR(13) +
{vrAppointments.SessionName}
mikebird (BOB member since 2008-12-27)
I think when you start to concatenate things together that they all have to be the same data type. Because you are using a comma separator, that dictates that all of your values need to be string data types. From looking at your formula, I would guess that PatientNumber and PostCode could both be numeric data types. Try converting them to string data types and see if that works.
Well all was just fine before - all alphanumeric formats perfect, until I added the CHAR(13) part, which I’ve used before, just adding the return to line up the values…
Perhaps this has introduced something wrong to the parser…
mikebird (BOB member since 2008-12-27)
SO, IT SHOULD BE CHR(13)
mikebird (BOB member since 2008-12-27)