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...

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...

Forcing page breaks between each occurrence:

http://stackoverflow.com/questions/11285923/tablix-repeat-header-rows-on-each-page-not-working-report-builder-3-0

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.

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...

create another user, grant permissions, link user to login?

Not like this...

SELECT ProblemType, IssueMonth, IssueYear, SUM(IssueCount) AS MonthlyIssueCount, CInt(IssueMonthNumber) AS IssueMonthNumber

FROM qryIssueGroupedByYearAndMonth

GROUP BY ProblemType, IssueMonth, IssueYear, IssueMonthNumber

like...

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...

Brent Ozar's BlitzIndex[/url]

Please read this article[/url] and follow the instructions.

Well, unless you don't really care about getting help.

the data type of schoolyear is nvarchar.

well, there's your problem. Convert it to an INT and you're good to go. (And for heaven's sake, fix all those stupid...

alternatively, you could push from within Access. created linked tables in Access to your SQL Server database(s). Create append queries that select data from the Access tables. Write a...

there are a bunch of SSRS tutorials from super simple to reasonably complicated on YouTube... look up WiseOwl. Worked for me. (because you can watch, stop, try, watch...)

create a whole bunch of linked SQL Server tables in your Access database.

Create queries to append the local table data to the backend SQL table.

then you could do something like

DBEngine(0)(0).Execute...

Best milkshakes ever. I don't like that boss very much.

Jeff,

I would agree the MCM is a different beast. It's more realistic (and difficult) than the standard multiple choice tests. Even I can pass those!