slow crystal report -visual studio 2005
Posted on 2011-02-16
I have created a crystal report with excel import, it works fine.
Now i need to switch my crystal report using stored procedure from the server.
it works fine with small set of data retrieve from stored procedure.
However, once the data is large, the crystal report viewer seems malfunction, export button, next, prev button always slow and seems talking to the stored procedure again everytime i hit it.
I know my stored procedure is complicated and slow, but i need to use it.