Viewing 15 posts - 1 through 15 (of 22 total)
Hi Jonathan,
Thank you very much for all your help. I have eventually managed to create the bell curve in SSRS by using your equation as an expression in SSRS rather...
August 15, 2019 at 9:21 am
What is PI() ? I don't see it in the list of math functions. I'm on 2008 thou, maybe it was added in 2016.
Ah, that was meant to be...
August 9, 2019 at 2:54 pm
Hi Jonathan,
Thank you very much for your help. I have created the tvf on our test database but I'm quite a novice when it comes to SQL so I don't...
August 9, 2019 at 10:47 am
Yes, post some data.
SQL will only be able to return a list of (x, y) points for the curve. You'll have to get SSRS to plot the curve from...
August 8, 2019 at 10:59 am
Thank you all for the replys.
I was away yesterday so couldn't reply to any of you. I have posted a similar thread in the SSRS forum but only got one...
August 8, 2019 at 8:38 am
Hi Sue,
Thanks for the reply but I'm struggleing to get a bell curve out of this, all I'm getting is a straight line.
Can you check the SQL I have used...
August 6, 2019 at 10:09 am
Hi Thom,
Thanks for your reply but I may have solved it.
I just put 'nothing' instead of the '0.00' at the end:
=SUM(iif(Fields!Days_over.Value < 30,(Fields!CostsNet.Value),nothing))
In terms of adding up...
July 11, 2019 at 8:35 am
In fact, in many countries (such as the European Union), it’s downright illegal to do what you are suggesting you need to do.
No it's not, not even in the slightest.
Who’s...
April 30, 2019 at 2:24 pm
We already know the passwords I'm the one that creates them! All we want is a secure place to store them (among other details) that's why we have created a...
April 30, 2019 at 10:54 am
Well we have stored these passwords in a custom table created by our front-end application, the encryption is also handled by our front-end application so I don't really know specifically...
April 30, 2019 at 10:07 am
Ah right I think wires are being crossed slightly. I want the field to remain encrypted on the SQL server as it contains users passwords. I was just wondering if...
April 30, 2019 at 9:36 am
If you don’t know how to do that, it would suggest you don’t have permission to decrypt that value; and therefore shouldn’t be trying to.
Or maybe I don't know how...
April 30, 2019 at 9:24 am
Hi Thom,
Thanks for the reply, I was sort of clutching at straws posting on here as I have already found this which is a bit long winded but I...
April 12, 2019 at 11:25 am
I've actually managed to sort this out for myself, I created a separate dataset that just returned the values that I wanted for my parameter and then used that.
September 28, 2018 at 3:48 am
September 25, 2018 at 5:04 am
Viewing 15 posts - 1 through 15 (of 22 total)