.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to integrated SSRS with Dynamic AX 2009

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :Sql Server

hello everybody,

I have problem with my work now. i have SSAS and SSRS created on SQL BIDS. I want to integrated SSRS with Dynamic AX 2009. All of the SSRS report must be called from Dynamic AX 2009 menu items.

Can everyone guide me how to solve this problem? what the first step must doing?

Thanks for your helping..


GBU :)

View Complete Post

More Related Resource Links

Share Point integrated SSRS reports rendering when access from external site


Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai

SSRS integrated mode email subscription to AD dist group

I have MOSS 2007 running SQL 2008 SSRS integrated mode and have created some reports and report subscriptions. Everything is working great. Now I want to use an Active Directory Distribution Group as a recipient for a report subscription - does not work, however the "last results" show no error. Try again using Dist Group in TO: field but adding regular email in CC: field...only email in CC field receive report, again all successful. Does SSRS integrated mode support AD distribution groups? if so is there any special setup required? Thanks LmmMmmm...yummy...

Schedule reports with integrated authentication SSRS 2008

Hi All,  Having an issue with SSRS 2008 at the moment, trying to setup subscriptions. Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports.  This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....." What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder. Is the /any/ workaround at all that doesn't involve storing the credentials?  It seems totally crazy that they cannot be prompted for them when setting up the subscription.  For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work.  If we saved their credentials then they would see all the data..and thats nasty. The only workaround I can come up with would be to create  a separate datasource for each user and upload a separate model, but thats really nasty to be hones

Setting Title on SSRS (SharePoint Integrated Mode) subscription.

I have some subscriptions in SSRS where the report goes directly to a Document Library on Sharepoint.  The subscription works fine, however, I would like to have the Title of the report be the current date that the report is run.  Is there a way to put a formula such as =[today] in the Title field of the File Options section on the Subscription properties?  I have tried this but either it is not possible or I am not using the correct syntax.  Thanks, Tim Olig

Sharepoint and SSRS Sharepoint integrated mode, any side effect ?

Hi, We planned to switch from native mode to sharepoint integrated mode our SQL Server Reporting Server. But it is a production server, so we liked to know if any side effect can happened on existing report and if it is possible to switch an existing database into sharepoint integrated mode ? Thanks, Mathieu Perrin.

Integrated SSRS and kerberos working great.But one user gets An unexpected error occurred while conn

I have this one user who can access SharePoint with no problems otherwise but is getting errorAn unexpected error occurred while connecting to the report server When they try to access an SSRS reports I confirmed he has access. Client issue? AD Account issue?Thanks.

SSRS Integrated: Program Subscription Building?

We have a few hundred clients, and we need to run a daily sql report for each of them. Saved in a document library, they can be picked up by the Search. I'd like to avoid the manual work of setting up 200+ report subscriptions. What would be the recommended route?1) Work with the sql 2008 object model?2) Work with the MOSS object model? (I see no class methods available for this - is this even possible?)3) Work directly with either the report server database or the sharepoint database and with ado.net just loop through a set of insert statements, one for each client we want a report for?Thanks for any input/direction.markusMarlin7

Drill down issues with ssrs in integrated mode

The "jump to report" drilldown option is not working right.  These same reports drill fine on another report server (non-integrated).  It looks like the "path" specified in the url is messed up, it's trying to go to site/subsite/report instead of just subsite/report.  The site that has the report library is not the root site in the site collection. I've tried looking around for a setting for that path but I don't see it.  Seems like the report would know its own path.. Thanks in advance for your help,   Ken SSRS 2005, MOSS 2007

SSRS 2008R2 - go back to parent report does not work sharepoint integrated mode

I'm currently using SharePoint Foundation 2010 with SQL Server 2008R2 with the SharePoint RS add-in. I have a report with a drilldown to another report.  I can drill down correctly to the other report.  But when I do the "go back to parent report" it will take me back to the parent report, but when I try to drilldown again to another report, I get the following error. "Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled. Details: Error parsing near ' <!DOCTYPE html PUB'. Line: 5 Char: 62099" When I run this report in VS 2008 or Report Builder 3, I have no problems drilling down and back and forth. I only have an issue when I deploy the report to SharePoint.  I have also accessed the RDL directly outside of a webpart page, but still get the same error. Wondering if anyone else is experiencing this issue?

Need the old "Browser" access in the new SharePoint Integrated with SSRS

