Help with links to sub reports 1

[CDCOV]

Hi
I have problem at the moment trying to create a report in crystal 11.
I have a set of planning application records that i need to report on that relate to other applications (discharging conditons for example) in the list. The only place that the original reference is written within the later application is within a discription "text" field.

I have created a report that list all applications that have been submitted for building code consent and these link to the original planning consent. I would like to add a further sub report that list any associated applications but I cannot find a way to link the applications using the text field. is there a way to do this ?

example

original application , 2012/0001 ,2012/0002, 2012/0003

assocated applicatons in the same table 2013/0121,2012/0124, 2013/0001 (assocated with 2012/0001) 2012/0022 (associated with 2012/0002) 2013/0055,2012/1258 (associated with 2012/003)

The original reference will appear in a description text field e.g. "application for discharge of condition 3 of applciation 202/0001 granted 13/02/2012"

Can I link a sub report to part text in a string? or is there another way to do it?

I am not sure I can but I though I would ask.

many thanks in advance

Chris

 

[IanWaterman]

Assuming application number eg 202/0001 holds the first occurrence of /

You can link application no. field to a formula like this

mid("application for discharge of condition 3 of applciation 202/0001 granted 13/02/2012", instr("application for discharge of condition 3 of applciation 202/0001 granted 13/02/2012", '/')-3, 8);


Replce this text "application for discharge of condition 3 of applciation 202/0001 granted 13/02/2012" with relevant field name.

Ian