jukka@tukki.jyu.fi (Jukka Hartikainen) (02/02/90)
I have a little problem in doing SELECT-clause in Ingres Report-Writer. I know that there is no way to do it "pure", but some other way maybe... If I have SELECT ...., constant=value, ... FROM ... WHERE (condition 1) or (condition 2) and I'd like to get the value of constant 1 or 2 depending of which one of the where-conditions is true. Is it possible and how? The main idea is that the constant is one sort column and in the report there will be header and footer for that. The data is some personal records and depending of in what group one person is, his/hers data is in right place. Thanks! ---Jukka
bg0l+@andrew.cmu.edu (Bruce E. Golightly) (02/05/90)
How about using the .IF in the body of the RW procedure? We use this technqiue in one that cranks outs outlet ID labels, which makes use of run-time parameter values and .IF operations. Makes for some really ugly code, but it works. Bruce