Viewing 15 posts - 1 through 15 (of 99 total)
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!
July 14, 2021 at 5:31 pm
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...
June 28, 2021 at 6:39 pm
Mark!
Thank you so much! I have been so blocked on this issue. I appreciate the quick response.
March 15, 2021 at 4:56 pm
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...
January 29, 2019 at 10:29 am
December 13, 2018 at 12:10 pm
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...
November 9, 2018 at 10:15 am
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...
November 9, 2018 at 10:04 am
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...
November 2, 2018 at 10:11 am
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...
November 2, 2018 at 10:04 am
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...
November 1, 2018 at 11:24 am
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...
November 1, 2018 at 11:18 am
Just a curious question but did my suggestions/ideas work for you? Or did you go a different direction?
November 1, 2018 at 11:07 am
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...
October 30, 2018 at 8:14 am
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...
October 30, 2018 at 8:04 am
Thanks Lynn, I forgot that one. =)
October 29, 2018 at 4:00 pm
Viewing 15 posts - 1 through 15 (of 99 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy