How to handle multiple queries simultaneously in Crystal reports connecting from Business object Universe.
| Published on 6/25/2009 by Site Editor More articles in Web Development 
|
We have come across a situation where we have to generate the report from more then 2 queries using crystal reports. All queries are different -- 2 transaction tables with relevant joins from dimension tables. So to make the report we have to create 2 different connections from the universe and it eventually gave performance problems when dealing with a large sets of records. In this case, we have to link each query with the others on the basis of common dimensions. While fetching a report with a large amount of data, it takes a lot of time to complete. read more |
Latest Posts
- Building ASP.NET Web Forms to Use a MySQL Database
- A Guide to Upgrading Your XP Machine for Optimum Performance with Windows 7
- Retrieving Data from Microsoft SQL Server 2008 Using ASP.NET 3.5
- Creating an ASP.NET Dynamic Web Page Using MS SQL Server 2008 Database (GridView Display)
- Inserting Data into a Microsoft SQL 2008 Database in ASP.NET 3.5
- Design and Create Web Forms in ASP.NET
- Editing Web Design Layout in Visual Web Developer Express 2008
- Create ASP.NET Web Forms to Use a Microsoft Access Database
- Building an ASP.NET Website Using Include Tags
- Microsoft, NSF Open Cloud Computing to Scientists
- Encrypting Partitions with TrueCrypt
- Creating a Standard Encrypted Partition with TrueCrypt
- Encrypting Flash Drives with TrueCrypt
- Clocks and Countdowns
- Windows 7 Grabs One-Tenth of Market
- Building Reports using ASP.NET and Crystal Reports - Part 7 Using Subreports to Create Advanced Reports
- Search Engine Optimization (SEO) Toolkit
- Client Centric Approach of AJAX using Toolkit
- Silverlight - Creating Image Map with Hotspots
- VS 2010 Code Intellisense Improvements (VS 2010 and .NET 4.0 Series)
