locked
how to get report by two list in MOSS RRS feed

  • Question

  • Hi,

    How to get report by two or three list combined and how to show report with look up filed relation between tow list.


    Hasan Jamal Siddiqui(MCTS),Share Point Application Developer,TCS

    Wednesday, May 2, 2012 9:50 AM

Answers

  • You can achieve this in MOSS 2007 by using Data Views in SharePoint Designer.  Please refer here for more details - http://blah.winsmarts.com/2007-10-performing_joins_between_sharepoint_lists.aspx
    Thursday, May 3, 2012 1:08 PM
  • Hi ,

    Thx for link.

    Please check this link alo...http://www.dlocc.com/articles/how-to-link-two-lists-and-display-the-data-using-the-sharepoint-data-view/

    I have already applied this methode but unable to fetch data cording lookup relation.

    can you explain me Step 7,8,9.

    7. Now from the "Data Source Details" pane, select Customers.Title. and choose - Insert Selected Field as "Multiple Item View" as shown below:

    Your ASPX should look like this -

    8. Now place the cursor in front a particular value - Say "Scot Hillier", and now in the Data Source Details Pane, Select Orders --> Title, and choose to insert as "Joined SubView" in the menu shown below:

    Specify Join information as shown below:

    9.   Thats it! Format it a little bit, run the ASPX - looks like this -

    Becuse on 7 8 and 9 i have little bit confused.result will not found approperate manner.


    Hasan Jamal Siddiqui(MCTS),Share Point Application Developer,TCS


    Friday, May 4, 2012 6:12 AM

All replies

  • You can achieve this in MOSS 2007 by using Data Views in SharePoint Designer.  Please refer here for more details - http://blah.winsmarts.com/2007-10-performing_joins_between_sharepoint_lists.aspx
    Thursday, May 3, 2012 1:08 PM
  • Hi ,

    Thx for link.

    Please check this link alo...http://www.dlocc.com/articles/how-to-link-two-lists-and-display-the-data-using-the-sharepoint-data-view/

    I have already applied this methode but unable to fetch data cording lookup relation.

    can you explain me Step 7,8,9.

    7. Now from the "Data Source Details" pane, select Customers.Title. and choose - Insert Selected Field as "Multiple Item View" as shown below:

    Your ASPX should look like this -

    8. Now place the cursor in front a particular value - Say "Scot Hillier", and now in the Data Source Details Pane, Select Orders --> Title, and choose to insert as "Joined SubView" in the menu shown below:

    Specify Join information as shown below:

    9.   Thats it! Format it a little bit, run the ASPX - looks like this -

    Becuse on 7 8 and 9 i have little bit confused.result will not found approperate manner.


    Hasan Jamal Siddiqui(MCTS),Share Point Application Developer,TCS


    Friday, May 4, 2012 6:12 AM
  • Hi Sephiroth0327,

    I have using  URL which one prvide by you   but what i get when i drad as multiple item data will come only from first list not come data from second list.


    Hasan Jamal Siddiqui(MCTS),Share Point Application Developer,TCS

    Friday, May 4, 2012 7:03 AM
  • Have you correctly carried out steps 5 and 6 from the tutorial, this is what links your 2 lists to provide 1 combined datasource.

    Paul Turner http://redmanta.co.uk/blog Twitter: @RedMantaUK MCTS:WSS,MOSS,2010 MCITP:2010.
    Please remember to click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

    Friday, May 4, 2012 7:39 AM
  • Hi,

    Yes it has been done.

    becuse after multiple item drag i was unable to see join but when i clik on item fildes on that time i can easly see join and sub join

    so now solve my problem.

    Thx for coopration


    Hasan Jamal Siddiqui(MCTS),Share Point Application Developer,TCS

    Friday, May 4, 2012 9:11 AM