网格视图摘要报告 [英] Grid View Summary Report

问题描述

我正在使用vb.net与visual studio 2005和sqlserver 2000

我有一个名为gb1的网格视图

有四个字体A，B，C， D

，其值类似于

I am using vb.net with visual studio 2005 and sqlserver 2000
I have a grid view named as gb1
WHICH HAS FOUR COLOUMNS A,B,C,D
and has the value like

A        B       C       D
1.0	2.0		1.0
2.0	1.0		3.0
-		2.0	

我想找个概要



LIKE



1.0 OCCURS = 3次

2.0 OCCURS = 3次

3.0 OCCURS = 1次





i找不到本摘要的逻辑。

请帮我解决这个问题。

I WANT TO FIND A SUMMARY

LIKE

1.0 OCCURS =3 TIMES
2.0 OCCURS =3 TIMES
3.0 OCCURS =1 TIMES


i don''t find the logic of this summary .
Please Help me regarding this condition.

推荐答案

这种方式...

this way...

select val,count(*) as Occurance from
(
    select a as Val from tblnm   _
    union all                     |
    select b from tblnm           |
    union all                      > this will get col a,b,c,d & then using union all merge all cols
    select c from tblnm           |
    union all                     |
    select d from tblnm          _|
) as t
group by val --here it grouped by val 

快乐编码！

：）

Happy Coding!
:)

这篇关于网格视图摘要报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！