It's only duplicated if the rowversion column is included in the column list of the select into statement.

Don't do that, and your values will stay unique.

Cheers

Don't know of a way to do it like that, but you could write a query on the Catalog table in your ReportServer database to get the information, perhaps create...

Nice question, thanks.

Koen Verbeeck (1/8/2013)

---

Not sure what this question tries to teach us.

I spend 5 minutes looking for a mistake, only to finally decide there wasn't one, all joins seemed legit. I...

You can use an expression to give different values for the interval based on the parameter value:

=iif(Parameters!Parm1.Value = 10, 1, 50)

(if the parameter's value is 10, this sets the interval...

There's an Interval option on the Axis Options page of the Axis properties.

It sounds like you're hitting the double-hop problem, see if this link is any good to you:

http://blogs.technet.com/b/rob/archive/2011/11/23/enabling-kerberos-authentication-for-reporting-services.aspx

Cheers

Gaz

Nice, didn't know about that location! Certainly easier than parsing the XML...

The data wasn't wrong, what's wrong is the assumption that the data would be ordered when no order was specified.

That whole blog post could be rewritten into a fairly good...

Does this do it?

=Sum(iif(ReportItems!Test.Value = "Pass", 1, 0))

Cheers

Gaz

I forget exactly how SSRS 2005 passes in Multivalued parameters to the query, so this might not work, but one method could be

Use a delimiter function e.g. Jeff's one here:...

Nice question, thanks.

Or create yourself a Local Server Group in the Registered Servers tab in SSMS, this allows you to run multi-server queries in one window.

No problem, happy to hear it's sorted.

Cheers

Gaz

Nice question, thanks.