On the action (go to report) part in SSRS, when selecting the parameters - choose expression and try:

=Split(Parameters!YourParameter.Value, ",")

This works for me for drill through reporting with MDX

vinayak.v (2/21/2011)

---

thanku... it worked..

one more doubt..

this is about ssrs reports

i've one comments field nvarchar(500)DATA TYPE

in that comment field in every row person name occurs

like jhon ,smith and steve..

now what...

CREATE TABLE [thoughts]

(

id INT IDENTITY(1, 1)

UNIQUE

...

http://www.sqldelta.com/

http://www.red-gate.com/products/sql-development/sql-compare/

mister.magoo (2/4/2011)

---

Can I please ask why you need the output in a certain order?

XML is not normally used in that way (at least not in my experience) and I find...

I have tried various methods of ordering the result set, which eventually resulted in:

Msg 6833, Level 16, State 1, Line 39

Parent tag ID 1 is not among the open tags....

Apologies - I had edited my comment - please see above 😀

I need to understand the problem more before I can offer a solution.

It seems to me you...

and you want this?

<root_element value="one">

<elementA value="many" />

<elementA value="many1" />

<elementA value="many2" />

<elementA value="many3" />

<elementA value="many4" />

<elementA value="many5" />

...

DECLARE @xml XML

DECLARE @tab TABLE

(

root_element NVARCHAR(10)

, elementA NVARCHAR(10)

, elementZ NVARCHAR(10)

...

BIDS (Visual Studio):

To publish a report to a SharePoint site configured for SharePoint integration, you must verify that the report project properties in Report Designer point to the SharePoint site....

I have also encountered both the errors you mention, in the end I explicitly mapped the database I needed using the @catalog parameter.

EXEC master.dbo.sp_addlinkedserver @server = N'NameOfLinkedServer', @srvproduct=N'AnyNamedLink', @provider=N'SQLNCLI', @datasrc=N'YourDataSource',...

If you have a DW environment you may be able to utilize the "Translations" tab (in Visual Studio for Analysis Service Database), I say may...

Hi,

If I have understood your scenario correctly, rather than adding a post calculated field to an existing dataset, add the calculated column to the dataset...:hehe:

So if you retrieve the data...

This may be of use to you:

http://www.eggheadcafe.com/software/aspnet/31535858/date-range-in-mdx.aspx

Do you want the labels of the reports to be multi-lingual and/or the data?