How to add a field in report?

[marianna]

Hi!
I'm trying to add field with a customer user firstname into my report. I found solution, but it didn't work for me.

1. I modified SQL statement in sub TicketGet by adding st.first_name
2. $Ticket{UserFirstname}=$Row[26]

and so on like in that topic.

I suppose something wrong with SQL statement. Maybe user name is in another table, not ticket?
Any suggestions?

P.S. Sorry my English

[marianna]

I also tried cu.{something} and this, but it didn't work too