Print Page | Close Window

Main Report/Sub Report Problem

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5072
Printed Date: 06 May 2024 at 1:58pm


Topic: Main Report/Sub Report Problem
Posted By: Sanjeev
Subject: Main Report/Sub Report Problem
Date Posted: 22 Dec 2008 at 10:20pm
I have created one Main report with one detail and one Group and try to add sub report in grouping.
Because in main report every grouping changed data is coming from sub report.i have already created Shared variable with same name.
 
Problem -  report Performace is very slow every time when grouping field changed in mainreport and data is coming from sub report every try to Connect Data with Database (Accessing Database) .
 
Please help why every time try to connect or accessing database when group field is changed.
 
 
 
 
 
 


Replies:
Posted By: hilfy
Date Posted: 23 Dec 2008 at 2:15pm
This is one of the major drawbacks to using subreports - each time a subreport is called, it connects to the database a re-queries the data.
 
Is the subreport running in the details section or one of the group header or footer sections?
 
What are you doing that you specifically need a subreport for instead of formatting the data in the main report?
 
What type of database are you connecting to?  Are you using a native connection?  ODBC? OleDB?
 
In Crystal do you have "Use Indexes or Server for Speed" and "Perform Grouping on Server" turned on?  If not, can you? (Not all databases allow this.)
 
-Dell


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: Mak1984
Date Posted: 11 Oct 2010 at 12:18am
Hi any one tell me that how to get a running total of field in subreport from Main report .
 
Am having Two table , i want to sub total in main report  from where i am getting running total of Subreport .
 
but when i calculating a running total in subreport it shows right answer but in main report the sub total shows the last record value not a sub total of group.
 
please let me know how to solve the problem.


-------------
Be Your Dont Be Others


Print Page | Close Window