Getting around the SELECT limitations

[Malikto]

I am running into some problems with not being able to use any SELECT statement parameters.  I often need to use the Unique option but find that I can't always use a formula to filter the data.  What other options are there or is there a way around the problem??

 

[MalcolmW]

Select distinct is an option under Report Options, if that is what you are referring to. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>

 

[Malikto]

I don't see any option for select distinct under report options.&nbsp;&nbsp;I'm using v7.0, is this a newer option?

 

[MalcolmW]

V8 only I think.&nbsp;&nbsp;In v7, you can use the query tool (or a stored proc), which will allow you full editing control over the SELECT statement. <p>Malcolm Wynden<br><a href=mailto:wynden@island.dot.net>wynden@island.dot.net</a><br><a href= > </a><br>