Reporting on User Type (i.e. Basic or Full)

[Richard Williams]

Hi, I'm trying to create a report that displays the account type which is "Basic" or "Full".

Does anyone know which table and field i need to reference in order to display the user Type?

Note: I have already tried including the field "h_sys_accounts-> h_user_type" in the report config but it comes up empty

[Lyonel]

Use the field "h_class"

3 = Basic

1 = Full

[Richard Williams]

Thanks Lyonel.

much appreciated