Problem with showing data based on data entry (input box)

[#1]

Hi i have a question,

i want to show the data based on user entry, i want to show all data if user doesnt input any data. When user input the data, it will show the data based on the entry.

I'm using this expression

if($(=len(percenFrom))=0 or $(=len(percenTo))=0,'A', 'B')

it works perfectly, but when i change the result A and B to another 'if condition' it doesnt show any data when im not enter the data. but when i enter the data it works perfectly.

Really appreciate your help, thanks

[#2]

Dear Sasidhar,

Hi, i have try both condition, both statement return value perfectly.

Really confuse about it

[sasiparupudi1]

try changing the if condition

if(len('$(percenFrom)')=0 or len('$(percenTo)')=0,'A', 'B')

if that does not work, just hardcode the values and see if the if condition works fine

hth

Sasi

[Kushal_Chawda]

try this,

if(len(trim(percenFrom))=0 or len(trim(percenTo))=0,

  if(Len(Trim($(vYear))) = 0 and Len(Trim($(vWeek))) = 0,

  Sum({$<TRX={1}>} QTY),

  Sum({$<TRX={1}, YearWeek={"$(vWeek)"}>} QTY)),

  if(Len(Trim($(vWeek))) = 0,

  Sum({$<TRX={121}, Year={"$(vYear)"}>} QTY)  ,

  Sum({$<TRX={121}, YearWeek={"$(vWeek)"}, Year={"$(vYear)"}>} QTY)))

[#5]

Hi Sasidhar,

sorry for late reply,  i've changed the if condition, but still not working.

do you have any idea ?

thanks

[#6]

Hi Kush,

Sorry for late reply,

i've try your suggestion, but still not working,

do you have any idea ?

thanks