Changing labels in a cross tab

[SDS100UK]

I have little understanding of the formulas in CR so be gentle with me!

I really hope this is possible

I have a crosstab which has a date filed as the column header. I have labels above the date that indicate how many weeks ago the particular date was. The dates are always Yesterday, 1 week ago, 4 weeks agao, 8 weeks ago, and 12 weeks ago.

Sometimes there is no data in my DB for yesterday so the figures move left accordingly but the labels stay where they are, thus proving to be inaccurate.

How can I get the labels to update accordingly so that they say the correct period of time ago from the date?

Hope all this makes sense
Thank you

Steven

 

[kenhamady]

Sounds like your labels are static text objects. You could try to replace each label with a formula that checks to see if there is a "Yesterday" in the report and then print one of two different values.

Or your could try to incorporate the label into the cross-tab heading itself.

What is the column field of your Cross-tab and what data type does it have? Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/