Oh, you are definitely right - all the situations you mentioned need a transaction log to ensure consistency quickly. Thanks so much for your expert explanation!

That is right! The filtering is done on the stored proc side rather than on the report/tablix side. Thanks again!

I am digesting the approach. I was hoping the users see all the teachers with the courses they taught. And if the users wanted to find teachers who teach particular...

That would mean have duplicate course list in the main report and subreport.

I was hoping there is a way to hide the main report record if the subrepot query didn't...

Do you mean add the filter parameter to the outer dataset instead of do filtering on reports?

Teacher's Name Courses (using sub-report)

John Smith ...

Thank you!

Thanks for your response. What I found is that the Folder setting at Home level didn't trickle down to the subfolders. I went to the subfolders and hit the...

Just an update:

If I used "local administrator" account to log into Report Manager, I can see the folder. Please help me understand why it is doing this?!

Sir, you are absolutely right! I double-checked the log backup maintenance job, the option "Back up the tail of the log, and leave the database in the restoring state" was...

I see your point. But that script was generated by SQL server studio management tool. I explicitly chose "Leave the database ready to use by rolling back uncommitted transactions. Additional...

The messages went away when the backup job ran on that server completed. Not sure how they are related.

Have you tried all the steps?

Thank you for pointing me to the right direction! I just tried your suggestions and it worked as expected. Thanks again!

I thought this was a very common task for people doing SSIS... I spent hours and hours debugging/testing and found that I need to change 'Data Type Properties' for 'Output...

Did you find the solutions? I am searching the answers to questions similar to yours...Haven't found one yet...