How do I add custom query-based fields to my report?

add custom fields query-based report click

Click Add New Field, enter a Field Name, select Type as Datasource, write your query (using $P for client-side parameters), and save.