Help to create a report with Segment Values To and From Parameters

[cruishall]

Help! I need to create a report that will need to get Segment values (code combinations) FROM and TO range.

 

[nagornyi]

Create 2 parameters. e.g. P_FROM and P_TO, and in the query restrict the selection by the parameters. Something like

where
...
and code_combination between :p_from and :p_to
...

 

[cruishall]

Thanks for the reply. I actually have this:

where
...
AND (gcc.segment1 BETWEEN _segment1_low AND
_segment1_high
AND gcc.segment2 BETWEEN _segment2_low AND _segment2_high
AND
...


is there any better way of doing this? In the application, it has an object that it calls, but I have no idea yet how the apps do it....

thanks

 

[nagornyi]

Why do you think the way you did it is not good enough?

 

[cruishall]

I think this will work in some cases, but when the user enters 'ZZZZZZZ' values for the high segment values, the report is not returning records where it should.

 

[nagornyi]

That may happen if some segments are nulls. Try using NVL function with segments.

 

[cruishall]

Thanks