Viewing 15 posts - 1,516 through 1,530 (of 3,482 total)
I used to work at a company that did healthcare data reporting. I was stupefied when I found full names, birthdates and SSNs in the database. Went straight to the...
May 31, 2017 at 6:04 pm
Remove the defaults. You need at least one that doesn't have a default value for SSRS to prompt you for values. Otherwise, the report will just run with the defaults....
May 31, 2017 at 5:56 pm
You do realize that the data types for your parameters and the field types and sizes in the underlying table don't match, right? If you want to pass multiple values...
May 31, 2017 at 3:49 pm
Sounds like you need to put a rectangle on your report and then you can put the textboxes inside of it. That way, you can arrange them like you can...
May 31, 2017 at 2:50 pm
May 31, 2017 at 1:28 am
Why not play with each one and decide for yourself? R support is already built into SQL Server.
May 29, 2017 at 11:49 pm
I got the chunks apart... So I guess it's a place to start. You need Jeff's string splitter function for this, which is here. And here's my code......
May 29, 2017 at 11:27 pm
May 26, 2017 at 11:50 am
Got it to work... probably a kludge, but ...Summarized in T-SQL first:SELECT SalesRep
, SUM(Sales2016) AS Total2016
, SUM(Sales2017) AS Total2017
, SUM(Sales2017) - SUM(Sales2016) AS Delta
May 25, 2017 at 9:48 pm
In a t-sql 2012 database, I am suppose to count the number of times...
May 25, 2017 at 8:48 pm
That's a drilldown report. It's covered in Brian Larson's book... and probably all over the place. Here's a super quick video on YouTube.
May 25, 2017 at 3:18 pm
Okay, just tried it with my own dataset. Turns out, I can't find a way to sort on an aggregated column in a matrix.
So if you base your...
May 25, 2017 at 3:01 pm
Don't think you need a new dataset. What you're describing sounds like you need a Matrix on your report.
Group on [Diagnosis Code], then at the intersection, do COUNT().
You...
May 23, 2017 at 12:28 pm
Got Google?
May 20, 2017 at 9:15 pm
Did you look up the differences between DECIMAL, MONEY, and SMALLMONEY?
May 20, 2017 at 7:05 pm
Viewing 15 posts - 1,516 through 1,530 (of 3,482 total)