 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Read-Only TopicGo | Search | Notify | Tools |
| ACCORDIAN REPORTS | Login/Join |
| Member |
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? Vince | ||
|
| Expert |
Vince, 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
| |||||||||
|
| Gold member |
i dont know if it's just me with my slow computer, but the accordian reports tend to load very sloooowly for me. ~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~||~~~ PROD: WebFOCUS 7.1.3 on Win 2K/IIS 6/ISAPI Mode/Self-Serve Apps Only (No App Server) TEST: WebFOCUS 7.1.3 on Win 2K/IIS 6/Weblogic 8.1/Servlet Mode | |||
|
| Expert |
shame 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?
| |||||
|
| Platinum Member |
Francis 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#4391088331 Production: 7.6.6 WF Server <=> 7.6.6 WF Client <=> 7.6.6 Dev Studio Testing: <none> Using MRE & BID. Connected to MS SQL Server 2005 Output Types: HTML, Excel, PDF | |||
|
| Member |
Thank 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. Vince | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicCopyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |