Skip to Content
author's profile photo Former Member
Former Member

Select Expert Issue

Hi i am facing problems with section expert.

Please suggest me a formula to get requred data based on country.

i have a table like this and having a parameter for country.

Country label value

India User User

india Date Date

uk User impôt

uk Date série

if i selected country=india then labels are

User Date

if country=uk then

impôt série

I have a parameter for country.

i created 2 formulas for user and date like this.

if phrase.country={?country} and phrase.label="User" then phrase.value

if phrase.country={?country} and phrase.label="Date" then phrase.value

if i drag this formulas to detail section ,but it is displaying blank fields like this.

User Blankfield

Blankfield Blankfield

Blankfield Date

Blankfield Blankfield

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 12, 2012 at 07:39 AM

    Hi Divya,

    You are getting the blanks because your report is still evaluating the records for UK.

    In your Record Selection Formula try this:

    {phrase.country} ={?country};

    Good luck,

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Prathamesh excuse me for asking the question again

      I am unable find the solution. my requirement is to achieve localization using database.

      For this i created a table in the database called phrase(contains 300 rows) like this.

      i need to change labels based on language selected.

      Country label value

      India User User

      india Date Date

      uk User impôt

      uk Date série

      My requirement is i need to display labels based on country like this.

      if i selected country=india then labels are

      User Date

      if country=uk then

      impôt série

      I have a parameter for country.

      i created 2 formulas for user and date like this.

      if phrase.country={?country} and phrase.label="User" then phrase.value

      if phrase.country={?country} and phrase.label="Date" then phrase.value

      If i drag this 2 formulas to detail section in report then if i select country=india then it is giving correct value but giving 3 blank spaces for other 3 values of label column .i.e it is taking all the data from the database table and showing blank spaces for that other values.how to restrict this

      Is there any other formula to achieve this.

      The data is coming like this

      User Blankfield

      Blankfield Blankfield

      Blankfield Date

      Blankfield Blankfield

      I need to display only corresponding value based on country .please solve this

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.