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

SELECT DISTINCT does not work with multiple columns

Hi Folks,
Today I came across a scenario where select distinct did not work when more than two columns are used. To resolve this issue, I used the below type of CTE using Row_Number



;WITH DistinctMails AS

(
    SELECT ID, MailID, EMailAddress, NAME,
        ROW_NUMBER() OVER(PARTITION BY EMailAddress ORDER BY ID) AS 'RowNum'
    FROM dbo.YourMailTable
)
SELECT *
FROM DistinctMails
WHERE RowNum = 1

And it worked !!!

The path of the item 'http://localhost/Reports/Pages/Folder.aspx?ItemPath=/Parent Reports/Child Reports' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash.

Hi folks,
I got the above error after immediately fixing the dataset has to be deployed error while trying to deploy the ssrs report.
The reason for this was I had my report name as Report Check $2,000. All I did was remove the $ sign and the , sign and bingo I was able to deploy the report.

So my suggestion to resolve this error is that you should try not to add any special characters in the name of your reports. 

Cannot deploy the report because the shared data source '/Data Sources/DataSource1' that the report references does not exist on the report server.

Hi Folks,
I was getting the above error and to resolve this error, I first deployed the data source first and then my report.
Find below the screenshots for your reference

Get SSRS report data in single page

Hi,
The SSRS report was showing the data in 2 different pages in print preview page and I needed the whole data in 1 page
To achieve this I followed the below steps

Right click on Report page and click on Report Properties. You should see the below screen.
Increase the width and height and you should get the columns in 1 page