I have been using the same report in pulling accounts details. For example, segment 1 - 5200*|5100*
segment 2 - 10
segment 3 - 100
but when I run the report, all other segments 2 will be pull as well which means all 5200-10-100, 5200-20-200, 5200-30-300 etc. and
51200-10-100, 5100-20-200, 5100-30-300 will show on the report but not limited to segment 2 and 3 as requested.
Thanks,
Louise
Hi Louise -
Are you filtering your function using something like this?
=GL("Rows","Accounts",,,,,"5100..5200","10","100")
Which would look like this in the Jet Function Wizard:
Hi Harry,
This is what I used instead
Hi Louise -
That may work (particularly if Segment 1 is 5 digits or more long, if it's only 4 digits, you'll want to change that option). What do the GL functions, themselves, look like?
In the report options, I specified with segment 2 for 10 but the GL pull all other segment which is not what I was requested. Did I miss anything?
Hi Louise -
In order to determine what the report is configured to do, I would need to see the actual function(s) present in the cell(s).
You could take a screen shot with such a cell selected:
or a screen shot of the Jet Function Wizard for that cell:
Another option you would have would be to submit your question (along with a copy of the report) to Jet Reports Technical Support:
