Hi i have a report that gives details about warehouse packages. i was asked to insert shipping address and id number on the top. so as per their requirement it should be on the page header.
but as we know we cannot add fields to page header. so what i did was i created a group by ship to name and inserted all the values in it. that was fine.
then they asked me to insert another group based on item number. and in that group i have inserted the labels for the details. ok that was also good. then again they wanted to group it by seq number and there i have inserted some fields like item number and description. finally i have details row where i have displayed some more details. so here comes my problem. when i tried to do sum for the package quantity which was in the 3rd group from the 3 group footer that is the item number group footer i am required to get the sum of the values that were being seen on the quantity coloumn. but when i do the sum it is showing me the total quantities sum like if we have 2 serial quantities and as i was grouping it in third group again the values are showing up as 2 and 2 in both rows instead of 1 1 and sum is showing up as 4 but i need only 2.. so if any body could understand my problem please answer it . if you have any doubts please just keep a reply iwill get back to you soon....
No the actual format is some thing like this: