Viewing 15 posts - 2,491 through 2,505 (of 3,480 total)
"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
why not just write all the results to a temporary table and then just use one of the pivot table examples here on SSC? Look them up in the Articles...
May 27, 2015 at 10:03 pm
simple.
Drop constraints and then do what you want, then when you're done, re-enable the constraints. Probably better script the constraints to file, then after you drop, you can just...
May 27, 2015 at 9:59 pm
Forcing page breaks between each occurrence:
the rest is easy.
I created a calculated field...
=Fields!MajorType.Value & ", " & Fields!SubType.Value
and then in my report, I grouped by that calculated field.
May 25, 2015 at 11:52 am
Shouldn't you be able to join on WeekOfYear and DayOfWeek? Then you should be golden, right?
Sounds like you might be missing some columns in your Calendar table. Can you...
May 25, 2015 at 10:43 am
create another user, grant permissions, link user to login?
May 20, 2015 at 10:33 am
Not like this...
SELECT ProblemType, IssueMonth, IssueYear, SUM(IssueCount) AS MonthlyIssueCount, CInt(IssueMonthNumber) AS IssueMonthNumber
FROM qryIssueGroupedByYearAndMonth
GROUP BY ProblemType, IssueMonth, IssueYear, IssueMonthNumber
like...
May 20, 2015 at 12:44 am
Nothing to it. you need a calendar table for all the dates in your range. (Search around for articles, they're all over the place on here).
Once you have...
May 19, 2015 at 11:50 pm
Please read this article[/url] and follow the instructions.
Well, unless you don't really care about getting help.
May 19, 2015 at 4:12 pm
Viewing 15 posts - 2,491 through 2,505 (of 3,480 total)