As an fyi: https://stackoverflow.com/questions/37710776/how-to-install-microsoft-ace-oledb-32-bit-with-office-64-bit

This should help you get 32bit oledb working on a system with 64bit office.

I have seriously debated on writing a blog post specifically on this.

Have fun!

Where I am currently working, my predecessor, was not so diplomatic.  This has made several business managers loathe to work with me, in fear that I would treat them the...

Mark!

Thank you so much!  I have been so blocked on this issue.  I appreciate the quick response.

Here is a link from a blog post here on SSC: http://www.sqlservercentral.com/blogs/sql-quantum-leap/2017/12/30/please-please-please-stop-using-impersonation-execute-as/
This post goes over IMPERSONATION/ EXECUTE AS, it also details ideas on how to use Module Signing...

Here is my solution, I am completely willing to note that I sort of took the cheater's way out with the sub-query.  If given more time, I might have come...

Since this one really interested me, I figured I would create some sample data to test with.  If anyone is interested this is my sample set.  Out of the 3...

Did you try to "Omit" a parameter?  When you "Omit" passing a parameter, it takes a "TRUE/FALSE" value.  That should allow you to not pass the "StartDate" parameter to the...

My guess is that somehow you are looking at all values for Category on each "sheet".  Thus you would always have a single Category value of "Fruits".  A quick way...

Have you looked at the Category Group?  That is typically where I place my filters.  You just right click on the Category Group and then select "Category Group Properties".  Within...

Without knowing more information, the best I can offer is this solution: make your SSRS server standalone (unless the idea is to make the SSRS install in a cluster of...

Just a curious question but did my suggestions/ideas work for you? Or did you go a different direction?

Isabel -  how are you testing the page breaks?  I have found that from time to time, the "Preview" in BIDS/Visual Studio is buggy and does not display correctly.  To...

Here is a link that I used to learn how to page break after X rows:  https://jeffprom.com/2012/05/11/ssrs-page-break-after-x-number-of-rows/

The tablix group...

Thanks Lynn, I forgot that one.  =)