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