Hello!! I would most appreciate info on the LineNumber function. I would like to filter on the linenumber in my report. The Line Number[] will display the line numbers; but will not allow me to filter. I would also wonder if there are any sort of arguments I could use to grab the particular line number with the function. Even if there is an indirect way to filter using the LineNumber function, I would greatly appreciate advice!! It just seems a shame to have the line numbers displayed, but not be able to do anything with them!!!
Even if there is an indirect
way to filter using the LineNumber function, I would greatly appreciate advice!! It just seems a shame to have the line numbers displayed, but not be able to do anything with them!!!
Sorry, but it is not possible and its not quite so illogical too.
The linenumber gives you the current line in the datablock as it is displayed, but that off course would change when you start to filter out one or more. If you filter linenumber 5 than 6 would become 5 and would you want to filter that as well? See the problem?
Couldn’t you use Rowindex() instead? Since that number gets fixed before formatting, you can filter on it.
In a message dated 98-09-28 16:51:57 EDT, you write:
Hello!! I would most appreciate info on the LineNumber function. I
would like to filter on the linenumber in my report. The Line Number will display the line numbers; but will not allow me to filter. I would also wonder if there are any sort of arguments I could use to grab the particular line number with the function. Even if there is an indirect way to filter using the LineNumber function, I would greatly appreciate advice!! It just seems a shame to have the line numbers displayed, but not be able to do anything with them!!!
Diana:
Line numbers are assigned after the data is displayed. Since filters have to be done before the data is displayed, the idea of filtering on a line number is unfortunately not possible.
May I ask why you were trying to filter on line numbers? If you wanted the “first five” items, you can solve that with a Rank tool. Without a little thought I’m not sure of any other reason why you would want to filter on the line number.
There is also a RowIndex() function that will display a unique number for each row of data. The LineNumber() refers to lines on the report, so the headings are included.
I am trying to hide a block if no data is returned for a given section. Using IsNull does not appear to work, so I am trying to use the LineNumber function. Since the header and footer are assigned min 1 and 2, then I want to say if LineNumber()<3 then hide. What is the correct syntax for this function for …format table/hide block?
(BOB member since 2002-06-25)