Recent content by cmetz

ALTER procedure DBA.rep_contmissingOB2(in @Enter_date date) /* parameter, ... */ /* RESULT ( column_name, ... ) */ begin declare p1 integer; declare p2 integer; declare p3 integer; declare p4 integer; declare p5 varchar(150); //Find all outbound containers with missing contents...

When I go to the drop down of the stored procedure where it usually list the fields to add to my report, mine only says Expression

I am using Crystal Reports 9. Are you familiar with what I am talking about? Getting Expression instead of the field list?

I did a stored procedure, when I try to create a report and I add the procedure, I get Expression in the drop down and not the list of fields. Thanks

I want to have the Notes show up on my diagram, how do I do this?

What would I write in the procedure to then group by the customer numbers? Thanks

Thanks so much, that worked perfectly.

I have written a procedure and I need some help. I want to list a bunch of routes but also have two different destination locations. Here is part of the procedure: routestops.routecode = 'NEC5-1'or routestops.routecode = 'NEC2-1' or routestops.routecode = 'NEC3-1' or routestops.routecode =...

You are correct that I have two tables, thanks so much for the help. I will let you know the results.

It is not that I want to supress any information, I want to display all the routes and then have the delivery information filled in. If there is no delivery information I still want the route to show up on the report and the delivery information would just be blank. Does this make sense? Thanks

This is what it looks like now: Route Customer Id Delivery Date Delivery Time NCC123 1234 10/02/02 13:00 What I would like is for the report to show all the routes and then fill in the information that pertains to it. NCC123 NCC456 5465...

I want to have all my routes show on the report and then have the ones with delivery times to have the delivery information show. How do I get that to work? When I run the report it only will display the routes with delivery information. Any help would be great. Thanks

I want to have all routes that have the same destination show up on the report and then have the actual delivery time for the ones that did show up. I cannot get it to list them all and then show the data. Thoughts. Thanks

I uninstalled and reinstalled the software and during the installation it says APS Log On Please enter user name and password to log on to the APS. It has Administrator as the user name and I put in the password for Administrator on the server, I have even left it blank and it will not work...

During the installation process you are prompted to enter an administrator password to log on to the APS, I cannot get past that point. Any thoughts on this?