I haven't tried this yet, but I'm wondering if a list can be dynamic if it uses custom SQL? Or, working from another angle, has any one used a stored procedure to populate t_list_contents?
I'm going to be adding a constituency to records based on somewhat complex criteria that would be hard to construct in List Builder. But I would love to use the Manage Constituency report to do the actual constituency part. Is there a straightforward way to do this?
could you not use your procedure to create a local view or table then slip some easy custom code into the list so it pulls constituent ids from that table?
select distinct customer_no from lv_stuff
Thank you all for the ideas!
Kevin, I haven't tried pasting my code into the Manual Edit window yet (just writing the code now). I think it will end up being complicated enough that Dale's local table would be preferable.
But since I'm always a fan of re-using code.... Gary, if you could post/send your report (or at least the SP for it) that would be very helpful! Sounds like just what I need. (CSI's are going to be on next month's menu I suspect.)