January 11, 2007, 04:54 PM
VAPACCORDIAN REPORTS
We have 450 tax reports that users want on a dashboard but have no easy way to display without a great degree of scrolling. We want to use an accordian report. The report will read a table which will provide the hierarchy to make the reports easy to manage and run. The idea was to have a field that is hidden from the user but contains the href that would run the particular report. I can't get the href to passed to an -INCLUDE nor is the EXEC COMMAND supported. Is there a better idea?
January 17, 2007, 05:02 AM
Tony AVince,
A short while ago N.Selph posted a reply to a similar question on "Multiple Reports on one HTML page with BYTOC" This is the
link to that post.
A most effective method but I am not sure how it will handle 450 reports!!!!
T
January 17, 2007, 02:37 PM
MadamZuZui dont know if it's just me with my slow computer, but the accordian reports tend to load very sloooowly for me.
January 17, 2007, 06:06 PM
susannahshame about those Eagles...what a game, tho.
Have a single report , accordion or not, listing each of the 450 reports by name, and in that report, each 'name' is an ordinary drilldown that would run the corresponding fex.
Your dashboard page displays the reportnames but hides the fexname, yet passes that hidden fexname along in a drilldown when the user clicks the desired reportname.
PRINT REPORTNAME BY FEXNAME NOPRINT
...
TYPE=DATA,COLUMN=REPORTNAME,
FOCEXEC=FEXNAME(..), {TARGET=NEW,}$
the reportname and the fexname have to be together in some small datatable somewhere.
seems simple enough. what am i missing?
January 18, 2007, 09:35 AM
TravFrancis had a nice method that you could use to read the HTM file to get a list of reports and fex names. You should be able to use that as your datatable w/o having to create and manually maintain something -- assuming you're already using MRE.
Check out this thread for an example and then Francis should be able to help you from there if you get stuck:
https://forums.informationbuilders.com/eve/forums/a/tpc/...391088331#4391088331January 24, 2007, 02:20 PM
VAPThank you all for your help. I ended up using a variation of Susannah's technique since it was close to one of our earlier alternatives, it was the Eagles reference, and we got a working model. Tony's reference to N.Selph solution would have worked. Peformance not been an issue. 450 tax reports and growing is the issue. Thank's again.