Hello. Here is my current setup:
Visual Studio 2013 Linking to a SQL Server 2012 table Working with the visual studio "Report Wizard" or report. (.rdlc file) Adding the Report to a ASPX using the Report Viewer Control Attaching a ObjectDataSource control with the Report Viewer Control to view my SQL data.
The table I am displaying has 6 columns. The column names are:
Level 1
Level 2
Level 3
Level 4
Level 5
Level 6
All the data represents is a Ragged Hierarchy in Flattened Table. Here is some sample data:
INCOME ---> SALES ---> SALES ---> SALES ---> SALES ---> (0045) Program Income
INCOME ---> SALES ---> SALES ---> SALES ---> SALES ---> (0036) Gift Income
INCOME ---> SALES ---> SALES ---> SALES ---> SALES - ...
Go to the complete details ...