Results 1 to 4 of 4
  1. #1
    Shido151 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2012
    Posts
    16

    Creating a Searchable Web Report for Sharepoint

    Does anyone have a link to a tutorial on how to create a searchable Web Report that can go into Sharepoint?



    I did have my reports based off a queries with a parameter in them.

    i.e. Like [Enter Manager Name] & "*"

    Parameter: [Enter Manager Name]

    then when the report ran off the query, the "Enter Manager Name" prompt came up and everything worked.

    However Sharepoint is not letting the parameters upload so I had to strip them out. Does anyone know how to create a Sharepoint compatible report that can be filtered, or customized, or searchable or manipulated or.... whichever verb you choose to describe it with?

    Sidenote; I have all my reports pop up in dialogue view so that they are printable. Thanks for your time.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Do input parameter prompts work with web forms?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Shido151 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2012
    Posts
    16
    I know when I put them in Web Reports (or create a web report that is dirived from a prompt query) the web compability checker shows no errors. It's jsut when I upload to Sharepoint that it says the parameters are not sharepoint compatible.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I don't have experience with SharePoint so can't say what it can handle. Have you tried this with forms uploaded to SharePoint?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Simple Searchable Form
    By glennib in forum Forms
    Replies: 3
    Last Post: 07-11-2013, 09:56 AM
  2. How to create a searchable database?
    By BobCarolgees in forum Access
    Replies: 3
    Last Post: 10-10-2012, 01:48 PM
  3. Print report from searchable form
    By Fauzi in forum Access
    Replies: 1
    Last Post: 01-24-2012, 04:26 PM
  4. Upload Report to SharePoint Library
    By Lorlai in forum SharePoint
    Replies: 2
    Last Post: 09-22-2011, 01:39 PM
  5. Replies: 1
    Last Post: 08-14-2009, 03:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums