How to handle multiple queries simultaneously in Crystal reports connecting from Business object Universe.
page 1 of 3
Published: 24 Jun 2009
Unedited - Community Contributed
Abstract
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.
by Umesh Bansal
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 22855/ 52
Article Contents:

Introduction

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.

 


View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 



Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2020 ASPAlliance.com  |  Page Processed at 2020-09-25 11:41:50 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search