I've been given the task of converting a set of about 25 manually generated Excel reports into RS (2008R2).
A number of them have a (seemingly simple) pivot table layout that I'm finding especially frustrating to duplicate.
Here's an example where data is grouped by Division and then Dealer Name and the Dealer Name is positioned underneath the Division (which is essentially a placeholder with no data returned).
I can easily replicate the gist of the report by adding a row grouping that appears horizontally to the right of the Division, but I can't replicate the above format, with Dealer Name appearing underneath the Division but still grouped within it. The closest I have come is getting Dealer Name under Division, but all the Divisions appear on top first, with all the Dealers listed underneath and not within.
I'm pretty new to Reporting Services, so I'm wondering if there's something simple I'm missing here or whether this is just a case of non-translatable formatting between Excel and RS.
Any suggestions would be much appreciated.