Fields COUNTDISTINCT problem
Dear Sir, I'd using field expression CountDistinct(fields!Filename.Value), I'v one problem, countdistinct() not consider empty spaces in fields, have four rows in fields 020 020 020 <--Here i'd gave enter to insert data base and this row LEN is 5 my CountDistinct(Fields!Filename.value) Result is show CountDistinct is 2 but need Result is 1 How to solve? Please Help me
October 27th, 2012 2:50am

Not sure I understand our requirement. Are you saying that you want to ignore the spaces in the countdistinct> If so, then try =CountDistinct(Trim(Fields!FileName.Value))Please Mark posts as answers or helpful so that others can more easily find the answers they seek.
Free Windows Admin Tool Kit Click here and download it now
October 27th, 2012 9:30am

Not sure I understand our requirement. Are you saying that you want to ignore the spaces in the countdistinct> If so, then try =CountDistinct(Trim(Fields!FileName.Value))Please Mark posts as answers or helpful so that others can more easily find the answers they seek.
October 27th, 2012 9:30am

Not sure I understand our requirement. Are you saying that you want to ignore the spaces in the countdistinct> If so, then try =CountDistinct(Trim(Fields!FileName.Value))Please Mark posts as answers or helpful so that others can more easily find the answers they seek.
Free Windows Admin Tool Kit Click here and download it now
October 27th, 2012 9:30am

Not sure I understand our requirement. Are you saying that you want to ignore the spaces in the countdistinct> If so, then try =CountDistinct(Trim(Fields!FileName.Value))Please Mark posts as answers or helpful so that others can more easily find the answers they seek.
October 27th, 2012 9:30am

Thank you very much,it's very helpful
Free Windows Admin Tool Kit Click here and download it now
October 30th, 2012 1:09am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics