Formula help

[tttggg]

Can Any one help me this Issue,
I have a parameter which selects the number of rows to display in the report.the parameter type is string because of the key word ALL (To select all the rows)
When the user select all Rows i have the following error
"The String is non numeric"
the formula I'm using here is {#Rows}> ToNumber({?Limit})
I'm using this formula is the detail section since,if user select 10 then i want only 10 rows to be displayed on each group.
My concern is even though I'm converting the string to number why I'm getting this error, Am i missing something here?
CR X1, Databaseostgres

Thanks

 

[lbass]

Change your suppression formula to:

{?Limit} <> "All" and
{#Rows} > ToNumber({?Limit})

-LB

 

[tttggg]

thanks lbass
it works fine in the detail section, but when i tryed in the chart topN i have the following error
"a constant expression is required here"
if i use ToNumber{#Rows} then it says
"The String is non numeric"
If yo have time could you tell me what is wrong with ToNumber{#Rows}, so that i can try to debug.

Appreciate you help here.

 

[lbass]

WHAT chart? You should lay out your plans in your first post.

Use topN in both the main report and the chart. For your parameter (set it up as a number), set up some numbers and use a very large number instead of "All", and then add a description field if you want to show "All". Or you could instruct the user to choose 1000000 if they want to see all records.

-LB

 

[tttggg]

That's what i planing to do.
I though there may be a better way to do that.
Thanks