Display all the Axis labels in the SSRS

Display Axis labels
We can display all the axis label in the SSRS by the following property settings.

  1. Click on the Axis and go to Chart Axis Property
  2. Set Label Interval = 1 ( By default this will be Auto)

Now it will show all the Axis also we can skip the label display by changing the interval values.

 

Display all the Axis labels in the SSRS was last modified: October 1st, 2017 by Justin Antony

Description: Cannot create a task from XML for task “Refresh Microsoft Excel Task”, type “oh22is.SqlServer.PqRefreshTask, oh22is.SqlServer.PQRefersh, Version =1.0.0.0, Culture=neutral, PublicKeyToken=4983f182acb1fc6b” due to error 0x80070 057 “The parameter is incorrect.”

The issue can occur on the following reason.

  1. Any third party SSIS support installation is missing.
  2. SSIS Version compatibility issue.
Description: Cannot create a task from XML for task “Refresh Microsoft Excel Task”, type “oh22is.SqlServer.PqRefreshTask, oh22is.SqlServer.PQRefersh, Version =1.0.0.0, Culture=neutral, PublicKeyToken=4983f182acb1fc6b” due to error 0x80070 057 “The parameter is incorrect.” was last modified: October 1st, 2017 by Justin Antony

32-bit ole db provider “msolap” cannot be loaded in-process on a 64-bit sql server

msolap cannot be loaded
The issue occurs if you rebuild index sometimes due to registry corruption

For this issue you need to deregister and register the dll files again. This will basically overwrites the 32 bit dll with the 64 bit dll.

Deregister Steps:

regsvr32 /u “C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

regsvr32 /u “C:\Program Files\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

Register Steps:

regsvr32 “C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

regsvr32 “C:\Program Files\Microsoft Analysis Services\AS OLEDB\110\msolap110.dll”

32-bit ole db provider “msolap” cannot be loaded in-process on a 64-bit sql server was last modified: October 1st, 2017 by Justin Antony