Hi Jennifer,
I may be repeating someone else's advice, but the report will group for
you based on breaks.
To the best of my knowledge 'group by' would not apply to the print
command, but to select commands. The error you are getting pops up
because the column list used in 'select' must be included in 'group by'.
Something like:
Select A, B, C ... group by C, A, B ...
Ben
Roberts, Jennifer wrote:
Thank you, but the information pulls alright, I will change the code
for ease of use though. The problem is that I want the information to
grouped by building and floor, and then ordered by date ascending.
However all I can get is the report to group by building and floor and
then start new page breaks then, but it completely ignores the date
being sorted. I do not see anything in the break to do any type or
sort or order by…. ???
*From:* [email protected] [mailto:[EMAIL PROTECTED] *On Behalf Of
*Ben Petersen
*Sent:* Monday, April 28, 2008 1:59 PM
*To:* RBASE-L Mailing List
*Subject:* [RBASE-L] - RE: Illegal Column Specification
> WHERE discharge IS NULL +
> AND company <> '003' +
> AND (nexthp < .vtoday +
> OR nexthp BETWEEN .vtoday AND (.vtoday + 7))
Just for ease of maintenance, and maybe a little performance,
maybe
> AND (nexthp < .vtoday +
> OR nexthp BETWEEN .vtoday AND (.vtoday + 7))
could be
> AND nexthp < (.vtoday + 8) [between is inclusive of 7, right??]
so your where clause could be
> WHERE discharge IS NULL +
> AND company <> '003' +
> AND nexthp < (.vtoday + 8)
Ben
This electronic message contains information from The Ohio Masonic Home, its
operating subsidiaries or affiliates. The information may be confidential,
privileged or otherwise protected from disclosure. The information is intended
to be received solely by [email protected], for use as designated in the
message. If you are not the designated recipient, you are instructed not to
review, disclose, copy, distribute or otherwise use of this transmission or its
contents. If you have received this transmission in error, please notify The
Ohio Masonic Home immediately at [EMAIL PROTECTED]; in addition, please delete
your record of transmission. Sending, receiving, downloading, displaying,
printing material that is harassing, fraudulent, offensive, intimidating,
defamatory, or otherwise unlawful or inappropriate is strictly prohibited by
The Ohio Masonic Home.
