My requirement is to create a report so that I have stores listed down the left hand side and a few columns on the top row and I have traffic lights in the middle. The rows at the top will be calculated fields testing certain against a criteria such as weeks to start on site.
The first question is if this going to be a summary report, can I use a number of fields in the top row and does it have to be a variant of a drop down field. If not, is it possible to create a crosstab sort of report in the normal report.
My fields are based on a single table.
I have attached a sample of report. Will appreciate some insight.