MDX Drill through issue

MDX parameter in drill through passes values like 15 - MILK but report works with [Product].[Product].[Department No].&[258]. To resolve this issue add  

WITH MEMBER [Label] AS '[Department No]. CURRENTMEMBER.UNIQUENAME ' at the start of the code.

Then add [Measures].[Label] in your Axis(0)

Then in drill through action tab pass [Label} for your parameter

SSRS Multiselect paramter is not showing result

SSRS Multiselect paramter is not showing result

Single selection works but not multiselect in ssrs while implementing SSRS reports.


Solution - All you have to do is in Where condition ensure that you are using "IN" operator
And then ensure that the parameter expression should be =Parameter= !Parametername.Value and not Parameter= !Parametername.Value(0)

Today minus 2 years in ssrs

Hi Folks,
Write the below code in your SSRS expression tab to get date - 2 years in your ssrs textbox

=DateAdd(DateInterval.year,-2,Today())

Order By using CAML queries

Use the below code type to achieve order by using CAML queries in your SSRS query designer

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

  <ListName>Regions</ListName>

  <ViewFields>

   <FieldRef Name="RegionName"/>

  </ViewFields>

<Query>

<OrderBy>

    <FieldRef Name="RegionName" Ascending = "True"/>

</OrderBy>

</Query>

</RSSharePointList>

Hyperlink in SSRS shows 2 & field name while using it with Sharepoint

While using the GoTo URL link in SSRS to open a sharepoint list like below

="http://devserver:1882/Lists/Regions/DispForm.aspx?ID=25

I used the below settings in GoTo URL option in Action tab

="http://devserver:1882/Lists/Regions/DispForm.aspx?ID="&Fields!Region_ID.Value

but this would bring up wrong results i,e

="http://devserver:1882/Lists/Regions/DispForm.aspx?ID=25&ID=25

We can resolve this issue by adding extra / before your.aspx page

="http://devserver:1882/Lists/Regions//DispForm.aspx?ID="&Fields!Region_ID.Value

Ref - https://connect.microsoft.com/SQLServer/feedback/details/590273/ssrs-goto-url-action​

Your browser is executing scripts on this page . If message persists , please make sure that you are visiting a correct site and Javascript support is enabled in your browser and then try again

Hi Folks,

Your browser is executing scripts on this page . If message persists , please make sure that you are visiting a correct site and Javascript support is enabled in your browser and then try again

To resolve the above error..apart from trying the below mentioned steps, just add your website details in trusted websites under Internet options>Security>Trusted Sites. 

1. On the Tools menu, click Internet Options, and then click the Security tab.
2. Click the Internet zone.
3. If you do not have to customize your Internet security settings, click Default Level. Then do step 4

If you have to customize your Internet security settings, follow these steps:
a. Click Custom Level.
b. In the Security Settings – Internet Zone dialog box, click Enable for Active Scripting in the Scriptingsection.

4. Click the Back button to return to the previous page, and then click the Refresh button to run scripts.

unable to load the package as xml because of package does not have a valid XML fomat

Hi Folks,
I was not able to run the ssis job which was pointing to a dtsx file placed in different folder.
I was actually using the below type of file sysmte
C:\MyFolder\Mypackage.dtsc

But we have to use the below one

\\servername\C$\Myfolder\MyPackage.dtsx