Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Data View WebPart Help

  Asked By: Elvis    Date: Jul 19    Category: Sharepoint    Views: 948

I have been searching the web for days looking for a solution to a
problem I am having with a DataView WebPart(DVWP). I am hoping maybe
you can help. I will try to explain this as best as I can.

I am creating a webpart that will read from a View on my SQL Server. I
need to limit what each user sees to only their own records, I have a
field for the users login which is what I am trying to filter
by "Current User".

I have created this DVWP, connected it to the SQL Server and the view.
I am using Single Sign-On through SharePoint to connect to the View,
set up as a group with the permissions set as owner rights. I have
tried to filter it in FrontPage by [Current User] which gives me no
data return. If I filter by a specific login it displays correctly the
information for that user. Or if I remove the filter it shows
everything. So I am lead to believe I am not filtering correctly.



2 Answers Found

Answer #1    Answered By: Alphonso Mckay     Answered On: Jul 19

What if you call a stored procedure, passing the user  identifier as a parameter? Rather that trying to get the DVWP to filter  records, use the database. This would make the DVWP much simpler.

Answer #2    Answered By: Daron Oneill     Answered On: Jul 19

I tried doing this in the view
without success. I'll give this a try.

Didn't find what you were looking for? Find more on Data View WebPart Help Or get search suggestion and latest updates.