Records disappearing Data/Preview tabs.

On "Data" tab I run the data. 3 records are returned. i.e.
Part# 12345 Philadelphia PA Qty 60
Part# 11223 Philadelphia PA Qty 100
Part# 11223 Bronx NY Qty 500
On "Preview" tab I see the following:
Part# 12345 Philadelphia PA 60
Part# 11223 Philadelphia PA 100
Customer break SUM 660
So, I loose the 3rd record in the detail section of the report
yet the totals sum up all 3 records.
I realize the 2nd & 3rd records have the same Part#.
None of the textboxes have "Hide Duplicates" checked off.
Can somebody explain to me what's happening?You arent grouping it by the Part# are you?
"BillB" <BillB@.discussions.microsoft.com> wrote in message
news:F9A6FA80-4F67-40D6-B9A8-1A9196B83CA4@.microsoft.com...
> On "Data" tab I run the data. 3 records are returned. i.e.
> Part# 12345 Philadelphia PA Qty 60
> Part# 11223 Philadelphia PA Qty 100
> Part# 11223 Bronx NY Qty 500
> On "Preview" tab I see the following:
> Part# 12345 Philadelphia PA 60
> Part# 11223 Philadelphia PA 100
>
> Customer break SUM 660
> So, I loose the 3rd record in the detail section of the report
> yet the totals sum up all 3 records.
> I realize the 2nd & 3rd records have the same Part#.
> None of the textboxes have "Hide Duplicates" checked off.
> Can somebody explain to me what's happening?
>|||Thanks for the reply.
Yes I am grouping it by the part #
the detail line is in a list and the customer total is an another list.
I'd expect it to total the Qty's on the detail line for the two records
with the identical Part#'s.
so part # 11223 would show 600 on the detail line not 100!
"Ben Watts" wrote:
> You arent grouping it by the Part# are you?
> "BillB" <BillB@.discussions.microsoft.com> wrote in message
> news:F9A6FA80-4F67-40D6-B9A8-1A9196B83CA4@.microsoft.com...
> > On "Data" tab I run the data. 3 records are returned. i.e.
> >
> > Part# 12345 Philadelphia PA Qty 60
> > Part# 11223 Philadelphia PA Qty 100
> > Part# 11223 Bronx NY Qty 500
> >
> > On "Preview" tab I see the following:
> >
> > Part# 12345 Philadelphia PA 60
> > Part# 11223 Philadelphia PA 100
> >
> >
> > Customer break SUM 660
> >
> > So, I loose the 3rd record in the detail section of the report
> > yet the totals sum up all 3 records.
> >
> > I realize the 2nd & 3rd records have the same Part#.
> >
> > None of the textboxes have "Hide Duplicates" checked off.
> >
> > Can somebody explain to me what's happening?
> >
> >
>
>|||I may be understanding it wrong, but it sounds like it is only showing one
because of the group. It will still total everything it finds because of
the detail, but if you are showing your group then it will only bring back
one record. Are you showing any detail in the group. Or is it all showing
in the details?
"BillB" <BillB@.discussions.microsoft.com> wrote in message
news:A43A1A2D-2F40-4B17-A01D-D4E289428D6A@.microsoft.com...
> Thanks for the reply.
> Yes I am grouping it by the part #
> the detail line is in a list and the customer total is an another list.
> I'd expect it to total the Qty's on the detail line for the two records
> with the identical Part#'s.
> so part # 11223 would show 600 on the detail line not 100!
> "Ben Watts" wrote:
>> You arent grouping it by the Part# are you?
>> "BillB" <BillB@.discussions.microsoft.com> wrote in message
>> news:F9A6FA80-4F67-40D6-B9A8-1A9196B83CA4@.microsoft.com...
>> > On "Data" tab I run the data. 3 records are returned. i.e.
>> >
>> > Part# 12345 Philadelphia PA Qty 60
>> > Part# 11223 Philadelphia PA Qty 100
>> > Part# 11223 Bronx NY Qty 500
>> >
>> > On "Preview" tab I see the following:
>> >
>> > Part# 12345 Philadelphia PA 60
>> > Part# 11223 Philadelphia PA 100
>> >
>> >
>> > Customer break SUM 660
>> >
>> > So, I loose the 3rd record in the detail section of the report
>> > yet the totals sum up all 3 records.
>> >
>> > I realize the 2nd & 3rd records have the same Part#.
>> >
>> > None of the textboxes have "Hide Duplicates" checked off.
>> >
>> > Can somebody explain to me what's happening?
>> >
>> >
>>|||Hi Ben
In the detail list I show
part# 12345 Qty= 60 this is correct
part#11223 Qty is showing 100 which is not correct.
remember the 2nd record is part # 11223 with qty = 100
the third record does not show in the detail at all but the 3rd
record
has a qty of 500.
so i should see in the detail:
Part # 11223 qty=600 because it should combine the 2nd record of 100 &
the 3rd record with the same Part# of 500.
the customer total shows correctly qty 660.
hope this makes it clearer & thanks fro the help.
"Ben Watts" wrote:
> I may be understanding it wrong, but it sounds like it is only showing one
> because of the group. It will still total everything it finds because of
> the detail, but if you are showing your group then it will only bring back
> one record. Are you showing any detail in the group. Or is it all showing
> in the details?
> "BillB" <BillB@.discussions.microsoft.com> wrote in message
> news:A43A1A2D-2F40-4B17-A01D-D4E289428D6A@.microsoft.com...
> > Thanks for the reply.
> > Yes I am grouping it by the part #
> > the detail line is in a list and the customer total is an another list.
> > I'd expect it to total the Qty's on the detail line for the two records
> > with the identical Part#'s.
> > so part # 11223 would show 600 on the detail line not 100!
> >
> > "Ben Watts" wrote:
> >
> >> You arent grouping it by the Part# are you?
> >>
> >> "BillB" <BillB@.discussions.microsoft.com> wrote in message
> >> news:F9A6FA80-4F67-40D6-B9A8-1A9196B83CA4@.microsoft.com...
> >> > On "Data" tab I run the data. 3 records are returned. i.e.
> >> >
> >> > Part# 12345 Philadelphia PA Qty 60
> >> > Part# 11223 Philadelphia PA Qty 100
> >> > Part# 11223 Bronx NY Qty 500
> >> >
> >> > On "Preview" tab I see the following:
> >> >
> >> > Part# 12345 Philadelphia PA 60
> >> > Part# 11223 Philadelphia PA 100
> >> >
> >> >
> >> > Customer break SUM 660
> >> >
> >> > So, I loose the 3rd record in the detail section of the report
> >> > yet the totals sum up all 3 records.
> >> >
> >> > I realize the 2nd & 3rd records have the same Part#.
> >> >
> >> > None of the textboxes have "Hide Duplicates" checked off.
> >> >
> >> > Can somebody explain to me what's happening?
> >> >
> >> >
> >>
> >>
> >>
>
>|||Go to your detail line and right click on the three lines.then click edit
group. Even in the detail you can group it and it will hide records. Make
sure there is nothing in "Group On" Expression. I am betting you have
something in that. If so just delete it and leave it blank. I just
recreated that with one of my own reports and when I put something in the
"group on" in the details line it hid alot of records.
"BillB" <BillB@.discussions.microsoft.com> wrote in message
news:A3A0CAAD-7B02-4E76-A03A-802C0D3A34EF@.microsoft.com...
> Hi Ben
> In the detail list I show
> part# 12345 Qty= 60 this is correct
> part#11223 Qty is showing 100 which is not correct.
> remember the 2nd record is part # 11223 with qty = 100
> the third record does not show in the detail at all but the 3rd
> record
> has a qty of 500.
> so i should see in the detail:
> Part # 11223 qty=600 because it should combine the 2nd record of 100 &
> the 3rd record with the same Part# of 500.
> the customer total shows correctly qty 660.
> hope this makes it clearer & thanks fro the help.
> "Ben Watts" wrote:
>> I may be understanding it wrong, but it sounds like it is only showing
>> one
>> because of the group. It will still total everything it finds because of
>> the detail, but if you are showing your group then it will only bring
>> back
>> one record. Are you showing any detail in the group. Or is it all
>> showing
>> in the details?
>> "BillB" <BillB@.discussions.microsoft.com> wrote in message
>> news:A43A1A2D-2F40-4B17-A01D-D4E289428D6A@.microsoft.com...
>> > Thanks for the reply.
>> > Yes I am grouping it by the part #
>> > the detail line is in a list and the customer total is an another list.
>> > I'd expect it to total the Qty's on the detail line for the two records
>> > with the identical Part#'s.
>> > so part # 11223 would show 600 on the detail line not 100!
>> >
>> > "Ben Watts" wrote:
>> >
>> >> You arent grouping it by the Part# are you?
>> >>
>> >> "BillB" <BillB@.discussions.microsoft.com> wrote in message
>> >> news:F9A6FA80-4F67-40D6-B9A8-1A9196B83CA4@.microsoft.com...
>> >> > On "Data" tab I run the data. 3 records are returned. i.e.
>> >> >
>> >> > Part# 12345 Philadelphia PA Qty 60
>> >> > Part# 11223 Philadelphia PA Qty 100
>> >> > Part# 11223 Bronx NY Qty 500
>> >> >
>> >> > On "Preview" tab I see the following:
>> >> >
>> >> > Part# 12345 Philadelphia PA 60
>> >> > Part# 11223 Philadelphia PA 100
>> >> >
>> >> >
>> >> > Customer break SUM 660
>> >> >
>> >> > So, I loose the 3rd record in the detail section of the report
>> >> > yet the totals sum up all 3 records.
>> >> >
>> >> > I realize the 2nd & 3rd records have the same Part#.
>> >> >
>> >> > None of the textboxes have "Hide Duplicates" checked off.
>> >> >
>> >> > Can somebody explain to me what's happening?
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||Hi Ben
That's it . Thanks for all the help and sticking with me!
"Ben Watts" wrote:
> Go to your detail line and right click on the three lines.then click edit
> group. Even in the detail you can group it and it will hide records. Make
> sure there is nothing in "Group On" Expression. I am betting you have
> something in that. If so just delete it and leave it blank. I just
> recreated that with one of my own reports and when I put something in the
> "group on" in the details line it hid alot of records.
> "BillB" <BillB@.discussions.microsoft.com> wrote in message
> news:A3A0CAAD-7B02-4E76-A03A-802C0D3A34EF@.microsoft.com...
> > Hi Ben
> > In the detail list I show
> > part# 12345 Qty= 60 this is correct
> > part#11223 Qty is showing 100 which is not correct.
> > remember the 2nd record is part # 11223 with qty = 100
> > the third record does not show in the detail at all but the 3rd
> > record
> > has a qty of 500.
> >
> > so i should see in the detail:
> > Part # 11223 qty=600 because it should combine the 2nd record of 100 &
> > the 3rd record with the same Part# of 500.
> >
> > the customer total shows correctly qty 660.
> > hope this makes it clearer & thanks fro the help.
> >
> > "Ben Watts" wrote:
> >
> >> I may be understanding it wrong, but it sounds like it is only showing
> >> one
> >> because of the group. It will still total everything it finds because of
> >> the detail, but if you are showing your group then it will only bring
> >> back
> >> one record. Are you showing any detail in the group. Or is it all
> >> showing
> >> in the details?
> >>
> >> "BillB" <BillB@.discussions.microsoft.com> wrote in message
> >> news:A43A1A2D-2F40-4B17-A01D-D4E289428D6A@.microsoft.com...
> >> > Thanks for the reply.
> >> > Yes I am grouping it by the part #
> >> > the detail line is in a list and the customer total is an another list.
> >> > I'd expect it to total the Qty's on the detail line for the two records
> >> > with the identical Part#'s.
> >> > so part # 11223 would show 600 on the detail line not 100!
> >> >
> >> > "Ben Watts" wrote:
> >> >
> >> >> You arent grouping it by the Part# are you?
> >> >>
> >> >> "BillB" <BillB@.discussions.microsoft.com> wrote in message
> >> >> news:F9A6FA80-4F67-40D6-B9A8-1A9196B83CA4@.microsoft.com...
> >> >> > On "Data" tab I run the data. 3 records are returned. i.e.
> >> >> >
> >> >> > Part# 12345 Philadelphia PA Qty 60
> >> >> > Part# 11223 Philadelphia PA Qty 100
> >> >> > Part# 11223 Bronx NY Qty 500
> >> >> >
> >> >> > On "Preview" tab I see the following:
> >> >> >
> >> >> > Part# 12345 Philadelphia PA 60
> >> >> > Part# 11223 Philadelphia PA 100
> >> >> >
> >> >> >
> >> >> > Customer break SUM 660
> >> >> >
> >> >> > So, I loose the 3rd record in the detail section of the report
> >> >> > yet the totals sum up all 3 records.
> >> >> >
> >> >> > I realize the 2nd & 3rd records have the same Part#.
> >> >> >
> >> >> > None of the textboxes have "Hide Duplicates" checked off.
> >> >> >
> >> >> > Can somebody explain to me what's happening?
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>