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 CRM (Archived) / SSRS using Stored Proc...
Microsoft Dynamics CRM (Archived)

SSRS using Stored Procedures

(0) ShareShare
ReportReport
Posted on by Joe Spitler 1,290

I have creted a simple SSRS report and deployed it just fine usign the CRM.  Now I want to create a more complex report and will have to use a stored precedure.  Should create the SP in the CRM DB or should I create a 'custom' DB?  If I create a new DB how would I set up permissions so that the report can be run from the CRM?

Thanks.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Gus Gonzalez Profile Picture
    Gus Gonzalez 27,113 on at

    If you need to create a custom report. Import the custom RDL file that reads the data from the CRM database. I don't think you need to create a separate, custom DB to utilize a custom report.

  • Joe Spitler Profile Picture
    Joe Spitler 1,290 on at

    The issue is that I needed to create a stored precedure to based the report on and I was told not to put the SP in the CRM DB.  I foung a suggestin on another forum that worked.  I did create a custom DB that will be the place where my new SPs live.  I granted the permisisons that I need and it's working great.  Thanks.

  • bkeilin Profile Picture
    bkeilin 30 on at

    Hi Joe,

    I have the same scenario...custom data warehouse with a stored procedure being used in the SSRS Report.  I am wondering what permissions you granted and for which users to the custom stored procedure in the custom DB.

    Thanks.

    Brent

  • Joe Spitler Profile Picture
    Joe Spitler 1,290 on at

    It was quite easy, actually.  Create your custom DB.  Create your SP that returns the data for the report.  Grant the logins based on domains that are created automatically permission to the custom DB.  They are called something like ReportingGroup, PrivReportingGroup and SQLAccessGroup.  Create your SSRS report.  Create the RDL file.  Add the report to the CRM in the reports section.  You'll be good to go.

  • pjtaylor Profile Picture
    pjtaylor 5 on at

    Hi Joe,

    I assume you can't use pre-filtering if your using SPs?

    Paul

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 CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans