I been looking for a day now and I couldn't find a good source of information.
I have a one of a kind report wherein the RDLC file including all controls are programmatically generated (system generated) by one of my asp.net page. All fields and its values to be displayed on the RDLC file are coming a stored procedure. On my stored procedure I'm using a temp table for example #MyTable and its columns can adjust programmatically/automatically base on date range. BTW I'm using C# code to generate the RDLC file and preview it on the report viewer of a page.
Date Range: 01/01/2008 to 12/31/2009
My temp table may look like below
AssetCode, Description, Class, Jan2008, Feb2008, Mar2008 --> until column reach Dec2009
AAAA00001, AAAAAAA,FF, 0.00, 0.00,1,00.00 --> some month#### column may not or may contain value base on my formula.
AAAA00002, BBBBBBB,FF, 0.00, 1.00,1,00.00 --> some month#### column may not or may contain value base on my formula.
AAAA00003, CCCCCCC,CE, 1.00, 1.00,1,00.00 --> some month#### column may not or may contain value base on my formula.
I have no problem in retrieving all data on SQL Server using temp table and showing it on a system generated rdlc file even if I'm using Datasets.
My only problem is I can't programmatically sum all month#### columns and group all of it by Class.
Any idea or good reference I can use on how I can resolve my problem?
If I can make this work I assure that I will post a working sample on the internet to help other Dotnet developers.
Thanks in advance,