SSRS - An error has occurred during report processing. (rsProcessingAborted) The processing of Parent for tablix 'Tablix1' cannot be performed. Cannot compare data of types System.String and System.DateTime. Please check the data type returned by the Parent. (rsComparisonTypeError)

So you get the above error when generating a report that usually works.

This is because there is a conflict on your tablix group.

For mine the issue was resolved when i removed the Recursive Parent from my group on the Tablix1 tablix.

Error in SSRS

Group Properties on Tablix, Remove the Recursive Parent

SSRS add in for SL

Originally found on page - 

http://ajitkannan-erp.blogspot.com/2013/12/add-ssrs-report-in-dynamics-sl-2011menu.html

Add SSRS Report in Dynamics SL 2011Menu

This post is an effort to the various operating steps which helps to adding the SSRS Report under SL menu

   Step 1: Create New SSRS Report or use existing Report (.rdl) 

   Step 2: Include the report in SL root folder under Usr_Rpts

   Step 3: Open SL 11 -> Administration->Maintenance -> Report Control Maintenance  (98.300.00)

       Enter the Report information Report number, Report format name, Report format into the Report 

       Control  maintenance .

   Step 4:  Open SL 11 -> Administration->Maintenance -> Screen Maintenance (98.330.00)

       Enter the Report number, Report name, Module and Type 

   Step 5: Open SL 11 -> Administration->Maintenance -> Menu Maintenance (98.350.00)

1. Select the relevant Group in “Menu for Group”.
2. Select the Screens tab in the Menu Maintenance (98.350.00). 
3. Select ALL- Show All Screen from the Drop-down “Show Screen Access for Group”.  This will show up all the SL screens in the Screens tab.
4. Select the exact Report  from the Screens tab. Drag and drop the Report into the “Navigation pane work area” under  Inventory -> Report .
5. After add the report to menu exactly as a normal crystal report,but rename  the program ROISRS.EXE replacing from ROI. EXE.Report as shown in the below figure. 
6. Save and close the screen.

  Step 6:  Close the Solomon and launch it.

SSRS Trial Balance not sorting account numbers

So you try to print a GL Trial Balance but when you select the from and to accounts they are not sorted correctly.

Easy fix - change the sort order in stored procedure.

Edit the stored procedure that populates the drop down list (seeglSRSAccountListing in the company database) to end with this:
select * from #accountsegment order by segmentlisting

Originally it does not sort.

Also, you can technically change the drop down lists to text boxes and type in account segments instead of using that pre-populated drop down list if you want.

Unable to click arrows in SSRS

From IE 10 and up you will not be able to click on the drop down arrows in SSRS.

To resolve this issue you have to add the page to compatibility in ie.

How -
Go to the Menu bar in Internet Explorer then click Tools> Compatibility View Settings>> Click Add.

This will add the page to compatibility view and you will be able to click on those arrows now.