Color and Font style to Expression

[#1]

Hi,

I have sum(Amounts) column as a Expression. My requirement is,

if sum(Amounts) has negative value , that negative value should be Red Color and that negative value in brackets like ( ).

How can i achieve this, could you please tell me Set expression and process

Thanks,

MLNR

[PrashantSangle]

Hi,

Can you explain little bit more?

What is relation of sorting and input box.

Regards

[#3]

Hi,

I have straight and pivot table, in that i need to display Top N custno based on open amounts. and this openamount should be descending order. For this i created one variable , that variable passed to input box. By that input box i controlled those charts. Now in the same way i want to display all records.

How can i achieve.

Thanks

MLNR

[#4]

Hi,

To control the Top Records to be listed using Input Box. and along with that if user wants to display all the records.

what is process for that.

Thanks,

MLNR

[sasikanth]

hi

Create a seperate buttom for that and then give action to set a varible(input box varible)

set that to max number of records , so that it will display all the records

[#6]

Hi,

Thank you very much for your reply.

Can you tell me the steps to achieve this.

Explain more with Navigation.

Thanks,

MLNR

[sasikanth]

create a variable for input box

suppose var1

then create a button add --> properties-->action-->set varible -->give variable name as var1-->

var value as count(ID)  ( you can write pre-defined number also if you know the records like if 1000 are there then you can set to 10000) --> ok

give what ever you want in input box and then click the button if you want total reocrds

hope it helps you,

let me know if not