Showing posts with label SSRS. Show all posts
Showing posts with label SSRS. Show all posts
Thursday, November 14, 2013

Tip - SSRS Time Format functions for converting to am/pm

›
Dear Friends, Sometime back I was working on few standalone SSRS reports which uses time fields from AX 2009 database like for e.g. smmAct...
Monday, November 4, 2013

Troubleshooting Linked Server Error The OLEDB provider MSDASQL for linked server reported an error. The provider ran out of memory

›
Dear Friends, Some months ago, I was working on a SSRS Report which sources data from a third party Oracle database. I had shared my expe...
Wednesday, March 27, 2013

SSRS Troubleshooting ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application

›
Dear All, I realized this post was sitting in my drafts folder for a while now. This is not going to be an AX post but an interesting expe...
Wednesday, February 20, 2013

About SysListPanelRelationTable Class in Dynamics AX

›
Hi there! Recently for one of my clients, I built a custom SSRS Security Maintenance form for their Financial Reporting. The requirement...
Wednesday, December 19, 2012

Troubleshooting SSRS Report Error - An item with the same key has already been added

›
Error: While building one of the SSRS Reports, I ran into this error "An item with the same key has already been added" while l...
1 comment:
Tuesday, November 13, 2012

SSRS Tips and Tricks Recursive Sum of Fields

›
Dear All, A while ago, I posted on Conditional Summing Group Totals in SSRS Here's another small but useful tip if you ever want t...
Saturday, October 6, 2012

SSRS Tips and Tricks - Conditionally Summing Group Totals

›
Dear All, Hope you are doing good. It's been a while since I have written some posts. I have lots of things to write about, but just n...
Wednesday, August 15, 2012

SSRS Format Date tips

›
Hi there! Recently, I was working on a SSRS Report wherein I need to use the Format function of SSRS for date formatting. e.g. Format(Pa...
Monday, July 30, 2012

SQL Server CTEs and Recursive Parent Grouping in Advanced Mode Group Properties in SSRS

›
Hello! Few weeks ago, I was developing an interesting report in SSRS which pulls out data from AX - Projects module. It was interestin...
Monday, June 18, 2012

Troubleshooting SSRS Report Manager Error Unable to connect to server

›
Been a while since I did my last post. It has been a hectic last month for me personally and professionally (involving some travel) Issue ...
Monday, November 14, 2011

How to Configure Kerberos Authentication for SQL and MOSS

›
Apart from AX, In my current role, I have been extensively working on MOSS/Sharepoint Administration and Troubleshooting, Configuring Kerber...
Tuesday, September 6, 2011

Step by Step Guide How to Install Dynamics AX 2012 SSRS and Analysis Extensions

›
This is the 3rd part in the series - Step by Step Installation of Dynamics AX 2012 Components: Part 1 - Basic Dynamics AX 2012 Installatio...
8 comments:
Monday, September 5, 2011

Troubleshooting Dynamics AX 2012 SSRS Extensions Install - An Error occured during Reporting Service Extensions

›
Error during Install of AX 2012 SSRS Extensions Microsoft.ReportingServices.WmiProvider.WMIProviderException: The profile for the user...
Wednesday, January 26, 2011

Troubleshooting Dynamics AX 2009 SSRS Report Data methods displaying #Error

›
I had to modify a custom Dynamics AX SSRS  Report to use Data Methods and whenever I preview the report, it was giving me the below #Error ...
1 comment:
Saturday, January 8, 2011

Troubleshooting Dynamics AX 2009 SSRS Report Generation Error

›
None of the SSRS reports were rendering correctly. This was working well before the Xmas break. Error: An error has occurred during repo...
Sunday, November 15, 2009

Deciding on Reporting Architecture (SSRS + Dynamics AX 2009) for a new Implementation

›
A few days ago, we were brainstorming on the reporting architecture for a new implementation. We had the following options on the table: ...
1 comment: