Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: One Record, Multiple times Post Reply Post New Topic
Author Message
francisco
Newbie
Newbie
Avatar

Joined: 03 Feb 2011
Location: United States
Online Status: Offline
Posts: 3
Quote francisco Replybullet Topic: One Record, Multiple times
    Posted: 03 Feb 2011 at 11:17am
Hi everyone,
I have created a report that search for three different criteria. When runing the report, I am using (for testing purposes) the criteria that I know contains one record (an order with total units). The result in the report is the record I am looking for but it shows multiple times.
I should one get it once!
What am I doing wrong?
Can someone please help!
Francisco

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Feb 2011 at 11:39am
likely your table joins are multiplying your rows
IP IP Logged
francisco
Newbie
Newbie
Avatar

Joined: 03 Feb 2011
Location: United States
Online Status: Offline
Posts: 3
Quote francisco Replybullet Posted: 03 Feb 2011 at 11:50am
Is there a way that I can see this?
I have changed several ways that tables can be link together and every time I get the same results.
All the links are "equal Joins"
Any suggestions?

Francisco


IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Feb 2011 at 11:59am

You can see the joins in the database > databse Expert and Links tab.

Keep in mind Crystal does not "Enforce" a join unless you make enformced inteh set up or when you use a field from both tables in the join.
IP IP Logged
francisco
Newbie
Newbie
Avatar

Joined: 03 Feb 2011
Location: United States
Online Status: Offline
Posts: 3
Quote francisco Replybullet Posted: 08 Feb 2011 at 8:44am
I guess that what I mean to ask was the following:
Two tables: Order header and detail. To start, I am asking (Parameter Field) for Customer and Season. This work fine. Then I am adding a formula that multiply the price of each line times the total qty. That works fine. Now iwant to see the total of the entire order. I know there are 12 orders and I see 12 orders being displayed but each order is listed as many times as there are lines in the order. I just want one line per order and the total of that line.
Am I missing something?
My two tables (header and detail) are link Detail -> Header "equal join"
Thanks.
Francisco

IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 08 Feb 2011 at 8:50am

you can suppress rows based on a next() or previous() funtion.

Or group on a field (like order#) and suppres the details completely.
What I think you are ultimeately aiming at here is to also get totals at group and report levels. SUpressing rows only hide them and do NOT exclude them from totals.
YOu will have to use Running Totals with unique evaluation options to get to that if that is also part of your design.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.