all data

[sagarrahul]

hiii community

i am having problem in getting data of all clm_no at a time

these are my fields

clm_no

name

end_date

city

now i want all

these are my clm_no

eg :

1234

4569

1456

1452

i wnat all data of field

how can i get it

[tresB]

Where do you want that? If you create a list box for that field, you get all of them.

[sagarrahul]

i have created a straight table

in that want that

i am doing by taking one and sellting one by one

but i want all a time using clm_no

[tresB]

What are your dimension and expression?

[sagarrahul]

dimension are

clm_no

name

end_date

city

and expression i have kept 1

[Anil_Babu_Samineni]

I am not sure really, What are you trying to achieve. Would you let me know what is target Straight Table. Please provide sample input and Expected O/P

Why not simple, Count(nodistinct clm_no)

[sagarrahul]

i only  want this clm_no

12345

1256

1568

12587

[Anil_Babu_Samineni]

Then Why not this?

If(WildMatch(clm_no,'12345','1256','1568','12587')) as clm_no

OR

Count({<clm_no = {'12345','1256','1568','12587'} >} Target)

[sagarrahul]

in dimension or in expression

[Anil_Babu_Samineni]

Use Dimension if required, I really don't now what are you trying to acheive Can you please share the sample