Saturday, July 1, 2017

Power query for Excel

I was looking for the download link for office 2013, here it is if you ever need it.

Download from here :

https://www.microsoft.com/en-us/download/details.aspx?id=39379

Thursday, June 15, 2017

Open SSRS Linked URLS in a new window

Greetings....as I mentioned before sometimes I use my blog posts as a way to remind myself of the stuff that I need frequently and never keep to memory.

I needed to add a link in a new SSRS report and the link has to open in a new browser's window.

Just Right click on your report field, select "Text Box Properties", select "Action", click on the "FX" sign to write that special expression.


="javascript:void(window.open('" + Fields!URL.Value + "','_blank'))"


Assuming that your URL is dynamic and the column name is "URL" in your dataset

SSRS Link in  new Browser's Window
Hope that helps...