cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
961
Views
0
Helpful
3
Replies

CUIC Reason code reports

sarbarnes
Level 4
Level 4

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!

3 Replies 3

Gergely Szabo
VIP Alumni
VIP Alumni

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.

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

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