Section Visibility

[sjdbmc]

I have created a report to produce an invoice to customers.

A Subreport produces the Invoice Address.

Due to human error etc people have entered the customer name into the 1st line of the invoice address which results in the customer name appearing twice in the address.

I have come up with the following formula to remove duplicates.

stringVar array Line_1:= split({address.address_1},chr(10));
stringVar array Line_1B:= split({address.address_1}," ");
stringVar array Line_1c:= split({company.descr}," ");

line_1[1] = {company.descr} or
line_1b[1] = {company.descr} or
line_1b[1] = line_1c[1]

This has been placed in the 1st line of the address, format section and suppressed formula. (Report Header C)

The other lines appear in Report Header D to H.

This works fine on my machine from within CR8.5 and fine as an executable.

The problem arises when users run it from their own machine and get the following message:.

Error in Formula
<Section Visibility>
stringVar array Line_1:= split({address.address_1},chr(10));
A number,currency amount, boolean or string is expected here.

I'm assuming it's got something to do with the evaluation time of the subreport.

Why does this work fine on my machine and not on user machines?

What can I do to fix it?

 

[Mike Lewis]

sjdbmc,

Why not simply enable the "Suppress if duplicated" setting (on the first page of the format editor)? Or am I missing something?

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com