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!

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

using a formula to display data in the page footer

Status
Not open for further replies.

llarose

Programmer
Jun 7, 2010
18
US
I am trying to use a formula to print information in the report footer section using the section expert. This is a packing slip and I need to put the items that did not ship at the bottom of the page. see example below - syntax seems to be my issue.

select sd.item, sd.custitem, sd.item_desc, sd.requested_qty, sd.total_qty
from
shipment_detail sd
where
{rpt_ShipmentPackDetails.internal_shipment_num} = sd.internal_shipment_num
 
If I have more than one container ID they all will show. If I have only one it will not display.
 
I don't know what you are referring to. Are you talking about the main report or the subreport? What field are you grouping on?

The subreport will not work correctly in the report footer if you have multiple shipments--you would need to put it in the group footer and link on the group field.

-LB

 
Sorry - the subreport is working great.

It is the main report. I am grouping by container Id and it list all the items within that container ID. If I have more than one container of goods all the container ID print correctly in the group header. If there is only one container id then it does not print the group header is blank.
 
If you are referring to the groupname, then if you are grouping on containerID you would ONLY see one container ID per group. You seem to be describing the reverse, so you must be referring to a formula that you have placed in the group header. Please show the content of the formula.

-LB
 
no formula just the group name does not display with one container ID but does display if more than one container ID. I have tried to delete and re add the group...
 
Are you saying that when you choose multiple containers that each group header has a container ID, but that when you choose only one, the group header is blank?

-LB
 
Each packing slip refers to one shipment. One shipment can contain multiple cartons. Each carton will have a container ID. Each container ID will list all of the items within that carton/containerID.

0333331233656
122223 1212122 first item description 10 5
123252 1252542 second item description 9 9
0333331233656
232525 1235252 first item desc second cont 5 5
224714 1212525 second item desc second cont 2 2
 
I don't know how these numbers relate to the field names. What is your overall group structure, ie., what fields are you grouping on for group#1, group #2, etc.?

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top