get organization language information in sql server for crm 2011

getting the sql server information:

SELECT * FROM information_schema.tables
WHERE TABLE_NAME like  '%lang%'
select * from OrganizationLanguagePack

UPDATE OrganizationLanguagePack set isenabled=1 where languageid=3082

telerik radgrid

this link

http://www.telerik.com/products/aspnet-ajax/download.aspx

we can download the telerik.

sri shiridi sai baba darshanam online booking

shri shiridhi sai baba darshanam booking

click below link:
https://online.sai.org.in/bookDarshan.do?parameter=bookDarshan

register if your are new.

then book the tickets.

some valuable links for ssrs

for Crm and ssrs connection requirements:
http://technet.microsoft.com/en-us/library/hh699675.aspx

WIF in windows 8
http://support.microsoft.com/kb/2745961

install report authoring
http://msdn.microsoft.com/en-us/library/hh699807.aspx

frequently asking doubts:

http://rc.crm.dynamics.com/RC/2011/en-US/online/5.1_CTP/faq.aspx

suggestions:
https://connect.microsoft.com/dynamicssuggestions

https://connect.microsoft.com/dynamicssuggestions

important
http://msdn.microsoft.com/en-us/library/hh699807.aspx

Null Values in SSRS Parameters

we have option to give parameter as blank or null
by enabling the features

CRMAF in ssrs

select filteredsalesorder.ordernumber,filteredsalesorder.name,filteredsalesorder.createdon,filteredsalesorder.quoteid,filteredsalesorder.totalamount,
filteredaccount.address1_line1,filteredaccount.address1_line2,filteredaccount.address1_line3,filteredaccount.name,filteredaccount.address1_city,filteredaccount.address1_country,
filteredaccount.address1_stateorprovince,filteredaccount.address1_postalcode,
filteredbusinessunit.address2_line1,filteredbusinessunit.address2_line2,filteredbusinessunit.address2_line3,filteredbusinessunit.address2_city,
filteredbusinessunit.address2_stateorprovince,filteredbusinessunit.address2_postalcode,filteredbusinessunit.address2_country
 from filteredsalesorder,filteredbusinessunit,filteredaccount
where (filteredsalesorder.customerid = filteredaccount.accountid) and (filteredsalesorder.jmh_store=filteredbusinessunit.businessunitid)

select * from filteredsalesorder as CRMAF_filteredsalesorder,filteredbusinessunit,filteredaccount
where (CRMAF_filteredsalesorder.customerid = filteredaccount.accountid) and (CRMAF_filteredsalesorder.jmh_store=filteredbusinessunit.businessunitid)

select CRMAF_filteredsalesorder.ordernumber,CRMAF_filteredsalesorder.name,CRMAF_filteredsalesorder.createdon,CRMAF_filteredsalesorder.quoteid,CRMAF_filteredsalesorder.totalamount,
filteredaccount.address1_line1,filteredaccount.address1_line2,filteredaccount.address1_line3,filteredaccount.name,filteredaccount.address1_city,filteredaccount.address1_country,
filteredaccount.address1_stateorprovince,filteredaccount.address1_postalcode,
filteredbusinessunit.address2_line1,filteredbusinessunit.address2_line2,filteredbusinessunit.address2_line3,filteredbusinessunit.address2_city,
filteredbusinessunit.address2_stateorprovince,filteredbusinessunit.address2_postalcode,filteredbusinessunit.address2_country
 from filteredsalesorder as CRMAF_filteredsalesorder ,filteredbusinessunit,filteredaccount
where (CRMAF_filteredsalesorder.customerid = filteredaccount.accountid) and (CRMAF_filteredsalesorder.jmh_store=filteredbusinessunit.businessunitid)

Filter dataset records based on another dataset data in ssrs

Senario:
we have two datasets.
dataset1 and dataset2.
based on dataset1 values we need to filter dataset2 data.

Doing thourgh FetchXml.

First create the Dataset1 with enableprefiltering="1".
Ex:


<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="salesorder" enableprefiltering="1">
    <attribute name="name" />
    <attribute name="customerid" />
    <attribute name="statuscode" />
    <attribute name="totalamount" />
    <attribute name="createdon" />
    <attribute name="ordernumber" />
    <attribute name="quoteid" />
    <attribute name="salesorderid" />
    <order attribute="name" descending="false" />
    <filter type="and">
      <condition attribute="name" operator="not-null" />
    </filter>
    <link-entity name="account" from="accountid" to="customerid" alias="aa">
      <attribute name="name" />
      <attribute name="address1_name" />
      <attribute name="address1_line1" />
      <attribute name="address1_line2" />
      <attribute name="address1_line3" />
      <attribute name="address1_city" />
      <attribute name="address1_stateorprovince" />
      <attribute name="address1_postalcode" />
      <attribute name="address1_country" />
      <filter type="and">
        <condition attribute="name" operator="not-null" />
      </filter>
    </link-entity>
    <link-entity name="businessunit" from="businessunitid" to="jmh_store" alias="ab">
      <attribute name="address2_name" />
      <attribute name="address2_line1" />
      <attribute name="address2_line2" />
      <attribute name="address2_line3" />
      <attribute name="address2_city" />
      <attribute name="address2_stateorprovince" />
      <attribute name="address2_postalcode" />
      <attribute name="address2_country" />
      <filter type="and">
        <condition attribute="name" operator="not-null" />
      </filter>
    </link-entity>
  </entity>
</fetch>

the about code will join "order", "Account","businessunit" tables.

next :
dataset2:


<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="salesorderdetail">
    <attribute name="productid" />
    <attribute name="productdescription" />
    <attribute name="priceperunit" />
    <attribute name="quantity" />
    <attribute name="extendedamount" />   
    <attribute name="baseamount" />
    <attribute name="jmh_orderamount" />    
    <attribute name="salesorderid" />
    <attribute name="salesorderdetailid" />
    <order attribute="productid" descending="false" />
    <filter type="and">
      <condition attribute="quantity" operator="not-null" />
    </filter>
  </entity>
</fetch>

now you need to get the data in dataset2 relating of dataset1;

create parameters 

Give the values as default values.

Use this filter and create another dataset3 for the Salesorder.

after that create another parameter

so using 3 parameter

create filter on dataset2.

u will get the correct details.