求助：RDLC中报表公式

[v鼠来宝v]

流水号|城市|标题|发生时间|确认人|确认时间|清除人|清除时间
001|cityA|titleA|2007-01-21 00:00:00|manA|2007-01-21 00:01:00|manD|2007-01-21 00:01:00
002|cityA|titleB|2007-01-22 00:00:00|manA|2007-01-22 00:02:00|manA|2007-01-22 00:02:00
003|cityA|titleC|2007-01-23 00:00:00|manB|2007-01-23 00:03:00|manB|2007-01-23 00:03:00
004|cityA|titleD|2007-01-24 00:00:00|manB|2007-01-24 00:04:00|manB|2007-01-24 00:04:00
005|cityA|titleE|2007-01-25 00:00:00|manC|2007-01-25 00:00:10|manC|2007-01-25 00:00:10
006|cityB|titleA|2007-01-26 00:00:00|manD|2007-01-26 00:00:20|manD|2007-01-26 00:00:20
007|cityB|titleB|2007-02-26 00:00:00|manA|2007-02-26 00:00:30|manA|2007-02-26 00:00:30
008|cityB|titleC|2007-02-26 00:00:00|manB|2007-02-26 00:00:40|manB|2007-02-26 00:00:40
009|cityB|titleD|2007-02-26 00:00:00|manB|2007-02-26 01:00:00|manB|2007-02-26 01:00:00
010|cityB|titleA|2007-03-26 00:00:00|manC|2007-03-26 02:00:00|manC|2007-03-26 02:00:00
011|cityB|titleF|2007-03-26 00:00:00|manD|2007-03-26 03:00:00|manD|2007-03-26 03:00:00
012|cityA|titleA|2007-03-26 00:00:00|manA|2007-03-26 04:00:00|manB|2007-03-26 04:00:00
013|cityA|titleB|2007-04-26 00:00:00|manB|2007-04-26 00:00:02|manD|2007-04-26 00:00:02
014|cityA|titleC|2007-05-26 00:00:00|manB|2007-05-26 00:00:03|manA|2007-05-26 00:00:03
015|cityA|titleD|2007-05-26 00:00:00|manC|2007-05-26 00:00:04|manB|2007-05-26 00:00:04
016|cityA|titleE|2007-06-26 00:00:00|manD|2007-06-26 00:01:10|manB|2007-06-26 00:01:10
017|cityA|titleA|2007-06-26 00:00:00|manA|2007-06-26 00:01:20|manC|2007-06-26 00:01:20
018|cityA|titleB|2007-07-26 00:00:00|manB|2007-07-26 00:01:03|manD|2007-07-26 00:01:03
019|cityA|titleC|2007-07-26 00:00:00|manB|2007-07-26 01:01:01|manA|2007-07-26 01:01:01
020|cityA|titleD|2007-07-26 00:00:00|manC|2007-07-26 01:02:02|manB|2007-07-26 01:02:02
021|cityA|titleA|2007-08-26 00:00:00|manD|2007-08-26 02:01:01|manB|2007-08-26 02:01:01
022|cityA|titleF|2007-08-26 00:00:00|manA|2007-08-26 01:02:03|manC|2007-08-26 01:02:03
023|cityA|titleF|2007-09-26 00:00:00|manB|2007-09-26 00:01:00|manD|2007-09-26 00:01:00
024|cityA|titleC|2007-08-26 00:00:00|manB|2007-08-26 00:02:00|manD|2007-08-26 00:02:00
025|cityA|titleD|2007-07-26 00:00:00|manC|2007-07-26 00:01:00|manB|2007-07-26 00:01:00
026|cityA|titleE|2007-05-26 00:00:00|manD|2007-05-26 00:03:00|manB|2007-05-26 00:03:00
027|cityA|titleA|2007-07-26 00:00:00|manA|2007-07-26 00:04:00|manC|2007-07-26 00:04:00
028|cityA|titleB|2007-08-26 00:00:00|manA|2007-08-26 00:01:00|manD|2007-08-26 00:01:00
029|cityA|titleC|2007-09-26 00:00:00|manA|2007-09-26 00:30:00|manB|2007-09-26 00:30:00

确认率（确认次数/本城市发生信息所有条数）
城市 确认人

其中，本程序发生信息总条数不会写公式

[v鼠来宝v]

---------------------------------
| manA | 确认率1 |
--------------------------
cityA | manB | 确认率2 |
--------------------------
| manC | 确认率3 |
--------------------------
| manD | 确认率4 |
---------------------------------
| manA | 确认率1 |
--------------------------
cityB | manB | 确认率2 |
--------------------------
| manC | 确认率3 |
--------------------------
| manD | 确认率4 |
---------------------------------

[tshark]

总条数的公式是 =Count(Fields!流水号.Value).ToString()

[lxmfll2000]

提供一下思路，你可以在数据源里直接定义好。这样就有字段了。可以在报表设计的时候直接使用了。
也就是说你的SQL语句里把他Count(*)出来。