Proper syntax for an Array to suppress data...

[Liamster]

Crystal 8.0

Attempting to suppress locations that do not have any sales in the last week of ending (to) date range parameter.

Here is what I am attempting to have suppressed...

{Sales Data.WeeklySale} In [{?DateTo}] > 0

I am getting this error...

This array must be subscripted. For example: Array .

I have attempted a few different versions with no luck. Any help with syntax would be appreciated.

Thanks.

 

[lbass]

Change your suppression formula to something like:

{table.salesdate} in {?daterange} and
{salesdata.weeklysales} = 0

I'm assuming you are using this in the section expert->suppress formula area for the details section.

-LB

 

[Liamster]

Yes, thanks LB - I am in the area you speak of.

Here is what I entered...

{Sales Data.WeeklySale} in {?DateTo} and
{Sales Data.WeeklySale} = 0

I am getting a "A number range is required here" error. The parameter is a number (e.g. 20050306) and is set as such.

Do I need a formula to convert this? If so,what would that look like? I tried the ToNumber function, but did not work. I need the parameter to be in the report for the users.

Thanks.

 

[lbass]

Why are you trying to apply a date parameter to a sales amount? You need to use the date field (associated with that sales amount) for the date range parameter as I indicated:

{table.salesdate} in {?daterange} and
{salesdata.weeklysales} = 0

-LB