parameter to accept part input

[Cpreston]

Hi

I have a report that asks for Length of something.

132/5.4
130/5.4
144/4.8

The numbers at the end are the important thing. I am trying to figure out how I can enter just 5.4 and this will bring in all products with the 5.4 length.

Currently if we enter 132/5.4 it works but then misses out the 130/5.4

So does anyone know a way I can enter in the parameter when it asks something like %5.4 or *5.4 or just the length of 5.4 and it finds all codes with 5.4 length

132/5.4
130/5.4

The field s from sql and the information comes in as displayed

Any ideas please. Thanks

 

[Charliy]

I would split it into two separate parameters.

 

[kray4660]

I think if you used a formula for the selection that looked something like this. {somefield} like '*'+(?Prompt}. It should return every thing that ends with the Prompt value.

 

[Cpreston]

Hi

I managed to get it working using the below in the parameter, thanks for the replys

{ProductPack.QuantityTally} Like "*" & {?Length}