Search results for query: *

I found out what the problem was - it uses XML also which I was not aware of or trained in. I was trying to do it all through Crystal and sql. There are internal sorts being done that I could not see. Thanks for responding to my cry for help. It is much more complicated for this newby...

I have a report that the group header doesn't always display. This is a packing slip that is grouped by container ID. The problem is that when there is only one carton id it does not display, if there is more than one carton id then they all display. I think that I know why but don't know...

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...

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...

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...

If I have more than one container ID they all will show. If I have only one it will not display.

ok went to the subreport route and that worked great.... Somewhere along the line I lost my group header display. I have a group header for the data called container id that list all items within that container. I have it set up and can see the container id's if I browse the data but it...

I am pretty close now as I got two out of the three to display in the not shipped field. I can suppress them in the detail area so that isn't a problem there. Not sure why the third one is not printing. I did finally do the can grow as suggested. That seemed to help some in the display...

I have corrected the formula as outlined above. It is still only printing one of three lines that should go into that not shipped section. It appears to be only the first item. When I make the change you noted to the stored procedure using the tree section my report goes into a loop...

from SHIPMENT_DETAIL sd left join SHIPPING_CONTAINER sc on sd.internal_shipment_line_num = sc.internal_shipment_line_num /*and sc.tree_unit in (select tree_unit from shipping_container */ where sd.internal_shipment_num = @INTERNAL_SHIPMENT_NUM ; This is what I changed it to...

oh that sent it into a loop and brought back records that were not related to the internal shipment num. I was confused as to why you would change a where to an and? What if I took out that section?

left join SHIPPING_CONTAINER sc on sd.internal_shipment_line_num = sc.internal_shipment_line_num where sc.tree_unit in (select tree_unit from shipping_container where internal_shipment_num = @INTERNAL_SHIPMENT_NUM) ; I am not sure what the tree_unit does and that may be what is...

I did try that approach and it did not appear to make any difference. I have been making so many changes that it is hard to keep track of. :) I will try this again.

ok - my last issue and it is a show stopper. I have the three tables that my stored procedures are pulling the data from. The problem is that the table that is running the show is the shipping container table and it only contains records that have been shipped. So I do see the partially...

Ok - already figured out that is not what you mean't. I created a formula field and inserted in into the detail section. I made the field as small as possible and would rather not see it at all if possible. The other formula field I created I inserted in the report footer and it printed the...

I apologize for my lack of knowledge as I have only had two day course in Crystal..... Do you mean in the section expert of the detail section? Would I choose the suppress section and enter the formula there? That is what I did and got an error that formula must result in a boolean.

There are two stored procedures within the report. One pulls shipment header and the other shipment detail and container detail. How I know is from the shipment detail has two fields requested qty and total qty. If total qty is zero or less than requested qty than I know that item has not...

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...