Re: [DataVision-users] How to approach a mildly complex query

[Jim M. <ji...@io...>]

William,

> I've got the SQL query for returning the data that I'm interested in,
> I'm trying to figure out if I can use DataVision to actually
> generate the report.  The following query reports charges to a vendor
> which were not also charged to (on behalf of) a client.  Suggestions
> welcome on how best to approach this.

I suggest you create a view that implements this select statement, then 
run the report over the view. The dates and other variables can be 
report parameters.

Jim
-- 
Jim Menard, ji...@io..., http://www.io.com/~jimm/
"Eating kittens is just plain ... plain wrong! And no one should do it, 
ever!"
     -- The Tick