[Crystal Reports 9]
I currently have a chart that shows the quarterly strategy allocation of a portfolio. If I want to run the report for second quarter allocations, how would I suppress the percentages for certain quarters, even though i have data for all 4 quarters?
For example, say my data is as follows:
Strategy 1: Q1-20%, Q2-10%, Q3-40% Q4-30%
Strategy 2: Q1-30%, Q2-15%, Q3-15% Q4-40%
Strategy 3: Q1-25%, Q2-15%, Q3-30% Q4-30%
There is a bar for each quarter per strategy (I've grouped by strategy). Each percentage is calculated in a formula and then the chart just pulls that number.
Is there a way, based on the date the report is run that I could suppress the data for particular quarters? More specifically, if I run the report in May I would only want to see the data for first quarter since the second quarter is not complete. And if I were to run the report in August I would only want data in the chart to show up for the first two quarters.
If it's not possible to suppress the fields that way, then is there a way to suppress 0% values in the chart?
Any suggestions or help would be greatly appreciated!!
Thanks,
Karina
I currently have a chart that shows the quarterly strategy allocation of a portfolio. If I want to run the report for second quarter allocations, how would I suppress the percentages for certain quarters, even though i have data for all 4 quarters?
For example, say my data is as follows:
Strategy 1: Q1-20%, Q2-10%, Q3-40% Q4-30%
Strategy 2: Q1-30%, Q2-15%, Q3-15% Q4-40%
Strategy 3: Q1-25%, Q2-15%, Q3-30% Q4-30%
There is a bar for each quarter per strategy (I've grouped by strategy). Each percentage is calculated in a formula and then the chart just pulls that number.
Is there a way, based on the date the report is run that I could suppress the data for particular quarters? More specifically, if I run the report in May I would only want to see the data for first quarter since the second quarter is not complete. And if I were to run the report in August I would only want data in the chart to show up for the first two quarters.
If it's not possible to suppress the fields that way, then is there a way to suppress 0% values in the chart?
Any suggestions or help would be greatly appreciated!!
Thanks,
Karina