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...
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 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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.