Hi,
Depending on what you require, you could summarize(right click on the
query/dynamart) or create a select column of sorts using a formula.
There is a yahoo group for corvu usera but it is moderated by corvu
and they don't keep on top of it.
Corvu , also has a support site which if you have a maintenance
contract with epicor then you will have access to this, if you don't
already. If you don't , you will need to request a login from epicor.
They will then get one for corvu.
Depending on what you require, you could summarize(right click on the
query/dynamart) or create a select column of sorts using a formula.
There is a yahoo group for corvu usera but it is moderated by corvu
and they don't keep on top of it.
Corvu , also has a support site which if you have a maintenance
contract with epicor then you will have access to this, if you don't
already. If you don't , you will need to request a login from epicor.
They will then get one for corvu.
--- In vantage@yahoogroups.com, "Jason Abramczyk" <jasona@...> wrote:
>
> Hi,
> I am currently writing a report in CorBusiness from Vantage
8.00.810C.
> Can anyone tell me how to filter out doubled up lines in a query?
> For example:
> InvNum CustName PartNum Date
> 120 acl a12 1/1/2007
> 121 der a13 1/1/2007
> 121 der a13 1/1/2007
> 122 frg d56 2/2/2007
> 122 frg d56 2/2/2007
> 122 frg d56 2/2/2007
> 122 frg d56 2/2/2007
>
> How can i filter out any lines that appear more than once? I would
> like the query to look like this:
> 120 acl a12 1/1/2007
> 121 der a13 1/1/2007
> 122 frg d56 2/2/2007
>
> Any help would be greatly appreciated.
>
> Cheers,
> Jason Abramczyk,
> Precision Parts.
>