Creating a new SSRS report

When creating a new SSRS report, there are some things you need to keep in mind:

• Security, you will need to set up a privilege that not only has the menu items you will be using, but also the TMP tables that the report uses.  The error you get when you leave off the TMP tables looks similar to a Management Reporter security issue so you might end up running in circles when the answer is right in front of you.
• When editing a report in Visual Studio, the checkbox in the Table properties to repeat headers on a new page does nothing.  You will need to use the advanced view on the groups list to see the static headers, click on the and set RepeatOnNewPage to True.