I have created a report based on a table which has information in it.
in the sql tab I wrote some custom SQL to get the result I want
checked the results tab
SELECT
tsw_clan_table.tsw_clan_name,
COUNT(tsw_member_table.tsw_clan)
FROM tsw_member_table
LEFT OUTER JOIN tsw_clan_table ON tsw_member_table.tsw_clan = tsw_clan_table.tsw_clan_id
GROUP BY tsw_member_table.tsw_clan
basically looks at the member table and counts the people in a specific clan result tab shows
clan name xx
clan name xx
clan name xx
where xx is the number of people in that clan
made sure that I selected both fields to appear in report
Build project, upload and when I look at the report
The two fields are on the report but only the Clan Name field has data so I am getting
clan name blank
clan name blank
clan name blank
I suspect I have tried to be too clever but open to suggestions
Thanks