Unable to create Analytic report

[Varshi_Balaji]

Hi Team,

When we are trying to create the report we are getting the below error.

Even for basic query we are getting the above error - select u.username from users u where statuskey='0'

Can you please help us here

Regards,

Varshitha

[NM · Accepted solution]

@Varshi_Balaji you are creating a runtime report instead of that create a SQL based static report which should solve your problem.

[rushikeshvartak]

It seems you had select context as user . When context user is selected query needs mandatory columns

select u.username ,u.userkey as USERCONTEXT from users u where statuskey='0'