Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Chart Header and Getting Data for a Specific date

I have several charts that I create that involve the date at the bottom of the chart and numbers along the left. The charts shows me upto 5 years of data. I want to create a header that will gather the data for today, for 1 year ago, for 2 years ago and so on.

The problem is right now I dont have a clue how to set it up. Right now I have the years and I just type in the data next to them in a text box.

High: 05/22/08 = {1Max of vwCrackSpread.HOCrackSpreadBbl}

Low: 05/19/09 = {2Min of vwCrackSpread.HOCrackSpreadBbl}

Today in 07 = 15.4984, 08 = 27.3042

09 = 2.7872, 10 = 11.8284

Current: {3Max of vwCrackSpread.TradeDate} = 23.1374

the whole thing in the text box looks like the above.

High: 05/22/08 = 36.1148

Low: 05/19/09 = 2.7872

Today in 07 = 15.4984, 08 = 27.3042

09 = 2.7872, 10 = 11.8284

Current: 05/19/11 = 23.1374

Comes out like the above.

But I dont want to type in the data for each year. How do I get Crystal to do the work for me?

Crystal Reports version 9.2.2.693

Thank you for your time.

Robert.

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question