can we assign caliculated column to value prompt?

[bvk.cognoise]

HI all,

can we assign calculated column to value prompt?
what i mean is i created a calculated column 'RANK'
can i show the "RANK" values in the value prompt?
please tell me the way to show  calculated column values in value prompt?

thanks in advance


vamsi

[Gopinath]

Yes we can. Assign the calculated column to the Display Value property of the value prompt

[bvk.cognoise]

thanks gopi for ur reply ,

yes we can assign calculated column to value prompt  i know that.but i want show the values of calculated column in value prompt.how can we do that?

thanks
vamsi

[Gopinath]

Vamsi,

When you assign a calculated column to the Display value property of a value prompt, it will show the values of calculated column in value prompt.

[bvk.cognoise]

gopi

i crated a value prompt.i assigned my calculated column to that prompt as display value.when  i run the report its showing only one value that is '1' but in that calculated column i have '100' values.its showing only one value.

[PRIT AMRIT]

Create a separate query and then create the calculated item in it.

Then assign the new query and calculated item to your value prompt.

Hope this should do?

Thanks
Prit

[bvk.cognoise]

sorry Prit still its not working.still its showing only one value.

[Gopinath]

check the Tabular data of your prompt query whether your calculated field display all 100 values