SSRS Sharepoint Trusted Account Error

Error

• An error has occurred during report processing. (rsProcessingAborted)
  • Cannot impersonate user for data source 'DataSource1'. (rsErrorImpersonatingUser)
    • This data source is configured to use Windows integrated security. Windows integrated security is either disabled for this report server or your report server is using Trusted Account mode. (rsWindowsIntegratedSecurityDisabled)  

Solution

Review steps 2-4 here

http://cowmasterscorner.blogspot.com/2012/04/request-failed-with-http-status-401.html

Dynamics GP eOne Extender Enterprise - a remove range_operation on table PT_Extender_Palette_Forms failed accessing SQL data

Error:
You get this error when attempting to use a detail form

When you click on info, you get


[Microsoft][SQL Native Client][SQL Server]Invalid column name 'PT_Palette_ID'.

[Microsoft][SQL Native Client][SQL Server]Invalid column name 'PT_Palette_ID'.


Solution:

This error goes away after you have logged in and built all of the extender tables through the extender install window.

Dynamics GP eOne Extender Enterprise - Script '[22009] of form ExtenderActionsObject' not found.

Error

Unhandled script exception:
Script '[22009] of form ExtenderActionsObject' not found.



EXCEPTION_CLASS_SCRIPT_MISSING
SCRIPT_CMD_CALL


This error occurs on a new install of Extender Enterprise on GP 10 SP5

When you create a form and attempt to use it, you get this error.


Install the latest version of Extender Enterprise for GP2010 (Even though you are using GP 10)

The most updated version can be found here
http://www.eonesolutions.com/Products/Extender/Downloads.aspx

If you have already installed the Microsoft Extender, and need to upgrade to the eOne Enterprise Extender, follow the instructions here
http://www.eonesolutions.com/Support/Knowledge-Base/Knowledge-Base-Article.aspx?articleid=196

Dynamics GP Microsoft Extender and eOne Extender Enterprise

First of all, the extender that is installed from the add/remove programs for GP is Microsoft Extender.
eOne has another version called Extender Enterprise. It has more features than Microsoft Extender.

Even if you are using GP 10, install the Extender Enterprise for GP 2010.

The most updated version can be found here
http://www.eonesolutions.com/Products/Extender/Downloads.aspx

If you have already installed the Microsoft Extender, and need to upgrade to the eOne Enterprise Extender, follow the instructions here
http://www.eonesolutions.com/Support/Knowledge-Base/Knowledge-Base-Article.aspx?articleid=196

If you are unable to login to your company because extender can't find certain tables, or you are getting an error saying some tables are the wrong version, follow these instructions to ensure you have completed the install correctly

Before doing any of this, you should backup or export your extender customizations/data. You may or may not be able to import them in, so be prepared to rebuild them if you have to.

• Rename the EXTUD.dic to EXTUD.old in your Program Files\Microsoft dynamics\GP\ folder
• Run the latest Extender Enterprise install (ExtenderEnterprise11.msi) and point it to your GP folder
• It will extract the Extender chunk file to that location
• Run GP, it will prompt to add new code, do so, ignore all errors
• It should then prompt you to create all tables, say yes
• Once it's finished, Restart GP
• If you get any errors, go to GP>Maintenance>SQL
• Select the old company database that is giving trouble
• Select the Extender product
• Select all tables
• Tick "drop tables", "create tables", "drop auto procedure" and "create auto procedure"
• This will wipe out ALL Extender customizations for the company, and ALL data in the extender fields. Make sure you backup whatever you need first.
• Process
• This will reset all of the tables in that company to the current version of extender that is installed

How to download your Microsoft Certifications

If you have done any Microsoft exams, you are a Microsoft Certified Professional.

Login to the website here
https://mcp.microsoft.com/authenticate/login.aspx?ReturnUrl=https://mcp.microsoft.com/mcp/

Navigate to My Credentials>Transcript>View or Download Transcript
https://www.certificationlogobuilder.com/transcriptdownload.aspx

Dynamics GP - Outstanding AR transactions

This view can be used as the basis for an AR Trial Balance

http://victoriayudin.com/2009/09/05/sql-view-for-all-unapplied-receivables-transactions-in-dynamics-gp/

Crystal Reports - Parameter Dynamics List does not show all values

This is a bug with Crystal itself.

To rectify this, and have Crystal display all parameter values,

1. Click Start, Run 
1. If run is not enabled, right click on start>properties>start menu>customize>scroll to the bottom>tick Run Command
2. Type in "regedit"
3. Expand HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\
1. The "Suite 11.0" folder will be different depending on your version of Crystal
4. Right click on Crystal Reports> New>Key> Type in "DatabaseOptions"
5. Right click on DatabaseOptions> New>Key> Type in "LOV"
6. Select LOV
7. On the right hand side of the window in the white area, right click>New>String Value>Type in "MaxRowsetRecords"
8. Double-click MaxRowsetRecords
9. Type in -1 (-1 displays all available records)
10. Restart Crystal

The final key that you should have added is: 

(For V11)

HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords (String) Set to -1

or

(For V12)

HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\DatabaseOptions\LOV\MaxRowsetRecords (String) Set to -1

If this does not work, ensure that you have entered the names EXACT with no spaces.

This will work. If it does not, you have a typo somewhere.