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
- A look at SAP Crystal Reports for Visual Studio 2010
- Reporting in Threads
- Product Review - SocialBot V4.3
- Painting with ImageBrush, VideoBrush and WebBrowserBrush in Silverlight 4.0
- Assembly Coding within Visual C/C++ IDE
- Basic Operations and Registers in Assembly
- Generate Dynamic Title Tag based on QueryString in ASP.NET 3.5
- Visual Studio 2010 Productivity Power Tool Extensions
- jQuery Globalization Plugin from Microsoft
- Preview of MSDN Library Changes
- Crystal Reports Optional Table Linking and the Importance of Order
- Book Review - Murach C++ 2008
- Review - Blog Hatter
- Strategies for memory profiling
- Crystal Reports: 3 New Uses For Sub Reports
- Introduction to ComponentArt's TabStrip Control
- Using ASP.NET MVC 2 with Sharepoint Publishing
- Shared Layout, Style, Images and Javascript
- Using Crystal Reports and ASP.NET to Create Drill through Reports and Graphs
- ASP.NET 4.0 and the Entity Framework 4 - Part 5 - Using the GridView and the EntityDataSource
