Visual Basic Crystal Reports - CR.NET Suppress using Formula Not Working

Author

CR.NET Suppress using Formula Not Working

Jeff

2005-06-09, 4:01 pm

All,

I am using VS 2003 with CR.NET. I have a report with two groups and
then details. In the details pane, I have labels that describe the
data. For example

First Name: @Fname

If the data is blank, I would like it to suppress the line. The data
is suppressed fine, but the label still appears. I have tried:

1) Creating a suppress (no drill down) formula of
trim({MyData.PrimaryKey}) = ""
2) Moving the data into a group and trying the same as #1
3) Putting the same formula on each label

None of these work. Does anyone have any suggestions?

Thanks,
Jeff

Bob Holmes

2005-06-09, 8:59 pm

Hi Jeff,
I don't use the .NET version, but, with CR10, I would use a suppression
formula on the label field that will suppress when the data field is null:
IsNull(Table.Fname)

--
Bob Holmes

"Jeff" <jeff.washburn@tevaneuro.com> wrote in message
news:1118328322.660166.250750@o13g2000cwo.googlegroups.com...
> All,
>
> I am using VS 2003 with CR.NET. I have a report with two groups and
> then details. In the details pane, I have labels that describe the
> data. For example
>
> First Name: @Fname
>
> If the data is blank, I would like it to suppress the line. The data
> is suppressed fine, but the label still appears. I have tried:
>
> 1) Creating a suppress (no drill down) formula of
> trim({MyData.PrimaryKey}) = ""
> 2) Moving the data into a group and trying the same as #1
> 3) Putting the same formula on each label
>
> None of these work. Does anyone have any suggestions?
>
> Thanks,
> Jeff
>

Sponsored Links