We
have come across in a situation where we have to generate the crystal report
from more then 2 queries using crystal reports designer. All queries contains different-2
transaction tables with relevant joins from dimension tables. So to make the
report, we have to create different-2 connections from the universe and it
eventually gave performance problem while dealing with larger sets of records.
In
this case, we have to link each query with other queries on the basis of common
dimension and while fetching the report for long range of data, it takes a lot
of time to complete.