MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

"How to set a parameter for getting distinct values of sharepoint

  Asked By: Madhu    Date: Apr 10    Category: MOSS    Views: 2139

I am using MOSS 2007. I have integrated a sharepoint list to SQL server 2008
using the below reference

It works fine for me and it is displaying all the columns of list. In my
list, I have two columns i.e Region (RG1,RG2,RG3,RG4,RG5....) and sales type.I
wanted to display the respective values of these 2 columns on SQL chart. I
wanted to set a parameter for Region column so whenever end user wants to see
the sales type for a particular region, he can select that region and can see
the respective record of sales type. I tried to create a Region parameter.But it
is giving me all the repeatative values in the drop-down box. I wanted to
display only distinct values. I have basic idea that we have to create a
separate dataset for this but the data is coming from sharepoint list using xml
query and i don't have that much knowledge of this. So anyone can help me out
with this?



No Answers Found. Be the First, To Post Answer.