Search results for query: *

This is a SQL formula, but I can use the Crystal. Which one would you suggest?

Thank you, but I tried that and it still only read the last if/then statement.

How do I enter multiple conditions in one formula? Here is what I have. It only uses the last if/then in the formula. if CStr({tbl_Item.Amount2})=" " and ({tbl_Promo.Scan}> {tbl_Item.Amount}) then formula=({tbl_Item.Amount}*{tbl_Qty.Qty}) end if If{tbl_Item.Amount}=CCur(0.00) then...

I need a formula that will multiply a different variable to a field based on the owner of the product and a specific date range. I am using some fields from access that are a date/time field. I'm trying to convert them to a date field. This is what I have so far. There are no errors in the...

Thank you! Thank you! Thank you!

It is in the only group header in the main report.

I am bringing a calculation into a main report from a subreport with the following formulas: Formula in the subreport: WhilePrintingRecords; Shared CurrencyVar myTotal:=Sum({Orders.Order Amount}) Formula in the main report: WhilePrintingRecords; Shared CurrencyVar myTotal; myTotal My problem...

I have version X. Thanks though.

How do I get the values in the parameter to automatically refresh? I don't want to have to import new default values everytime I refresh the report.

I had this problem before. You need to change the field type. Click to show the Type conversion options under functions. (Try CCur first. If that doesn't work, then try CDbl.) If you're in Crystal Syntax your formula will look like this {ORDETAIL.QUANTITY ORDERED} * CCur({INVENDSC.COST})

How do you create a parameter for a formula field? My formula field is (unit cost*qty) which creates a total cost. An example would be the user wanting to filter out any total cost under $100?

How do I add multiple parameters for different fields so the user may choose just one criteria for one field? (So, they wouldn't have to choose 3 criterias) For example, they would want to filter the report {field.color}= red & sometimes they would want to filter it {field.date}> 1/28/07.

If I'm understanding this correctly, you could create a subreport for the non-forest & insert it into the forest report. In order to get the grand total, you would have to add the forest & non-forest together. For the non-forest subreport total to show & allow you to add it to the forest...

I'm looking for a way to print the record closest to the current date without using a parameter. (I don't want a parameter because this will eventually be a subreport.) Example: The last date a product was produced.

How do I get a calculation with a division by zero to show without an error?