New role assignment ti view SSRS reports

Hi All,
Today I gave access to my reports to my manager by adding the below

 <domain>\<account>.

under security tab of my main folder and make sure the reports in the folder have the same security type

Month does not come in order in SSRS tablix report

Hi All,
When I was trying to get a sparkine report for monthwise data using the matrix report in report builder 3.0 and SSRS....i would not get the right order....i,e instead of Aug, Sep, Oct and Nov....I would get Sep, Nov, Oct and Aug.
After 2 days of struggle for this issue I finally found a link which gave a solution for this and the solution is listed below

In textbox which binds to Date fireld, I changed its expression to =MonthName(Month(Fields!QDate.Value), False). Now, Month name is displayed in table.  Also I changed group's group and sort expression to =Month(Fields!QDate.Value).

The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded.

Hi All,
I realised that getting sparkline in Visual studio 2008 is not so easy. So I downloaded report builder 3.0 and run the table with sparkline. I was happy that I was able to run it.
But when I tried to save this report and access it through visual studio 2008 it would give me the below error.

"The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' which cannot be upgraded."

To resolve this issue..I followed the below steps
1. Open another running report xml code in visual studio and copy the first 2 lines ..I had the below


<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition">

I later got the error message as stated below

"Deserialization failed: The element 'Report' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' has invalid child element 'ReportSections' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition'. List of possible elements expected: 'Description, Author, AutoRefresh, DataSources, DataSets, Body, ReportParameters, Code, Width, Page, EmbeddedImages, Language, CodeModules, Classes, CustomProperties, Variables, DeferVariableEvaluation, ConsumeContainerWhitespace, DataTransform, DataSchema, DataElementName, DataElementStyle' in namespace 'http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition' as well as any element in namespace '##other'. Line 4, position 4."

For this deleted the lines that contained 

<ReportSections>

    <ReportSection>

   and </ReportSections>

    </ReportSection>

Bingo!

I was able to open the reports made in report builder 3.0 in Visual studio 2008

  

unable to connect to the remote server reporting services 2008

Hi All,
I wonder why reporting services keeps coming up with new errors every time I start it..anyways I got this error when I started the reporting services 2008 .
"unable to connect to the remote server reporting services 2008"

The fix for this is to set the Secure connection level to 2 in the rsreportserver.config file found at
C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

Difference between Union and Union All in SQL

The main difference between UNION ALL and UNION is that, UNION only selects distinct values, while UNION ALL selects all values (including duplicates).

sp_linkedserver in sql

Hi All,
The below command is used for linking sql servers

EXEC sp_addlinkedserver @server = 'ppvs00982'

Adding matrix to SSRS reports

Hi All,
The below link gave me steps to add a matrix type report which includes the subtotals. I used to generate report weekwise with subtotals and totals

http://www.sqlservercentral.com/articles/Reporting+Services+%28SSRS%29/63415/