Print Page | Close Window

cross tab problem

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20780
Printed Date: 03 May 2024 at 10:15pm


Topic: cross tab problem
Posted By: Macavity
Subject: cross tab problem
Date Posted: 03 Jun 2014 at 1:35am
Hi,

I have a crosstab in which everything is correct except one item where the sum is counted double (only one record in the table)

any ideas ?

thanks


Replies:
Posted By: DBlank
Date Posted: 03 Jun 2014 at 1:46am
I would check your source data. either there is a duplicate row entered into it or for some reason a join is causing a duplicate row for only that record

Posted By: Macavity
Date Posted: 03 Jun 2014 at 4:12am
Checked every link, every table, only one record for that item

no suppresses, no formatting

it's a mystery

Posted By: DBlank
Date Posted: 03 Jun 2014 at 4:29am
are you grouping in the CT (either column or row)on a field that is setting two values together , say on a date field that is set to a day rather than a second?

Posted By: Macavity
Date Posted: 17 Jun 2014 at 4:09am
Originally posted by DBlank

are you grouping in the CT (either column or row)on a field that is setting two values together , say on a date field that is set to a day rather than a second?


no

Posted By: DBlank
Date Posted: 17 Jun 2014 at 10:31am
keep in mind that unless you set the join to enforced, you wont see the full data set until you use fields from each of the tables. once you use a field it enforces the join. So in the CT it will enforce a join. When you are checking the data set make sure that you look at it in an enforced way the same way the CT would be using the data.

Posted By: Macavity
Date Posted: 20 Jun 2014 at 2:52am
What do you mean with 'enforce' ?

the crosstab has one column {type}

two rows {leac} and {doc}

sum of {amount}

eg.                                  S01 {type}

101 {leac}  501 {doc}  100 =sum{amout}
                    502            200
                    total           300
102             601              100
                   602             100
                   total            300

the only one wrong is 502, sum of amount should be 100 instead of 200

On the next page detail lines are displayed and doc 502 has a total amount of 100. (as in the table)

                    


Print Page | Close Window