CUIC Reason code reports

[sarbarnes]

I am trying to create a report that shows reason codes as words, eg 1 =meeting etc

I have made what I believe to be the relavant changes, however whilst the Parameters check out ok, when i go to creat the fields, I get a syntax error.

if anyone can take a look at this and let me know here I am goiing wrong, I would be grateful.

please be advised, I haven't had any training on SQL, I am learning as i go!

[Gergely Szabo]

Hi,

well, a syntax error is a syntax error, you must have a typo or something like that.

Did you try running your SQL query against the database (using a client like SQL whatever Studio)?

G.

[sarbarnes]

Thanks for getting back to me, unfortunately I don't have the ability to check this through an SQL application.

Hence the question.:-)

I will go through the query again

Cheers Sarah

[Gergely Szabo]

Wow. Are you modifying SQL queries without trying them out first? Well, that's the spirit