Dave,
Unfortunately, you must be right…but the part that confuses me is that my variable which compares the rowindex to the literal works…it is displaying Y’s and N’s appropriately for each row. So, the compare is working, and a value is being produced. It seems that this value, although derived and displayed, is not really ‘stored’, because of the error message I get when attempting to filter the Y’s. If what you said were the case, I should never have been able to get to the point of seeing the Y and N values. This constitutes a flaw in the app, in my opinion.
Oh well. Thanks for the input.
Jason Beard
AGD Consulting
Has anyone ever tried to filter a report on a variable which uses the
RowIndex function? My variable compares the Rowindex for every row in my report (1,2,3,4,5,etc) to a literal value also stored for each row (10, in this case). The variable formula says If Rowindex() <= then “Y” else “N”. I want to filter to see only the Y’s, but when the filter is placed, an error comes back saying “The list of values is empty”.
Dave’s reply:
Well, unfortunately you cannot filter on the row index because the row index is assigned after the row is displayed. Imagine data like the following:
Row Index, Data Value
1, 10
2, 10
3, 10
4, 10
5, 10
6, 10
7, 10
8, 10
9, 10
10,10
Now, the only row that should show up in your scenario is the last one. But, as BusObj is attempting to display the rows, the following logic occurs…
Row 1, data value 10… does the rowindex of 1 match? No? Don’t display row. Row 1, data value 10… does the rowindex of 1 match? No? Don’t display row. …
This happens 10 times in a row, ending up with no rows to display. This is because the rowindex starts over with each new “possible” row to display, and therefore will never reach 10.
If you want something like this to work, you must assign the row index during the data download, using a function like the Oracle “rownum” instead.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)