Click here to Skip to main content
14,272,143 members
Rate this:
Please Sign up or sign in to vote.
See more:
Need help in designing following report in SSRS, where I have a chart report with 2 category grouping fields and 1 series group field.

Below are my queries
1. how to show my category grouping values on top of chart (showing group in different color) and series grouping values on bottom of chart (under each column)
2. I need to show trend line over each series group data.

For example, First category group is over hotel name, second category group is over room type (deluxe, executive & suite) and one Series group over week number (for a month report), and the chart value is total occupancy (per hotel per room type per week number). Now for point 1, Hotel name and room type needs to be on top of the column (total occupancy) chart, where a week iteration number (1,2,3,4 for a month) at the bottom of the chart under every column.
And for point 2, I need to show trend line per room per week occupancy was improved or not.

Updated 22-Jan-15 23:24pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100