[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Printing Entire Lookup Table?
- Subject: [sqr-users] Printing Entire Lookup Table?
- From: Matt Rogish <rogishmn@muohio.edu>
- Date: Tue, 26 Jul 2005 10:19:14 -0400
- Delivery-date: Tue, 26 Jul 2005 09:19:59 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
List members:
If you reply, could you reply directly to me as well as the list since I
receive a digest and sometimes it takes a while for that to end up in my
inbox. Thanks!
I have a lookup table which stores some code -> description combinations
(somewhat more complicated than that). What I'd like to do is iterate over
the entire thing so I can print out the code -> description pairs as some
sort of a footnote at the bottom of the report.
I can do something goofy like put all of the codes in an array and iterate
through them and perform a lookup, but that's not really optimal (I might
as well store the description in the array and not use the lookup table to
begin with). Otherwise I have to hard code the descriptions etc. at the
bottom and since the codes are dynamic then, well, that won't work either.
There's no real good alternative -- I need to be able to go over the entire
lookup table. Anything else is going to be sucky, but if there's no way,
then I'll take advice as to which is the least sucky method. :)
Thanks,
--
Matt Rogish
Programmer
Advancement Services
Miami University
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users