471,349 Members | 1,309 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,349 software developers and data experts.

Programmatically Generated RDLC report

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

Jun 27 '08 #1
0 3910

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by Altman | last post: by
reply views Thread by =?Utf-8?B?a2VuIHM=?= | last post: by
reply views Thread by newkhan | last post: by
18 posts views Thread by =?Utf-8?B?SGVyYg==?= | last post: by
reply views Thread by =?Utf-8?B?RnJhbmsgVXJheQ==?= | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.