Data View: how to follow lookup field link to document?

Hello

My scenario: I'm on Sharepoint 2007 Portal Server. I have a custom
list, HRPolicy. In this list there is a lookup field - policy - that
lets the user select a document from a document library, HRPolicies.
On a page I have added a Data View Web Part to show the information
from the list HRPolicy. By default the value of the field policy is
formated as text only. I would like to have it as a hyperlink that
displays the document when click, exactly as if you were to add a list
directly as a web part. How can this be accomplished?

I have tried to use the ddwrt:URLLookup using the GUID of the list,
the field and the ID, but this doesn't work. In details I have the
exact same problem as this guy:
http://www.eggheadcafe.com/software/aspnet/29871868/data-form-web-part-ddwrt.aspx
Seems that this worked on Sharepoint 2003, but not 2007.

I would guess that it is really simply procedure, but somehow I cannot
figure out how to get it done. I currently only have the name of the
document, in the policy lookup field. If I could get the ID I could
make the link by going
http://server/HRPolicies/Forms/DispForm.aspx?ID={@ID}&RootFolder=*
(where {@ID} would be the ID, but I do not know how to get this.

Anybody? Thanks a lot!

Mike
Fri Aug 03 05:14:53 CDT 2007

This newsgroup is unfortunately not for MOSS 2007 questions (I presume
you mean MOSS 2007 by "SharePoint 2007 Portal Server" which is a
non-existent product).

This newsgroup is for people who have installed the WSS 2.0 product or
the WSS 3.0 product.

Please post MOSS 2007 questions either to the old SPS newsgroup
microsoft.public.sharepoint.portalserver

OR to the appropriate one of the new newsgroups for all SP products.

In this case (Data View Web Part question) that would mean
microsoft.public.sharepoint.design_and_customization as that deals with
SPD 2007 questions.


Mike Walsh
WSS FAQ http://www.wssfaq.com
no questions by e-mail please



rgrunnet@gmail.com wrote:
> Hello
>
> My scenario: I'm on Sharepoint 2007 Portal Server. I have a custom
> list, HRPolicy. In this list there is a lookup field - policy - that
> lets the user select a document from a document library, HRPolicies.
> On a page I have added a Data View Web Part to show the information
> from the list HRPolicy. By default the value of the field policy is
> formated as text only. I would like to have it as a hyperlink that
> displays the document when click, exactly as if you were to add a list
> directly as a web part. How can this be accomplished?
>
> I have tried to use the ddwrt:URLLookup using the GUID of the list,
> the field and the ID, but this doesn't work. In details I have the
> exact same problem as this guy:
> http://www.eggheadcafe.com/software/aspnet/29871868/data-form-web-part-ddwrt.aspx
> Seems that this worked on Sharepoint 2003, but not 2007.
>
> I would guess that it is really simply procedure, but somehow I cannot
> figure out how to get it done. I currently only have the name of the
> document, in the policy lookup field. If I could get the ID I could
> make the link by going
> http://server/HRPolicies/Forms/DispForm.aspx?ID={@ID}&RootFolder=*
> (where {@ID} would be the ID, but I do not know how to get this.
>
> Anybody? Thanks a lot!
>

rgrunnet
Fri Aug 03 06:18:59 CDT 2007

On Aug 3, 12:14 pm, Mike Walsh <englantilai...@hotmail.com> wrote:
> This newsgroup is unfortunately not for MOSS 2007 questions (I presume
> you mean MOSS 2007 by "SharePoint 2007 Portal Server" which is a
> non-existent product).
>
> This newsgroup is for people who have installed the WSS 2.0 product or
> the WSS 3.0 product.
>
> Please post MOSS 2007 questions either to the old SPS newsgroup
> microsoft.public.sharepoint.portalserver
>
> OR to the appropriate one of the new newsgroups for all SP products.
>
> In this case (Data View Web Part question) that would mean
> microsoft.public.sharepoint.design_and_customization as that deals with
> SPD 2007 questions.
>
> Mike Walsh
> WSS FAQhttp://www.wssfaq.com
> no questions by e-mail please
>
> rgrun...@gmail.com wrote:
> > Hello
>
> > My scenario: I'm on Sharepoint 2007 Portal Server. I have a custom
> > list, HRPolicy. In this list there is a lookup field - policy - that
> > lets the user select a document from a document library, HRPolicies.
> > On a page I have added a Data View Web Part to show the information
> > from the list HRPolicy. By default the value of the field policy is
> > formated as text only. I would like to have it as a hyperlink that
> > displays the document when click, exactly as if you were to add a list
> > directly as a web part. How can this be accomplished?
>
> > I have tried to use the ddwrt:URLLookup using the GUID of the list,
> > the field and the ID, but this doesn't work. In details I have the
> > exact same problem as this guy:
> >http://www.eggheadcafe.com/software/aspnet/29871868/data-form-web-par...
> > Seems that this worked on Sharepoint 2003, but not 2007.
>
> > I would guess that it is really simply procedure, but somehow I cannot
> > figure out how to get it done. I currently only have the name of the
> > document, in the policy lookup field. If I could get the ID I could
> > make the link by going
> >http://server/HRPolicies/Forms/DispForm.aspx?ID={@ID}&RootFolder=*
> > (where {@ID} would be the ID, but I do not know how to get this.
>
> > Anybody? Thanks a lot!

Sorry about that. Here is the link to the new post I made, should
anybody be interested:
http://groups.google.com/group/microsoft.public.sharepoint.design_and_customization/browse_thread/thread/45fc91563bfacac1/97e46178cdc02912#97e46178cdc02912

Cheers,
Rasmus