Viewing 15 posts - 136 through 150 (of 152 total)
Isn't that the same as the user picking everything in the list? If so the multi value parameter has an 'All' option as standard which makes picking everything nice...
April 16, 2012 at 1:57 pm
Yeah, I'm aware of the error. I'm just struggling to understand why you'd need a null if you've got a multi value parm. Null normally means nothing or...
April 16, 2012 at 1:27 pm
Maybe I'm missunderstand the problem but I dn't think you need to do anything at all to support that. You just make it a multi valued parameter. The...
April 16, 2012 at 9:10 am
It looks like you're most of the way there already. That query is going to return you a datset with all your AgreementGroups plus an empty record. In...
April 16, 2012 at 3:29 am
Solved it using a sub report. I knew the answer would be obvious. I think I'd just got it into my head that I wanted to use a...
April 12, 2012 at 7:08 am
I agree it does seem likes a bit of a hack!
Meh, it wouldn't be the first and I'm sure it won't be the last.
Glad I could help...kind of
There's no "kind...
April 4, 2012 at 12:03 pm
Thanks. That sort of works. I don't need to create the datasets, I can just specify values in the parameter rather than getting from a query. And...
April 4, 2012 at 10:02 am
In any given version of the framework there'll be a few subtle differences between the two. But MS have a policy of converging them so any new feature that's...
March 28, 2012 at 8:13 am
That would make sense. I've noticed SSRS does tend to hold lists as delimited strings so a overall character limit is likely. It's interesting that the posters in...
March 28, 2012 at 7:46 am
Ooh, just tried it and, actually, I think I prefer it to creating elements direct from the tables. This would give me much more control, save me loading up...
March 20, 2012 at 3:03 am
Ah, didn't realise you could create dsv entities from queries. That'll do it for me in a pinch. Thanks.
Is there a way I can just affect the join...
March 19, 2012 at 2:01 pm
You're on SQL2008: why don't you use table valued parameters?
I hadn't realised that you could pass table variables as parms. That's a huge improvement for me and definately beats...
March 13, 2012 at 8:35 am
I don't think you can do it by passing more than one row in, I'm afraid. Whenever I've come across the requirement to call a sproc based on more...
March 13, 2012 at 3:36 am
"running hunches",
Yeah, I think that's the real benefit to the company. They won't really understand that until they get it and start playing though. I'm selling the...
March 9, 2012 at 10:56 am
Just tried using excel against a simple cube a colleague had created previously and it looks like exactly what I was after. I've got a slightly more involved cube...
March 9, 2012 at 7:13 am
Viewing 15 posts - 136 through 150 (of 152 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy