Search results for query: *

Can I set the focus to a different record in order to save when I press a button that I have on the form that opens a report.

My form (continuous form) has only two objects. A bound text box and a bound check box in the detail section. The check box is bound to a yes/no field in my table. When I select a check box it does not update the table field until I click in a second check box. Thus I can not select just one...

This does not seem to have any effect. I created the agent and copied your formula into it. The agent runs but it doesn't fix the issue. However if I open the task and click Save and Close then it works. So I think we are on the right track. Any suggestions.

I am using Lotus Notes 6.5 and I have an Excel spreadsheet that I have saved as a 123 (.wk4) file. In Lotus Notes I imported the file using File Import. I then used the following critera: Import as: Main Document Using form: To Do Defined by the WKS title: this is turned on WKS Range name...

I split the GF into two sections and placed the SR in the upper section. In the upper section I turned on Underlay Following Sections so everything appears on the same line of the report. One last thing. I have a formula field INVTRANTDOL with the following: whileprintingrecords; shared...

Group header and details are suppressed. Group footer contains the fields, subreport and calculation

Sorry but I do not need to sum the group for work_order.desired_qty. I think what is happening is the aveprice shared with the subreport is one record off. For example would be the result of my report: Main report Part Qty aveprice Total A 1...

I have a main report that links to a subreport using the part number to find the average selling price from all customer orders. This average is displayed on the subreport. I need to use this average to multiply by an order quantity for a total order price and then give a grand total at the...

Maximum ({PART.SAFETY_STOCK_QTY}) Maximum ({@Part Annual Usage QTY}) Maximum ({@Date diff})

This is the formula for setting a rank for a part. if {@Part Safety Stock QTY}=0 and {@Part Annual Usage QTY}=0 and {@Date diff}<8 then 5.9*{@Date diff}/{@Max Date diff} + {@Cust.Order}*10 + {@Days of S}*2+{@CustOrderRank} else if {@Part Safety Stock QTY}=0 and {@Part Annual Usage QTY}=0 and...

The formula is fairly long and involved plus any changes would require a lot of testing to validate the data. Is there possibly any other way to sort?

I am using Crystal 8 for a report that ranks parts using a formula field with several IF statements. The formula field is in the details section and I need to sort by this field in descending order. If I try to use sort records the field is not available. How can I sort by this ranking?

I have a report that queries the part number and then links to a subreport to find all customer orders with that part and average the selling price. The average selling price is displayed on the main report for each part number. How can I sum all the averages from the subreport on the main report?

I'm having a problem with generating a report. I need to spool a report from 2 tables is ms sql 7.0. How do i generate the report for s specified date range?? Please help....