Focal Point Banner


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
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Place Default text at bottom in Active Acordian Report.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Place Default text at bottom in Active Acordian Report.
 Login/Join
 
<B_B>
posted
Hi,
I am getting extra stuff at the top while using Active Accordian Report.Is there any way where i can place the text "22 of 22 records (100%), Page 1 of 1" at the bottom by default?

Secondly, in my report i need to wrap text as it is too long.How do i wrap the text?


TABLE FILE CAR
PRINT
MODEL
SEATS
BY COUNTRY
ON TABLE SET EXPANDABLE ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
END
 
Report This Post
Ranjana
Member
posted Hide Post
HI B_B,

Try this;

TABLE FILE CAR
PRINT
MODEL
SEATS
BY COUNTRY
ON TABLE SET EXPANDABLE ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
END

I have replaced AHTML to HTML. Is this what you needed.

For wraping, do you need to wrap data or static headings.
If data then you can give wrap = some_number, in the formatting
and if it is some static data then give a ',' after a word, it will come to the next line
ex:
Table file car
print
model as 'The car, model'
seats
ON TABLE SET ASNAMES ON
end


7.1.4
Windows XP
Excel, HTML, PDF



 
Posts: 26 | Registered: February 21, 2008Report This Post
<B_B>
posted
Hi Ranjana,

Thanks for your reply.
But, it did not seem to have worked out.

Thanks,
Bhavna
 
Report This Post
<Naak>
posted
Hi B_B,
Try this example. I think it ll give clear idea
about ur doubt.

TABLE FILE CAR
PRINT
MODEL AS 'The car FROM COUNTRY, model,NAAK,JACK'
SEATS
BY CAR
ON TABLE SET ASNAMES ON
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET EXPANDABLE ON
ON TABLE SET STYLE *
TYPE= TITLE, WRAP = 12, $
ENDSTYLE
END
 
Report This Post
<B_B>
posted
Hi Naak,

Thanks for your response.But, i need to wrap one of the columns in the Active Accordiaon report.The length would be around A100. This particular column needs to be wrapped to make the report look neater.

I tried using TYPE=REPORT,COLUMN=N7,WRAP=ON, $
But, it is not effective.

Please Suggest.

Thanks.
 
Report This Post
GinnyJakes
Expert
posted Hide Post
Didn't I answer this question the other day?

https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/7091006192


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Place Default text at bottom in Active Acordian Report.

Copyright © 1996-2020 Information Builders