SLIST + MULTIVALUE + BREAK-ON (OpenInsight Specific)
At 12 APR 2001 04:00:53PM a becker wrote:
We have 15 records on file. 2 of the records contain the match we are looking for. Record 948 has 2 matches, 941 has 5 matches.
Our slist statement is: (hopefully I'll type it correctly, there are no typos on the actual statement)
list billing_detail break-on vendor_name by vendor_name by det_month by det_year with det_month=03 limit det_month=03 and with det_fy=00 det_month det_year
Note - vendor_name is multivalue and symbolic, det_month and det_year is multivalue - det_fy is part 2 of the key (key is est,fy and invoice #
The above slist statement produces the following:
005*00*R-70-941 KICK-FM 03 00
005*00*R-70-941 WBBM-AM 03 00
005*00*R-70-941 WCKG-FM 03 00
005*00*R-70-941 WSCR-AM 03 00
(END OF REPORT)
If I leave out the BREAK-ON, the result is:
005*00*R-70-941 KICK-FM 03 00
005*00*R-70-948 KMJM-FM 03 00
ETC until all 7 matches are printed and only the 7 records are displayed.
Other slist statements work - we tried it with break-on and month=04 (all records but one have a month of 04) and it works without the extra breaks.
Any ideas where the the extra breaks are coming from?? We are completely puzzled.
Andy Becker
Illinois State Lottery
At 14 APR 2001 06:31AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Are there blank multivalues in the date records concerned?
World Leaders in all things RevSoft
At 16 APR 2001 09:34AM a becker wrote:
No - that was one of the first things we checked.
At 16 APR 2001 12:01PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Can you add a "'V'" to each of the break ons so we can see what is causing the break?
World Leaders in all things RevSoft
At 16 APR 2001 03:11PM a becker wrote:
We put in "'v'" and the report came out the same. No values were displayed. The statement read list billing_detail break-on Vendor_name "'v'" etc.
A little more information that may be helpful -
The 70-941 record has a total of 22 entries, the first 5 entries in the table are for the month 03. The rest is for either month 04 and 05.
The 70-948 record has a total of 2 entries, both of which are for the month 03.