Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Formulas

Status
Not open for further replies.

rbvcbr

IS-IT--Management
Mar 4, 2007
58
US
I am pulling data from timberline, transaction table.

This table has two fields acct_date and amounts.
If I put from and to acct_dates (5/1/09 - 5/31/09) it gives me that criteria amounts (Column1). This is good. Now - Besides this column1 I want to show amount in another column (Column2) "from day one to 5/31/09" amounts (If there is no amounts in above said Column1 in May, it will be zero - but will have in column2 previous costs/amounts.

Somebody said I have to use/write parameters for both two columns, and write formula to put that parameter data on the report. Can I get help please to create parameters and formulas. Thank you.




 
From the Field Explorer window in Crystal, Click on parameter fields and then the New Button. Create you Start date as a value type of date and create and End Date parameter.
For your formulas, Click on Forumula fields and the New button.
Give it a name and the if you use Crystal syntax
If date >= Start date and date <= End Date
Then your amount else 0
Your second forumla would be
if date < End Date
Then your amount else 0
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top