Showing posts from March, 2013

CRM Explorer/Tools missing from Visual Studio 2010

if you ever find the Dynamics CRM 2011 Explorer / Tools options missing from within Visual Studio 2010 ....

... check prerequisites are installed:-

1. Visual Studio 2010 SP1
2. Silverlight 4
3. Windows Identity Foundation
4. CRM Developer Tools (found within the CRM SDK, Tools folder)

Then check that the following is mentioned in your solution file (if you open the .sln file in a text editor):
Save and reload the solution in Visual Studio 2010.  Do not append 'SolutionIsBoundToCrm = True' line to the below if you meet in your solution file. GlobalSection(SolutionProperties) = preSolution HideSolutionNode = FALSE EndGlobalSection good luck,

Exception caught instantiating TERADATA report server extension SQL Reporting Services


If you face an error in Reporting Services Log File (C:\Program Files\Microsoft SQL Server\MSRSxx_xx.MSSQLSERVER\Reporting Services\LogFiles) such as :

extensionfactory!ReportServer_0-1!ea4!03/26/2013-08:20:15:: e ERROR: Exception caught instantiating TERADATA report server extension: 
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. 
---> System.IO.FileNotFoundException: Could not load file or assembly 'Teradata.Client.Provider, Version=, Culture=neutral, PublicKeyToken=76b417ee2e04956c' or one of its dependencies. The system cannot find the file specified.
File name: 'Teradata.Client.Provider, Version=, Culture=neutral, PublicKeyToken=76b417ee2e04956c'
   at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
   at System.Reflection.Assembly.I…

flip rows to column in SQL Server

Below is a table that i use in the example;

AttendeeNameGroupNameQuestionNameAnswerNameQuestionIdValueResultOrderSurveyIdAnswerIdAhmet EgeKisisel BilgilerAskerlik Yaptiniz mi? (Q1)Evet (A1)1151114Ahmet EgeKisisel BilgilerEvli misiniz? (Q2)Hayır (A2)2163115Ahmet EgeKisisel BilgilerIs ariyor musunuz? (Q3)Evet (A3)3112117
and the result expectation is;

AttendeeNameAskerlik Yaptiniz mi? (Q1)Evli misiniz? (Q2)Is ariyor musunuz? (Q3)Ahmet EgeEvet (A1)Evet (A2)Evet (A3)
here is the Query you have to be considered;

SET @SurveyId = '11' ;
DECLARE @QuestionList nvarchar(max);

SELECT @QuestionList =
                                 SELECT ', ' + quotename(QuestionName)
                                 FROM custom_survey_reports
                                 WHERE oti_surveyId = @SurveyId
                                 GROUP BY QuestionName
                                 ORDER BY QuestionName

Get PickList value for Reports or other SQL statements

There is a table,'StringMap' which contains map of id with value. you can run any select statement against this table.'AttributeValue' takes key and 'value' takes value of the key.You should do some filter actions to focus on to the exact data that we may need so add 'ObjectTypeCode' as type code of Entity and 'AttributeName' as name of the field to the where statement. Example; SELECT AttributeValue,Value FROM StringMap WHERE ObjectTypeCode = '1' and AttributeName='customertypecode' Query will return CustomerTypeCode of Account. There is also alternate, if you do not know type code of the entity; FilteredViewName must be name of the entity with 'Filtered' prefix : Filtered+account. SELECT AttributeValue,Value FROM FilteredStringMap WHERE FilteredViewName= 'Filteredaccount' and AttributeName='customertypecode' query will return same result as above. good luck.