Vikas,

I can't see the picture/image attached herewith.

Vikas,

Its very easy. You need to write following expression in Border Style of report item or TextBox:

None, Solid, Solid, =IIF(Fields!ID.Value=Previous(Fields!ID.Value),"None","Solid"), None

alternatively, you can set

Default = None,

Left = Solid,...

Hi Zeetec

Just try below expression:

=iif(count(Fields!ID.Value)-1 0, Sum(Fields!Other1.Value, "DataSetName") / (Count(Fields!ID.Value)-1),3)

Yeah. Package configurations is the best way to deal it.

SELECT DISTINCT EmployeeID,EName FROM #Bar

WHERE EmployeeID NOT IN (SELECT EmployeeID FROM #BAR WHERE VisitedState = 'Other')

You can use attached Script for more information. Also change the script as per your requirement.

It would be nice if you can use Horizontal Table Partitions. In this way you can define the date range in partition function and store your data in respective partitions....

What error you are getting exactly? Can you show that error?

Use Sort task in Data Flow Transformation and check "Remove rows with duplicate sort values" check box in Sort Transformation Editor.

You can achieve this in different way...

If you want to store file path in database then do following thigs:

1. Create a package variable say User::FilePath of type string.

2. Initialze this...

Hi Joe,

Use below code and enjoy!!!

CREATE TABLE #T (AreaID int, Area_SubAreaID int, SubAreaID smallint)

GO

INSERT INTO #T

SELECT5689, 568901, 01 UNION

SELECT5689, 568903, 03 UNION

SELECT5689, ...

Probably It should not happen... Its really strange. Better to give some more details related to Control Flow...

See attached rdl reports. It may help you in some extent.

Are you using SSRS 2005 or SSRS 2008?

On ReportItem navigation property, Set Parameter Value with Depart name/number e.g ParameterName!Value=Fields!DepartName.Value or ParameterName!Label=Fields!DepartNo.Value.

By Default, it should have all the values...