create proc proc1

@cateogory

as

select * from cateogortTbl

where cateogoryID IN (@Cateogory)

where...

Ganesh Lohani (8/25/2010)

---

You need to create a multivalue parameter in your report.

Steps:

1. Open the report in BIDS and click the data tab.

2. Create a new data set, let's say ...

Primarily, it is Report Manager and not Report Server.

You can create subscritpion either static or data driven.

Phil Parkin (9/13/2010)

---

sabarichandru (9/13/2010)

---

Hi,

Did u found any solution for the requirement .me also facing the same probs i found the solution also to resolve using Derived Column.

but another problem is...

darth vodka (9/13/2010)

---

you will need to do it in MDX

use SSMS to create an MDX query, it's easier than doing it in VS, you get the intellisense and drag-n-drop

it will...

Please...

Is MsDtsServer100 running on the server or any of clustered machine in the network

Pinky,

Make your control accept multivalue parameters and ammend the SQL query accordingly

Approach 1: This could be done very gracefully using a Script Task/Component

Approach 2: Some kind of lookup...i'm not much sure of Approach 2

You may set the IsSort Property in the DFT itself and...

Make a CTE :cool::cool::cool:

Seriously dude...you need some good revision

Raunak Jhawar (9/7/2010)

---

amarsale (9/7/2010)

---

step 1 : Go to...

Amar, sorry to...

There are two ways:

1. Use a custom assembly scripted in VB

2. Use Parameters!Parameter_name.Value

Prasad,

Do you wish to keep the existing records..if yes then it is SCD Type 2