I am a beginner with Crystal Reports. I am currently using CR 8.5 and trying to fill out a client's reporting needs. The problem I am having is trying to create either A) sql statements with given parameters in them and b) using formulas to gather specific information. For instance, I would like to print the total expenditures for each quarter. The data is inserted on a monthly basis so I need to sum the values together. I am trying to sum them according to the database value of PEMonth. PEMonth relates to the month that it is for. I would love if CR was much more malleable like asp or php. I haven't found a way to do specific SQL statements either like
select
TotalExpenditures as TEValue
from
ProgExpenditures
where
ContractID = ?ContractID(parameter) and PEMonth=7 or
ContractID = ?ContractID and PEMonth=8 or
ContractID = ?ContractID and PEMonth=9
Sum(TEValue)
That would be my ideal formula/sql statement combination..
any advise getting closer to this ideal situation would be most appreciated..
select
TotalExpenditures as TEValue
from
ProgExpenditures
where
ContractID = ?ContractID(parameter) and PEMonth=7 or
ContractID = ?ContractID and PEMonth=8 or
ContractID = ?ContractID and PEMonth=9
Sum(TEValue)
That would be my ideal formula/sql statement combination..
any advise getting closer to this ideal situation would be most appreciated..