Search results for query: *

I have an order start date and an order finish date and I need to pull all the months that a particular order spans. i.e. start date mar 1,03 finish date jun 30, 03 spans mar, apr, may, jun How would I achieve this? Any help would be appreciated.

I need help in joining two tables where the invoice # is not unique. The same invoice number can exist in different branches. Invoice_Header -Invoice_Number -Invoice_Total -Branch -79322 -259.00 -11051 -79322 -450.00 -32165 Invoice_Lines -Invoice_Number...

I have three tables that I need to join and I am having some trouble with it. Please help.. Tables: Client Orders NA_Orders OFFICE_ID OFFICE_ID OFFICE_ID group_id Order_id Order_id group_id Now, these three tables have the...

Hi, I need to adjust the data date/time fields for Australian time. Not sure how to go about this. Any help would be appreicated.

I have an Invoice Report that I am grouping by Client Name/Invoice Numbers. Some clients may have duplicate invoice numbers within a group. How do I display all invoice numbers, including the duplicate ones?

I need help with a date range problem. I have an orders table which has a starting date and an ending date. For example; order 1111, starting date Nov 1, 2002 endig date Dec 31, 2002 I need to pull all individual dates in this date range for all orders. HELP!!

I have a subreport that is pulling invoice details per client. My main report is grouped per month per client. My problem is that the subreport is pulling all invoices for the client, not only the ones for the specified months. This subreport is linked by Client Code, is there a formula that I...

I have my report grouped by company name sorted ASC. Once I refresh my report the company name is no longer sorted ASC even though the grouping is still set to ASC. Any suggetions??

I am using Crystal 8.5 and after each row in the details section it is printing on a new line as if there is a carraige return after each row. It looks like this; John Smith John Smith John Smith I'm not sure why this is happening or how to fix it! Help!

I have a table called Orders. With two fields Order_id and Parent_order_id. You can see that order_id 8122 is an original order because Parent_order_ID is -1 and the others are split orders from the original order. I am trying to write a formula that will show beside the original order a...

I have an orders table and a orders_contractor table, the orders table has a start and finish date field and the orders_contractor table also has the same fields. It seems that if an order has contractors that are extended beyond the original finish date that is shown in the orders table, it...

I believe that one of my formuals is causing my results to show a zero value for the first group record, but the next group records show the correct value. I have copied my formula below. I have also tried to suppress zero values and this does not seem to work for me. Any Suggestions...

I have a start date and an end date field. I am trying to print out the days of the week that a person worked using the two above fields..