This question is locked. New answers and comments are not allowed.
Hello there, I have to do a reporting feature for the application that I am currently working. For reporting I will use Crystal Reports that come with visual studio. Right now I am at the design stage and I don't know what path to choose in creating the reports:
1.The first path that comes in mind is creating a view or a stored procedure on the server and use Open Access to get it's result and sending it in a report.
2.Second path that comes in my mind is making another project called ReportingServices and from there call my current context do my logic and then create an output that will be send to the report.
The problem that arise is from the performance perspective. I don't have a lot of logic or calculation to be done, mainly some simple joins, and some aggregate functions. I am expecting a lot of records to have to be processed(an exact number I can not give you but, I am expecting over 100,000 ). I understand that the database has to be tuned also, but right no I am interested in the report.
What is the strategy that is recommended when using Open Access for reporting and how well does it behave from the performance perspective?
Thanks for any answers
LordRevan007
1.The first path that comes in mind is creating a view or a stored procedure on the server and use Open Access to get it's result and sending it in a report.
2.Second path that comes in my mind is making another project called ReportingServices and from there call my current context do my logic and then create an output that will be send to the report.
The problem that arise is from the performance perspective. I don't have a lot of logic or calculation to be done, mainly some simple joins, and some aggregate functions. I am expecting a lot of records to have to be processed(an exact number I can not give you but, I am expecting over 100,000 ). I understand that the database has to be tuned also, but right no I am interested in the report.
What is the strategy that is recommended when using Open Access for reporting and how well does it behave from the performance perspective?
Thanks for any answers
LordRevan007