Search results for query: *

Here is the solution I came up with. I took the variable off of the Parameters: field. I clicked on the Embeds button and on the Accepted embed point, I set my global variable. Then I checked this global variable in the called procedure. It worked just like I wanted it to. [smile] HTH...

In one of my applications, I have a menu that 'surrounds' all my procedures. On one of the Items, I would like to pass a parameter to the called procedure. On the Actions tab - I have tried putting a global variable in Parameter: field but when I compile it, I get two errors: 1. No matching...

A solution: I went into the ... on the Report and moved the added Detail line (for the report summary) to be before the group and that seems to have solved the problem. Rena

PS. I noticed that started happening after I added another Detail band to print summary (Grand Total) line at the end of the report. Thanks, Rena

What would cause the Group Footer band to print at the end of the report with zeros in the fields. I am using fields from the detail section (amount, weight, and cases) and putting (in the properties box) Total Type: sum and a Reset On: Custno. So at the very end of the report, I get the...

I need to write an app against a VisualFoxPro database. When I try to import it, I select ODBC as my File Driver. I enter the datasource, leave the user id and password blank and click the Exclude system files option. Click Next and I get the following error: Could not Connect to Database...

Thanks for your reply. I found the problem. As it is with so many problems in Clarion it was a matter of where I was putting my embed. Once I found the right place it worked fine. Sorry, I ment to post this earlier but I took off early and forgot. In response to your suggestions. I did...

Does anybody use the 3rd party vendor CapeSoft? I am specifically looking for some help with their Office Inside product (importing an Excel spreadsheet). My situation: I have a workbook that has several worksheets. I am having difficulty opening the workbook and pointing to the specific...

...WhilePrintingRecords ; Shared currencyVar Sum_TotCst ; If {ssinvent.uomcost} = 'M' Then Sum_TotCst := Sum_TotCst + (({ssinvent.onhand} * {ssinvent.avgcost}) / 1000) Else If {ssinvent.uomcost} = 'CWT' Then Sum_TotCst := Sum_TotCst + (({ssinvent.onhand} * {ssinvent.avgcost}) / 100)...

The reason I say I cannot sum is because when I right click on the field the insert summary is not available. The formula above is the entire formula (re-displayed here for clarity): {@TC_OnHand} - Sum ({@Total_Cost}, {bbinvmov.matno}) It contains a summary which is probably what is causing...

...the difference between two other values. One of the values is a formula: @TC_OnHand If {ssinvent.uomcost} = 'M' Then ({ssinvent.onhand} * {ssinvent.avgcost}) / 1000 Else If {ssinvent.uomcost} = 'CWT' Then ({ssinvent.onhand} * {ssinvent.avgcost}) / 100 The other value is a SUM of...

Thank you! Thank you! Thank you! That works. Now I can go on to something else [bigsmile].

...in the detail (which will be suppressed) known as @Total_Cost: WhilePrintingRecords ; If {ssinvent.uomcost} = 'M' Then ({bbinvmov.committed} * {ssinvent.avgcost}) / 1000 Else If {ssinvent.uomcost} = 'CWT' Then ({bbinvmov.committed} * {ssinvent.avgcost}) / 100 I can not perform a...

I just want to show by jobno and matno. The final report will have both GHs and the detail suppressed.

...cut and pasted from Crystal: currencyVar Sum_TotCst ; If {ssinvent.uomcost} = 'M' Then Sum_TotCst := Sum_TotCst + ({bbinvmov.committed} * {ssinvent.avgcost}) / 1000 Else If {ssinvent.uomcost} = 'CWT' Then Sum_TotCst := Sum_TotCst + ({bbinvmov.committed} * {ssinvent.avgcost}) / 100...

Hi Jim, When I put in the WhilePrintingRecords, my Sum_TotCst formula stopped working correctly. I inserted the If statement you suggested. I am still working with the first two matno's so I haven't gotten to page breaks to know if that was a problem or not [smile]. Thanks for the tip. Hi...

...The total allocated cost is as follows: currencyVar Sum_TotCst ; If {uomcost} = 'M' Then Sum_TotCst := Sum_TotCst + ({committed} * {avgcost}) / 1000 Else If {uomcost} = 'CWT' Then Sum_TotCst := Sum_TotCst + ({committed} * {avgcost}) / 100 It all works well except than I need to clear...

The fog is getting a little thinner. So to use your example, if I want the detail information can I write the following: Select CustId, SaleDate From Sales Group By CustId, SaleDate If not, how does one accomplish it? I am use to Visual FoxPro and Crystal Reports. They both do group by...

Hi all, I am still in the reading stage of SQL programming. There is something that confuses me that I hope somebody on this list can explain. My sources make the following statement: "Any other columns that appear in the select list must be used as arguments of an aggregate...

Thanks for all your input but I still don't have the answer. Ngolem - when I put a conditional suppress on the fields. It suppressed based on the value of difference one group back. IE. line a difference = 0.00 - it suppressed it line b difference = 25.88 - it suppressed it line c...