Programmatically Generated RDLC report


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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top