Im not sure if i am using the right tool to try to acheive what i want but here goes.
I have an SQL Database that i would like to retrieve some data from the table has lots of columns but i am only interested in two Quote Number And Quote Date.
What i would like to be able to do is display in sharepoint the number of quotes that have been generated over the months for the past 2 years.
i thought that to be able to do this i would use Dashboard Designer but i am struggling and i am not shure if this is the right tool to use. The quote number is purley just a number ie: 12345 and the date is in the following formay 01/01/10, so i would like
to be able to group all of the quotes generated in a particular month to show the total.
Is this possible in Dashboard Designer or would i have to sort the data out first via another method.
If someone could point me in the right direction i would be most gratefull.
View Complete Post