Good Day,
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 programmaticall y 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 programmaticall y/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.
Sample:
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 programmaticall y 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,
Zed
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 programmaticall y 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 programmaticall y/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.
Sample:
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 programmaticall y 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,
Zed