Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

interesting problem

Status
Not open for further replies.
patty1

patty1

Programmer
Joined
Apr 17, 2002
Messages
105
Location
US
Does anyone know why a running sub-total changes if I hide the details section? If I show the details, the total is correct but if I supress or hide, it changes.

Any help appreciated.

Thx.
 
Sort by date Sort by votes
correction - not a running total just a subtotal based on a group.

sorry about that.
 
Upvote 0 Downvote
I have found that if I have "Select Distinct Records" selected, and fields within the Details section make a record distinct, that hiding that section may change the total number of records retrieved from the query.

You may want to either unselect the option for distinct records, or add criteria/fields to the report so that all the records you want to see are included in the report.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Mann2013
  • Locked
  • Question Question
Problem in using the Global Temp Table with Crystal report
Replies
0
Views
187
Mann2013
Mann2013
apeasecpc
  • Locked
  • Question Question
Crystal Reports Data Type Problem
Replies
2
Views
233
apeasecpc
apeasecpc
xcode1
  • Locked
  • Question Question
Arabic data problem in crystal report
Replies
0
Views
217
xcode1
xcode1
Daythril
  • Locked
  • Question Question
Problem with Report Built on Stored Procedure
Replies
3
Views
254
Daythril
Daythril
fhurmuzlu
  • Locked
  • Question Question
Database Problem
Replies
2
Views
198
hilfy
hilfy

Part and Inventory Search

Sponsor

Back
Top