Report Creation with multiple tables by user dynamically

Posted by Srinathgb under ASP.NET on 7/6/2013 | Points: 10 | Views : 1003 | Status : [Member] | Replies : 1
Dear Team

Can we have any customized report builder where we can drag and drop the table fields and do linking of multiple table without using standard tools like crystal reports etc.
where users should be able to build reports on their own.
For example: Input can be selection of 2 tables with linking (field) and selection of characteristic fields and numeric fields , in this some may have single values and few multiple
values to be placed in top or footer etc. should able to filter the field values.

I will be giving one master & one detail table names; common field; filter condition; list of fields to be displayed both characteristic & number.


eg:

Customer Name --------------------- From Date ----------- To Date --------------------------


----------------------------------------------------------------------------------------------------
Sno TDate Material Code Material Name Sales Qty Sales Amount
------------------------------------------------------------------------------------------------------
1
2
3
4
5
--------------------------------------------------------------------------------------------------------
Total Total Sales
---------------------------------------------------------------------------------------------------------

Assume all fields are available in database tables including Total Sales (Except Sno which is autogenerated)

Database Table Stucture:

CustomerSales:

CustomerCode;
tdate;
totalsales;

CustomerMaster;
CustomerCode
CustomerName

CustomerSalesDtl

CustomerCode
tdate
materialcode
qty
salesamount

Material:
MaterialCode
MaterialName

In this customer & material are master tables with primary key customercode & materialcode

Filter Condition: Input of From Date & To Date

Rgds
Srinath




Responses

Posted by: Raj.Trivedi on: 7/7/2013 [Member] [MVP] Starter | Points: 25

Up
0
Down
Hello Srinath,

Yes you can have the following achieved using RDLC Reporting

Use this article as resource :- http://www.dotnetfunda.com/articles/article2204-rdlc-reporting-in-windows-application.aspx


Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved

Srinathgb, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response