You’re offline. This is a read only version of the page.
2
Hi,
I am asking this question as to know if SSRS is the real solutions to reporting in Dynamics 365.
I wrote a simple report to show overdue tasks. It worked fine in VS 2015 environment. When I uploaded the report, it worked OK - no issues. However, when I ran the report, it gave me a weird error saying "Report can't be uploaded ... ". But the report was already uploaded.
There were 3 reports and one worked fine on Dynamics 365. Well, I started digging down by removing things. After spending two hours trying to resolve the issue, I finally caught it. The error was coming because I used "DateString()" function in one of the expression. I removed that and uploaded it again and it worked fine. However, I have obviously lost functionality. I still need to find the alternative of "DateString()" and see if it works.
So the real question is "Do we really know what is supported on Dynamics 365 reporting services?" Is it documented somewhere? Is there a way to know the limitation in a development environment without uploading and testing for each new feature? Or do we just have to tell the business to look for a different solution?
Just wanted to hear from your experiences and would like to know if anyone experienced the same level of frustration while trying to fix things.
*This post is locked for comments
Hi nmk,
This expression is one method for displaying the current date. I am not sure that you need to pass today's date to a query parameter.
=Format(Today,"dd/MM/yyyy")
Paginated reports are now available in the Power BI service. These reports have a similar report format to SQL Server Reporting Services reports as they are based on the RDL report technology in SQL Server Reporting Services. You can find information on paginated reports in Power BI here.
Thanks Adrian,
I am just using "DateString()" function to pass today's date to query parameter. Probably I need to create a string by concatenating the date parts. (feel free to let me know if there's another way).
I think the main problem with SSRS is to find the issue which takes a lot of time.
Can we do paginated reports in PowerBI?
Hi nmk,
SQL Server Reporting Services (SSRS) is one solution, and Power BI is another solution you can use for reporting in Dynamics 365. Both options are very common.
What are you trying to do with your expression? I can make suggestions based on your requirement.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (