Dan -
It looks like the view you have created is using some grouping levels.
Make sure you are not ALSO referencing the same grouping levels as
breakpoints in the report.
Second thing to check - the alias names you used in the view - make sure
they are not the same as other columns in the database, but that they are
unique.
If all else fails, post the view definition here and maybe we can figure out
something else.
-----------------------------------------------------------
Sami Aaron
Software Management Specialists
13214 W. 62nd Terr, #139
Shawnee KS 66216
913-915-1971
http://www.softwaremgmt.com
----- Original Message -----
From: "Texmaster Express" <[EMAIL PROTECTED]>
To: "RBase List Server" <[EMAIL PROTECTED]>
Sent: Monday, September 24, 2001 3:39 PM
Subject: Strange problem with a view
> 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
>
>
>
>
>
