web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How can I use an SQL V...
Microsoft Dynamics GP (Archived)

How can I use an SQL View created with Excel Report Builder.

(0) ShareShare
ReportReport
Posted on by CP-Steve 285

Hi,

We are using SQL2005 with GP10 and I have created a view, granted SELECT access to DYNGRP (plus SELECT to all the rpt... groups), however, when I attempt to Add SQL Table to the new Excel Report (in Excel Report Builder), select the Views radio button option, I cannot find my new View in the list of views.

There must be a step or process that I need to do, to enable the custom view to be available for Excel Report Builder to use.  If one could help me to do so, I'd much appreciate it.

Thanks in advance.

Enjoy, Steve

*This post is locked for comments

I have the same question (0)
  • CP-Steve Profile Picture
    CP-Steve 285 on at

    Oh I know I know, pick me.

    Tools > SmartList Builder > Security > SQL Table Security

    Select Views, then tick the new Views you want availble to SmartList Builder.

    Cheers, Steve

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Congratulations, you are absolutely correct!!!!

     

    Yes, we have this information in our book Customizing GP with The Builders.  It covers Smartlist Builder, Excel Report Builder, Navigation List Builder as well as security and accessing outside tables, SQL views, et cetera.

     

  • CP-Steve Profile Picture
    CP-Steve 285 on at

    What's this "our book", I can only find your name on it?

    Thanks for the heads up, I have forwarded the details onto my boss, thus hopefully your sales may increase by one soon. I have experienced finding GP specialised books in the past to be impossible.

    Cheers, Steve

  • CP-Steve Profile Picture
    CP-Steve 285 on at

    Went to order the book, however, I am not willing to pay:

    Please select a Shipping Method!

    UPS Saver ($92.67)  -  1 Guaranteed Day(s) To Delivery

    for postage. Let me know if you can have it posted a lot cheaper.

    Cheers Steve

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans