Range of values

[#1]

Hi,

I have a table with

user names and Age

and i wish to have on my multibox a range of ages instead of the way it shows now (see attached file)

anyhow, is there a why to add a value range or do i need to add a new table etc.?

(I am working with sql server and not excel sheets)

10x a million.

Yaya

[its_anandrjs]

Hi,

Create a age bucket and use it in multibox

Rgds

Anand

[#3]

how can i create that?

[its_anandrjs]

Hi,

If you load your age field as autogenerate like and connect it with your date field

set MinAge = 1;

set MaxAge = 100;

Age:

LOAD $(MinAge)+recno()-1 as Age

AUTOGENERATE $(MaxAge)-$(MinAge)+1;

Rgds

Anand

[its_anandrjs]

Hi,

See the attached sampl file i suggest you have to use some thing like that,

And if any field there is no data then it shows "-" this symbol in this case so use Suppress When Value is Null.

Load some thing like this

set MinAge = 1;

set MaxAge = 100;

Age:

LOAD $(MinAge)+recno()-1 as Age

AUTOGENERATE $(MaxAge)-$(MinAge)+1;

Data:

load * inline

[

Age,Name

24,Ajay

45,Neil

12,Sanjay

17,Prakash

1,Vijay

48,Sanjay

24,Jeeven

];

Let me know about that.

Rgds

Anand

[SunilChauhan]

in multi box inpace of age

you can write

class(Age,n)        ,

n will any thing you want

if u want at interval of 5

class(Age,5)

1-5,5-10,10-15  and so on

or else you can use if condition like

if (age>=1 and age<=5,'1-5',if(age>5 and age<10,'5-10') and so on...

thanks

Sunil Chauhan