0 down vote favorite Does anyone know of a way to add or remove items from the "Actions" menu within a report on SharePoint 2010 Integrated with SSRS 2008 R2? I would like to remove "Open with Report Builder" and add "Subscribe" to the Actions menu. I'm working with my SharePoint Server Admin who is at a loss also. I have found how to remove Report Builder from the server but the Admin doesn't want to do that since I am not his only customer. The "Subscribe" option seems to be driven from permissions but I'm not able to get it to show up for my read-only viewers. It shows up for me but I'm not going to give them admin rights. Basically, what I want is the "Browser" role from Report Manager: "May view folders, reports and subscribe to reports." They couldn't open in Report Builder. It seems so basic. I just want people to view reports and if they'd like, subscribe to them. Thank you

How can i generate dynamic TOC or TOC as link while making .rdl in SSRS.


hello ,

well  how can i generate a Table of content dynamically or TOC as a link so that while clicking in the TOC section it goes to the same page in pdf report output.


so can any one help me how to make TOC in .rdl design in SSRS ...plz help me out soon.



how to run dynamic sql in ssrs


I wrote a dynamic SQL. How to run it in the SSRS?




Create dynamic dropdown list when we export data to excel using SSRS.


Hi All,

I have assigned a work to create a report, that should render in excel with dropdown list. i.e. report should contain a input parameter as a table names, when user selects the table name, report should show only the field names of the selected table. Some of the field name have look up values that values should be displayed as dropdown when we export to excel.

Can any one have any idea how to proceed with this report?



Looking for guidance: Integrated SharePoint SSRS migration and upgrade from 2007 to 2010


Our existing prod farm is MOSS 07 with an integrated SSRS instance using SQL Server 2008, both on Windows Server 2003 64bit boxes. SharePoint databases are on a different SQL Server 2008 server.

I have built a new SharePoint 2010 farm on Windows Server 2008 R2 boxes, using a single SQL Server 2008 R2 Enterprise server as the backend for both SharePoint databases and Reporting Services (installed in Integrated mode). We are going to be using the database-attach method of upgrading our SharePoint farm.

Is there any specific guidance out there on exactly how to migrate/upgrade Reporting Services in this scenario? I've read through some of the MSDN content (How To: Migrate a Reporting Services Installation) but nothing seems to deal specifically with doing this when in Integrated mode with SharePoint. Our business heavily relies on SSRS reports in SharePoint and also shared and custom report subscriptions via email.

We do have a dev SharePoint 2010 farm in a similar configuration that I can test migration/upgrade steps. Thanks.

SSRS Report Viewer WebPart dynamic dispaly in SharePoint 2010


dynamic layout or zone  for Report Viewer Webpart, the report as to take all the space possible, and I don't want the scroll bars.

Any Suggestion

ssrs and sharepoint 2010 integrated mode





I have a ssrs server deployed in integrated mode with sharepoint ..and i have a couple of reports deployed to sharepoint server..Now when i go to sharepoint site and view the reports then the first time it displays them correctly but when i change some parameter and then click apply then it stops and gives me this error.




Webpage error details




User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E)


Timestamp: Wed, 20 Oct 2010 14:52:43 UTC






Message: 'null' is null or not an object


Line: 5


Char: 27772


Code: 0


URI: http://test/ScriptResource.axd?d=Py4uDiRG2xcvSKHQoIG5g7XQIl5Ag_3lpZ_2Whd1GKKqcTDzhhbCKzFkdTe3TFZhlvdrXwq3AK-BAMlv5dvADnjhvAReAHeQZLVkLZNeJ2l9TrQuyz4nUfdaZJ1fTgf4jaPnY19Pqz2WZRnQEqe62-zPhqV08iSTnjrTH7ETAAD9jDjV0&t=5c2f384e




Installation of SSRS 2008 in SharePoint integrated mode

Hi All,

I have got a server (Windows Server 2003 x64) which has the Office SharePoint server 2007 and SQL Server Reporting Services 2008 (in SharePoint Integrated mode) installed in a stand-alone machine (System configured and installed by some other guy). We want to use the SSRS 2008 in SharePoint integrated mode.

I want to make sure that installation and configuration of system is done properly. But i am a starter, so i don't know much where to start.

Please help me which points i have to check to make sure that system is configured properly.

Also i visited the server and found the followings:
1. In central administration, under Application Management tab, Report Services section is not there. ( I think SSRS 2008 AddIn is not installed)
2. Single MSSSQLServer is created for SQL Server 2008, SSRS 2008 and Office SharePoint Server 2007 (Not sure Please let me know where i can confirm this)

Any help is appreciated.


Thanks, Cool Developer
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend