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     Trailing blank spaces issue in some data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Trailing blank spaces issue in some data
 Login/Join
 
arvind
Platinum Member
posted
hi friends ,

It me again with my silly questions.. Thank you for your patience .

In one of my reports , i am implementing cascading prompt in two listboxes Level 1 Business Capability , Level 2 Business Capability.

The issue is some data in Level 1 Business Capabiility has trailing blank spaces in the database , so when these values are selected , the match does not happen, that is the Where condition is not satisfied.

And the corresponding child values for Level 1 is not returned.

So , the listbox 2 remains empty whenever any value having trailing blank space is selected in listbox 1.

Now , this is what i have tried.
I tried the functions TRIM in define field for Level 1 Busines Capability column .
And used Truncate function for the parameter containing the values of listbox 1.


It is not working. Please advice . Am i missing something ??

Thank you very much


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
nubi
Guru
posted Hide Post
Arvind, what isn't working? the syntax? do you get an error message or results different to what you expect?


Developer Studio 7.64
Win XP
Output: mostly HTML, also Excel and PDF

"Never attribute to malice that which can be adequately explained by stupidity." - Heinlein's Razor
 
Posts: 285 | Location: UK | Registered: October 26, 2007Report This Post
Tony A
Expert
posted Hide Post
Arvind,

With the amount of problem solving techniques and other answers that you've been given by FP members over the weeks that you have been posting, one would think that you would have, by now, the basically ability to problem solve. Guess not Frowner

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
arvind
Platinum Member
posted Hide Post
hi tony and nubi ,

I have been breaking my head over this issue for the past 48 hours..Still need to figure out a way..

Nubi ,

The values in Listbox 1 - Analyze Sell , Analyze Buy have trailing blank spaces and they have corresponding child values which is to be populated in listbox 2 .

So , when i select one of the above values , the listbox 2 is not getting populated with their child values.

Reason being , the Where condition is not getting satisfied.

and i used TRIM function in WF to ignore trailing blank spaces . It wasnt working.

Please advice.


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
GinnyJakes
Expert
posted Hide Post
Have you considered using a program to populate your list boxes? That way, you could do the TRIM before the values are displayed as opposed to letting WebFOCUS construct the query to get the values.

See, for your 7.1.x release, page 5-68, Customizing Dynamic Parameters, in "Developing Reporting Applications with Graphical Tools" manual.


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
arvind
Platinum Member
posted Hide Post
hi ginny ,

Thanks for your reply,

Yes i tried populating the listbox using the Type FEX , but i am not able to implement cascading prompt in those two listboxes.

One more thing is both the columns used for populating the listboxes contain Null Values.

WF interprets NULL Values as 'blank' so a blank space appears in the listbox which is an indication that it is a NULL value.


My users want to see that NULL Values in the listbox i dont know why for pete's sake :O...

So when i do the TRIM function for the two columns, the blank representing NULL Value gets deleted .

I am totally confused what to do Frowner

Thank you for your patience
I know i am testing it


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report 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     Trailing blank spaces issue in some data

Copyright © 1996-2020 Information Builders