Good afternoon.
I finally did my first outer join view (thanks Dr. R>), and have noticed
some strange behaviour when running the same view off a report. I'm
wondering if I'm trying to make RBase do something it wasn't meant to do.
My view runs fine at the R> prompt. When run through Reports, it builds up
the .$$$ sort file until I have to do a three finger salute and close down
RBase. However, if I recreate the view (which uses several functions, such
as MAX(t2.charge), etc) without naming the columns (Create View as (Maximum)
MAX(t2.charge), it runs just fine. Unfortunately, the calc'd fields won't
display in the report, only the group by column, so I do need to do it the
first way.
Any idea why it crashes the sort file through Report but not in a Select via
the R> prompt?
Thanks,
Dan
