Z
Zed
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 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.
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 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,
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 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.
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 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,
Zed