Group by first nine characters

[redbunny78]

Using crystal 10 and Oracle

I am trying to group on a report by the first nine characters of a job name.

What is the best way to do so?

Thanks!

 

[PatriciaObreja]

In the Select statement at db level create another field that will contain the first 9 characters of the job name.

Select ..., SUBSTR(job_name, 1, 9), ...

And then in Crystal group by this new field.

 

[AndyMc]

redbunny78,

If you want to do this within Crystal, you could create a formula

//@subJob
{table.jobName}[9]

Then group on the @subJob formula.

Andy

 

[AndyMc]

Whoops,

//@subJob
{table.jobName}[1 to 9]

Andy

 

[redbunny78]

Perfect! Thanks so much.