I currently have no reports in my database. When I try to create a pivot table report based on a particular view, the fields (in the left-hand panel) are called Column 1, Column 2, Column 3, instead of the actual column names. When I proceed with the report anyway, I get useless results - a pivot table with one cell.
Why does the report generator not connect up with the view correctly?