This is awesome, thanks. I haven't ever used CROSS APPLY so good to see it in action. Now I need to figure out how to only print a message if...

Quite annoying, but managed to solve it! In case someone is trying to do the same thing, i will explain the problem & solution:

For my report I wanted to pass...

Yes, the destination report works properly with both parameters when running stand alone. The spellings between both parameters are the same as well.

I have tried switching the parameters and it's...

Thanks for your response.

I managed to get it working with the field name rather than a parameter name, but as I am using an SSAS cube as my data source,...

This is great, thanks!! I can run it fine through Mgmt Studio CMS.

Thanks again

Doodles

That's brilliant - thanks guys.

I tried the Quest tool but when i scan it only seems to pick up one server! Not sure why but I didn't have too much...

I'm new to the company but my assumption is most are on the default ports but there will be a handful that have been changed...

Thanks for all the ideas guys!!

Maintaining two datasets is an inefficient way of doing things - but my data source is SSAS and i'm new to MDX so I would...

thanks for the response. i'm using two different tables because visually that's what the user wants.

I managed to get this working in the end though! Basically the same set of...

Thanks for that. It would have been the solution if I was using SQL as the data source, but I was using SSAS.

The solution was to basically modify the MDX...

thanks for helping me with this Steve. I tried out your expression but get an error along the lines of:

"The value expression for the text box "..." has a scope...

I'm not sure how i would go about doing that calculation as the data source is ssas...

let me try and use another example. So for example if you were reporting...

thanks for your quick response Steve, i've tried it out but unfortunately it doesn't work for me, but that's cause i haven't explained myself fully.

The user will be able to...

hi there

I am having exactly the same problem, however i am an ssas/mdx newbie and I wouldn't know how to go about exposing the ordering column as an attribute and...

That's exactly what i mean!! Just couldn't think of the logic...

Thanks so much for the response & taking the time to read through my post!

Doodles <-- loves forum bodhisattvas 🙂