You can use them in seperate datasets in the report, but RS can't (won't?) merge them.  But you can if you use distributed queries in MSSQL (ie use a linked...

I think the last time i ran into this was when my grouoings on the rows weren't quite right.  The way i tested this ws to use the wizard to...

[Not for the faint-hearted, but] You could try encrypting the parm values and derypting them in the query string.  This would require you to write encrypt and decrypt fns.  ie...

Would you believe I posted a few paragraphs on this last week but for some reason it failed to hit the admin queue?!?!

Go to this url http://support.microsoft.com/default.aspx?scid=kb;en-us;842423 and hopefully, like...

Don't believe it can be done, unless you know how to edit your cab file and change the .inf and .rep files appropriately, as well as the taregt directory settings...

What is your definition of not working?  the linked server won't take the conxn string; or that the queries still run on the client?

Hey KennofromOz, Yukon help with this for a little (multi-role dims) but that doesn't help now does it

Not sure if it will work syntactically, but you could try putting a distinct in after the comma but before the descendants.  Distinct works at the begining of a row/col...

It (RS) uses VB.net as the code language, so somewhat similar to old VB (ie VB6).  unfortunately VB.net is the only code option unless you write external assemblies (which can...

I was thinking more along setting the read isolation level for all queries (ie set it against the database).

It's strange but I couldn't see the property in the GUI of...

It's been a while, but can't you set the lock type (read type) for the connection to the database.  E.g dirty reads versus repeatabe reads etc?

Either re-create them every time (painful I know) or alternatively you could RC o the project in the project explorer and select add existing item and then go to one...

Possibly you've installed Standard Edition?  Only Enterprise Edition supports data driven queries.

Not sure about the direct export but SoftArtisans(?) have a product that lets you both build reports and publish from word to RS but have also written an RS delivery...

Hi Jared,

You could write your own tool.  From what I've seen of the web service/s with AS2K5 this wouldn't be too hard to do.  The displaying is probably easier as...