Avatar of sweetbuttercup
sweetbuttercup

asked on 

Added Subreport to detail section but report is too slow

I have a report that shows a master record and need to show several line details form 2 different tables. If I use joins and groups then the data repeats. I added a subreport to show the details from table 2 while table one is the detail of master (group table) . Report takes long time to populate the subreport linked with invoice id (Subreport is a SQL command)  What can I do to make it faster?

sample
Master table invoce
Invoice 10001
details 1
details 2
details 3
details 4

Subreport Invoice 10001
service 1
service 2
service 3
Crystal ReportsDB Reporting Tools

Avatar of undefined
Last Comment
sweetbuttercup
ASKER CERTIFIED SOLUTION
Avatar of GJParker
GJParker
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of sweetbuttercup
sweetbuttercup

ASKER

The report is organized in 4 group levels. Is ther any way to suppress the detal level if G4 count > 1 then show it in the last record of G4?
Put it in the G4 footer.  It will show after the details is complete.

mlmcc
Avatar of sweetbuttercup

ASKER

I tried moving the sub report to the GF but it's still slow. I'm trying to get rid of the sub-report and use only Groups- joins. That's why i'm asking if there's any way to suppress the detal level if G4 count > 1 then show it in the last record of G4?
Yes.

Try using

Count({SomeField},{G4GroupField}) > 1

SomeField is a field that will have values if there are records like the primary key
G4GroupField - The field G4 uses for grouping

mlmcc
Avatar of sweetbuttercup

ASKER

No matter where I placed the sub report, the performance was affected so couldnlt use the sub report option. I added more table links to the same table (service) with alias to be able to show ll the results linked to line 1, line 2, line 3,... then created a formula to concatenate the results and show it.
Crystal Reports
Crystal Reports

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.

36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo