I have created a Financial Report based on a query. My query includes the Entity Name, the Year, the Revenue, Gross Margin, and EBITDA. I have created a report from this query that is formatted like this:
Entity Name
Entity Name
Year Revenue Gross Margin EBITDA
2009 $$$$$$ $$$$$$ $$$$$$
2010 $$$$$$ $$$$$$ $$$$$$
2011 $$$$$$ $$$$$$ $$$$$$
2012 $$$$$$ $$$$$$ $$$$$$
However, I want it to look like this:
Entity Name
......................2009 2010 2011 2012 etc.
Revenue..........$$$$ $$$$$ $$$$ $$$$
Gross Margin.....$$$$ $$$$$ $$$$ $$$$
EBITDA.............$$$$ $$$$$ $$$$ $$$$
The SQL View of my query (which my report is based off of), contains this data:
SELECT tblEntity.EntityName, tblFinancial.Year, tblFinancial.Revenue, tblFinancial.GrossMargin, tblFinancial.EBITDA
FROM tblEntity INNER JOIN tblFinancial ON tblEntity.EntityID = tblFinancial.[EntityID]
ORDER BY tblEntity.EntityName, tblFinancial.Year;
How can I make the report look the way I want, with the year as column headings? Should I format the SQL View of my query in a different way? Thanks.
-Luke