select field without listbox

[#1]

Hello

If i wanna make a textbox which shows me the count of an status from a field how would i do so??

example

I have:

START

PROGRESS

DONE

All theses are connected to a company, so i make a count on company and get this:

START 5

PROGRESS 2

DONE 9

How can i then make a text box which shows me the TEXT and the COUNT, BUT without a selection in a listbox, for EACH ??

[datanibbler]

Hi,

if I understand your requirement correctly - you can get the count using the >getselectedcount(fieldname)< function and concatenate it to eigher a static text or the contents of a text field using the &.

If any selection is necessary for that, you can include a filter into your expression, enclose it in brackets like {<field=value>}

HTH

Best regards,

DataNibbler

[#3 · Accepted solution]

Try to add three textboxes with the formulas:

=count({1 <status={'START'}>} company)

=count({1 <status={'PROGRESS'}>} company)

=count({1 <status={'DONE'}>} company)

[er_mohit]

try this in text object

='START' &Aggr(COUNT(START),Company)

lly, for rest of 2.

hope it helps

[sushil353]

assign your expression to a variable.

use that variable in the text box to show the result of variable.

make sure while assigning the expression to the variable put = sign and use set analysis to get rid of selection effect

like {1}

HTH

Sushil

[sushil353]

assign your expression to a variable.

use that variable in the text box to show the result of variable.

make sure while assigning the expression to the variable put = sign and use set analysis to get rid of selection effect

like {1}

HTH

Sushil

[#7]

HI

try this , hope this helps you

= aggr('START  ' & Count(START) & '   PROGRESS   ' & Count(PROGRESS)  &'   DONE  ' & Count(DONE), company)

[#8]

no one ???

Or is there a smarter way to do it??

[manishnarang]

Let it be in list box, just

1. Remove the caption

2. Make it read-only (Properties -> General - > select read-only)

is this what you expecting?

[#10]

1. What sould the expression be like? cause i cant get it to work