Formula to Suppress a chart.

[tttggg]

I have a report which is grouped by last seen (Date) and each group will have a Bar chart in the group footer. There is a parameter, to select the number of row to be displayed in each group. for example if the user select 25 then each group will display 25 rows. TO do this i'm using the following formula{#Rows}> {?Limit} in the detail section. Every thing works fine expect the chart. To limit the number of bars in the chart i'm using the top N feature with {?Limit} to define the N. One of the requirements that i have is that i shouldn’t have a chart when the number of rows exceeds 50.Here is where I’m stuck. the issue is, if i use {#Rows}>50 to suppress the chart, i'm not getting the result which i wanted. What happen here is, if a group actually has more than 50 rows and the parameter value is 25 then the chart will not display. I cannot use {?Limit} here because some groups will have just 1 or 2 rows. So what happens here is, the groups which have 1 or 2 rows will not have the chart because of the {?Limit}
Can any one help me with this issue.

Thanks in advance

 

[lbass]

Your requirements are not clear. Please try again. For one thing, if you want the chart not to appear if the # of rows is greater than 50, why does it matter if {?limit} is set to 25? I also didn't follow why you said you couldn't use {?limit} because some groups only had a couple of rows.

-LB

 

[tttggg]

Thanks for the response,
Since each group has different number of rows and if i use {?Limit}, what happens is that groups which has less number of rows than the Parameter value will suppressed.
For Example say group X have 15 Rows and if the parameter value is 25 then that group's chart will be suppressed.

If i use the {#Rows} to suppress, It works fine expect for the first group. the 1st group's chart is not showing up. I don't
know weather i'm missing something here.