Crystal 10 Comission Report

Yahoo Archive
1
Awesome, that's it

Thanks


--- In vantage@yahoogroups.com, "Brian Stenglein" <bstenglein@c...>
wrote:
>
> Try this formula.
>
> Instr() will return a number that represents the location of ;
inside
> InvcHead.Reprate. Left() will return the X left most characters
of the
> string InvcHead.RepRate, where X=location of ; - 1.
>
> left({InvcHead.RepRate},InStr ({InvcHead.RepRate}, ";")-1)
>
> HTH,
>
> Brian Stenglein
> Clow Stamping Co.
>
>
>
> --- In vantage@yahoogroups.com, "Gerard Wadman" <gwadman@s...>
wrote:
> >
> > I have a crystal report for rep and dealer commisions and I need
some
> > assistance with the "RepRate" field in the Invoice Header table.
> > When I select it the report displays a delimited string with
values
> > seperated by semi-colons.
> > All I want to view is the first value of this string, does
anyone
> know
> > a formula that will make crystal ignore or supress all values
after
> > and including the first semi-colon ??
> >
> > Regards
> > Gerard
> >
>
2
I have a crystal report for rep and dealer commisions and I need some
assistance with the "RepRate" field in the Invoice Header table.
When I select it the report displays a delimited string with values
seperated by semi-colons.
All I want to view is the first value of this string, does anyone know
a formula that will make crystal ignore or supress all values after
and including the first semi-colon ??

Regards
Gerard
3
Try this formula.

Instr() will return a number that represents the location of ; inside
InvcHead.Reprate. Left() will return the X left most characters of the
string InvcHead.RepRate, where X=location of ; - 1.

left({InvcHead.RepRate},InStr ({InvcHead.RepRate}, ";")-1)

HTH,

Brian Stenglein
Clow Stamping Co.



--- In vantage@yahoogroups.com, "Gerard Wadman" <gwadman@s...> wrote:
>
> I have a crystal report for rep and dealer commisions and I need some
> assistance with the "RepRate" field in the Invoice Header table.
> When I select it the report displays a delimited string with values
> seperated by semi-colons.
> All I want to view is the first value of this string, does anyone
know
> a formula that will make crystal ignore or supress all values after
> and including the first semi-colon ??
>
> Regards
> Gerard
>