Search results for query: *

(Select {?p_Period} [5 to 6] case "12" : ToText((ToNumber(Left({?p_Period},4))),0,"","") default : ToText((ToNumber(Left({?p_Period},4))-1),0,"","")) & (select {?p_Period} [5 to 6] case "12" : "01" case "10", "11" : ToText((ToNumber(Right({?p_Period},2))+1),0) default...

Good afternoon all! How do I export to excel or should I say have the report format in excel formatting using a pramarter that states if Excel then true else false. if true then I get the excel formating otherwise I get the report formatting.

I keep getting this "A string is required here", error (on the last if statement, ({@count2})) on this formula (I hope I am giving you enough information): If {?p_Department} = "Yes" and {?p_Excel} = "Yes" then {?p_Excel} Else (If ({?p_Technician}={Command.usr_id})Then...

Ok - I am getting frustrated with this. In my group footer ({Command.usr_id}) I have to group together the names and sum each of there columns if my parameter = No and they have more thatn one listing. ie.: Doe 0 12 15 31 Smith 5 6 27 4 Mouse 0 0...

I have to add a Yes / No parameter to my report. Yes = user wants to see the department and no = they don't. Not sure how to go about doing this - this is a new realm for me. I know it is an If statement - how do I get it into the parameter vales parameter dialog box? Here is my Crystal /...

I need a grand total on the following formula (running totals will not work - it does not look at my conditions , so the running total is incorrect): the name of the formula below is MeterUsage IF COUNT ({work_order_test;1.Meter}, {work_order_test;1.EquipNumber})> 1 THEN (IF...

I need to do the following: In this example, the data is bad but we need to account for it as best we can. The ofe_hourmeter1 is like the odometer in your car. There is no way that your odometer reading on 2/25 can be greater than your odometer reading on 2/28. We are doing calculations on...