Counting And Displaying Groups

Lets suppose I have a db which looks like:
District        Fund
VAE            A
VAW           A
VAE            B
DC              C
DC              A
NYS            B
MD             C
VAW           A

I would like a query which displays the following dynamically.   I don't know each unique member of the Fund field, they could be added by the end user. It might include M,J,S etc. I need the columns dynamically created.  I can do it statically if I know the distinct members of fund.  I would like to be able to do it dynamically. Any ideas?  The static version with multiple queries is at the end.
District     Total       A         B      C
VAE            2         1         1            
VAW           2         2         
DC              3         2                  1 
NYS            1                    1                          
MD              1                            1      

Query Name =GroupByDist
SELECT     district, COUNT(district) AS dcount
FROM         dbo.mydb
GROUP BY district

Query Name=DCountA
SELECT     district, COUNT(district) AS dcount
FROM         dbo.mydb
WHERE     (fund = N'A')
GROUP BY district   

Query Name=DCountB
SELECT     district, COUNT(district) AS dcount
FROM         dbo.mydb
WHERE     (fund = N'B')
GROUP BY district    

Query Name=DCountC
SELECT     district, COUNT(district) AS dcount
FROM         dbo.mydb
WHERE     (fund = N'C')
GROUP BY district     

SELECT GroupByDist.district, GroupByDist.dcount AS Total, DCountA.dcount AS A, DCountB.dcount AS B, DCountC.dcount AS C 
From    GroupByDist LEFT OUTER JOIN
                      DCountC ON GroupByDist.district = DCountC.district LEFT OUTER JOIN
                      DCountB ON GroupByDist.district = DCountB.district LEFT OUTER JOIN
                      DCountA ON GroupByDist.district = DCountA.district