Hi,
We are using Telerik Reporting and Telerik Openaccess in our project.
We plan to have a common stored procedrue that returns granular data. Teleik Openaccess is used to call the stored procedure.
This stored procedure normally returns about a million rows and upto 4 million rows in extreme cases.
On the frontend, we use crosstab control of telerik reporting to group data as per the requirement.
We will have about 20 different types of telerik reports and all will call this common stored procedure. However, each report will group data in a different way.
I would like to know the following
1. Can crosstabs of Telerik reporting can handle this data volume (1 miilion - 4 million records)
2. What is the maximum volume crosstabs can handle without degradation in performance.
3. Is the above approach the recommended approach? If not, what is Telerik's recommendation?
We are using Telerik Reporting and Telerik Openaccess in our project.
We plan to have a common stored procedrue that returns granular data. Teleik Openaccess is used to call the stored procedure.
This stored procedure normally returns about a million rows and upto 4 million rows in extreme cases.
On the frontend, we use crosstab control of telerik reporting to group data as per the requirement.
We will have about 20 different types of telerik reports and all will call this common stored procedure. However, each report will group data in a different way.
I would like to know the following
1. Can crosstabs of Telerik reporting can handle this data volume (1 miilion - 4 million records)
2. What is the maximum volume crosstabs can handle without degradation in performance.
3. Is the above approach the recommended approach? If not, what is Telerik's recommendation?