towt@infonode.ingr.com (Tim Tow) (02/03/91)
Is it possible to break on a substring of a break column defined in the
Ingres ReportWriter?
For example..
a field contains the following data:
33045590
33045592
33045595
33902178
33902199
The field is contained in the table called by the .query statement. What I
want to to is to subtotal (break) after the "3304" series and after the "3390"
series but I want to avoid putting another field into the data table ( I
realize I could use the left() function in SQL to split out the 4 left digits
into a discrete field).
I also can't use the left() function to get this data separately in the .query
statement because the select statement is in this form:
select * from $TABLENAME
This didn't seem to work very good either:
.break left("fieldname")
or this:
.break "fieldname"
.footer left("fieldname")
Any ideas??
------------------------------------------------------------------------------
| Tim Tow | |
| Intergraph Corporation | "Injustice anywhere is a |
| International Finance-Huntsville, AL | threat to justice everywhere" |
| Mailpath: ..!ingr!b10!fin2!timtow | |
| Voice: 205-730-2117 | - Dr Martin Luther King, Jr |
| |
| "Opinions expressed here are usually mine or like mine.. not my employers" |
------------------------------------------------------------------------------