Hello , I have to design a complex webreport with DevExpress Xtrareport .I have to pull data from 40 different tables on user selection and show on the Report. So I have designed in this way. On the design form I am giving the user to select the department section and project. with three dropdowns A) select the report , B) Sort by , C)Filter By
A) Select the report contains different types like family status, insurance type etc ..total 40 types.
B) Sort by will contain by employee number, date of birth , Salary , and many more
C) Filter by will contain like employee on vacation, or employee terminated etc etc.
Now for a single webreport I am first taking a DataSource and binding data to labels.
to achieve the above webreport I have to take 40 different Datasource and I have to assign to the labels? Should I be doing this?