Posted on: 9/12/2014 6:35:48 PM | Views : 374

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 ...