BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Values with Comma is not passing in Xcelsius


 
Search this topic... | Search Xcelsius - Crystal Dashboard Design... | Search Box
Register or Login to Post    Forum Index -> Other Products -> Xcelsius - Crystal Dashboard Design  Previous TopicPrint TopicNext Topic
Author Message
Philip
Forum Associate
Forum Associate



Joined: 02 Mar 2006

Posts: 587
Location: USA



PostPosted: Mon Jul 08, 2019 11:40 am 
Post subject: Values with Comma is not passing in Xcelsius

Hi All,
I had created a Xcelsius dashboard (in BO 4.2 SP7) using Qaaws query. I had added couple of Combo box on this dashboard. One of the Combo box is Employee Name which format is as below (First Name, comma Last Name) and when a value is selected Data is NOT refreshing (displaying Blank dashboard)
Employee Name:
Robin, Sen------Note After Robin there is a comma(,) creating an issue.
Evelyn, Carter---Note After Evelyn there is a comma (,) creating an issue.
Alexandria, Carter---Note After Alexandria there is a comma (,) creating an issue

Any help will be highly appreciate.
Back to top
Debbie
Forum Addict
Forum Addict



Joined: 01 Mar 2005

Posts: 2778
Location: Cheshire, England


flag
PostPosted: Tue Jul 09, 2019 8:25 am 
Post subject: Re: Values with Comma is not passing in Xcelsius

I don't use QAAWS - I get my data via raw SQL database queries as XML. But even so, Xcelsius doesn't process punctuation well, so I remove it all at query level and if necessary add it back in later.

If I can get away with a space in the end result, I'll just replace the comma with a space and leave. If I need the comma in the dashboard, I'll replace with a capital X or similar in the query and then replace back with a comma in the dashboard.

Debbie
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Other Products -> Xcelsius - Crystal Dashboard Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0284 seconds using 18 queries. (SQL 0.0042 Parse 0.0008 Other 0.0233)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo