You’re offline. This is a read only version of the page.
22,647
Had a client request and I wanted to get feed back from the community first.
Client question: I want to understand SSRS better and to be able to create some reports for our company. I do not want to be a programmer, I am a controller and as such have a pretty good grasp on how GP works.
1. Where can we learn how to create SSRS reports?
2. How much technical knowledge do we need to create SSRS reports?
3. Are there specific GP focused training sessions we should look for?
4. Is the training only 'general SSRS' processing and the we have to apply it to GP?
Thanks in advance for your feedback.
*This post is locked for comments
I found this online which may or may not be what you're looking for:
Reporting Services Tutorials:
technet.microsoft.com/.../ms170246(v=sql.90).aspx
Microsoft SQL Server 2012 training : Reporting Services
mva.microsoft.com/.../microsoft-sql-server-2012-training-reporting-services-9117
It isn't a 2-3 day classroom teaching, but it's free, so worth taking a look at.
Thanks,
Unfortunately it seems that ATX is a desert for the Microsoft training programs like that...they are mostly in Dallas and Houston, with some in San Antonio
Gina, while pricey, the best option might be Austin Community College. They offer online courses (once a week) for that.
Hello Gina,
I don't know that we would have much as far as training for creating SSRS reports, as from the Dynamics GP side, we only deploy a set of canned SSRS reports and really leave the actual creation of custom SSRS reports to the SQL Reporting Services teams who more specialize in that area.
That being said, I would look for SQL Reporting Services training which should lead you to Report Builder and BIDS for SQL Reporting Services and information on creating custom SSRS reports.
Thanks,
Hello everyone, I am currently having the same problem. Our accounting team needs to learn and create SSRS reports. We do not have any SQL knowledge, so I'm going to look into W3schools to gain some basic knowledge before learning SSRS. I'm in the ATX area, do you have recommendations for SSRS training courses (online or classroom)? Thank you!
Hello Bill,
While there may not be any Dynamics GP training in regards to creating SQL SRS reports, there is information online related to this type of information, such as here:
technet.microsoft.com/.../ms159253(v=sql.105).aspx
The Dynamics GP Support doesn't actually support or troubleshoot custom SQL SRS reports, as you're using more the SQL Server functionality than anything with the Dynamics GP application.
My thinking is that there is probably more training/documentation/information in regards to building SQL SRS reports put out by the Microsoft SQL Server teams, so you may want to go that route.
It may not be a bad question to put in the Microsoft SQL Server forum either.
Thank you,
We at Etelligent Solutions Inc. could arrange for the SSRS training. As mentioned by everyone, SQL script writing is a requirement to build any report in SSRS. You can contact support@esicanada.com for the training if interested.
I took a 3-day SSRS class through a 3rd party training center (I forget the name, but it's the same place you go to take the GP certification exams). Most of it was devoted to report design, but we did spend time in Management Studio looking at a couple of queries. That said, this individual could probably buy themselves a "SQL Server 101" textbook, read thru the chapters related to T SQL and have enough knowledge to get through an SSRS training course.
I tend to agree with Heather's comment above that this person might be better served by checking out the various Excel reports within GP.
One word of caution: if this person starts writing SSRS reports they'd need to consider the impact on segregation of duties, especially if they're going to log directly in to management studio and have the ability to alter existing views and/or create new ones. I'm probably getting ahead of myself though.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (