sql server reporting services:
How can I count the rows in wich a specific word occurs in a field in the
detail row of a report?

Thanks

There are at least two approaches that come to my mind.

1. Add a caculated field to your dataset that calls a custom VB function
(either embedded in the report or external) which counts the words per row.
Then use the Sum() function to get the overall total.

2. Add a class-level variable to the report embedded code that keeps a
running total. Call a VB function from the field that needs to be counted.

HTH
--
-----------------------------------------------------
Teo Lachev, MVP, MCSD, MCT
Home page and blog: http://www.prologika.com/
-----------------------------------------------------

[quoted text, click to view]