Viewing 15 posts - 2,491 through 2,505 (of 3,489 total)
What I ideally want it to do is if I run the report today (May) it will only show me the last 12 months so May to May.
Why not add...
June 2, 2015 at 10:32 pm
Bummer!
PowerBI is kinda cool, but there are some things that are head scratchers for me. In SQL Server (and SSRS), parameterized stored procedures are your friend. In PowerBI,...
June 2, 2015 at 6:17 pm
Jason Selburg's article maybe?
http://www.sqlservercentral.com/scripts/Miscellaneous/31733/
June 2, 2015 at 9:33 am
the answer was here the whole time... all you had to do was search for it.
June 1, 2015 at 9:03 pm
Okay, you've been here a while... Do you REALLY need to crosspost?
June 1, 2015 at 4:41 pm
CTEs require that the statement before the CTE is terminated with a semi-colon, so one is generally added in front of the definition of the CTE. Kinda weird, but there...
June 1, 2015 at 11:55 am
That's what happens when you sleepcode... you do silly things. For some reason I totally forgot about ABS()...
June 1, 2015 at 11:51 am
Not a very helpful article. A really helpful article would have gone something like...
Here are some places where you might consider a cursor...
Here are places where you just...
June 1, 2015 at 11:20 am
Oh, if you're doing this as an HTML file, you can use the last-child pseudoclass to format the last row of a table.
May 31, 2015 at 10:43 pm
"I have a scenario to bold the total row coming from view."
Where are you trying to do this? If you're doing it in SSRS, it's pretty easy. But then you...
May 31, 2015 at 10:26 pm
Welcome to SSC! You'll find that you'll get better and quicker answers if you follow the instructions in Jeff Moden's article "How to get best help" http://www.sqlservercentral.com/articles/Best+Practices/61537/
code="sql"]use tempdb;
go
create table...
May 31, 2015 at 10:20 pm
check out the WiseOwl tutorial on youtube on how to create datasets and filtering. Helped me a lot.
May 31, 2015 at 2:29 pm
Why would a hidden dataset show? By setting it as hidden, you're telling SSRS not to show it.
Not sure there are any books specifically on MDX and SSRS. (Checked...
May 31, 2015 at 2:10 pm
looks right. You have to create a dataset pretty much anytime you're connecting to a different database object (table, query, stored procedure, whatever).
May 31, 2015 at 12:28 pm
don't think you can do it directly. You could create views that include the primary key and then grant a group of users update permissions on the view.
May 27, 2015 at 10:04 pm
Viewing 15 posts - 2,491 through 2,505 (of 3,489 total)