Do all tables / commands used in a report ......
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=5235
Printed Date: 03 May 2025 at 4:31pm
Topic: Do all tables / commands used in a report ......
Posted By: AntDC
Subject: Do all tables / commands used in a report ......
Date Posted: 16 Jan 2009 at 1:04am
......Have to be linked?
I suspect yes, or Crystal could get confused.
I have taken over a report from someone else and I see they have multiple tables / command but are not all linked.
Surely they should be?
If not, how does Crystal know what is the main data to report on?
TIA
DC
|
Replies:
Posted By: DBlank
Date Posted: 16 Jan 2009 at 2:46pm
|
technically they do not have to be linked but it I think this is a rare process.
|
Posted By: hilfy
Date Posted: 20 Jan 2009 at 1:06pm
|
If there is a parameter that will select a specific record in an unlinked table, this can work - I've used this technique in several places. However, if that is not the case you end up with cartesian joins to the unlinked tables which can cause problems on the database as well as too much data to be selected.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
|