Another BI & Programming Blog - Jason Yousef

Recently I was tasked to edit an old SSRS report, the report has multiple columns and I need to change the font weight to BOLD based on a specific value. It's so simple but annoying that it needs to be done manually to all the columns that you need the expression to check. which was 25 columns in my case! Steps: Right-click on the column and select "text Box Properties" Select "Font" from the left menu Next to BOLD click on the expression menu In the expression screen; write the expression based on your column and the condition. =IIF(Fields!JB.Value > 0, "Bold","Normal") So here I'm setting the Property "FontWeight" of the textbox to be "Bold" when the value is greater than 0, otherwise, you're setting it to "Normal". hope that helps!

Why would you learn Splunk! Why particularly I choose Splunk! In today's world, data is king! we know that as a BI developers already !!  and cybersecurity is a critical component of every organization's IT infrastructure. As a business intelligence and data scientist developer, you may have heard of Splunk, a powerful software platform used for analyzing and monitoring machine-generated data. If you are looking to enhance your career and be open to new opportunities in the new hot trend of cybersecurity, learning Splunk and getting certified can be a game-changer for you, you still also can write dashboards, reports and alerts in Splunk! Yep!! So, why should you learn Splunk and get certified in it? Let's take a closer look at some of the reasons why Splunk is the future of cybersecurity. Splunk is a Leader in the Cybersecurity Industry Splunk is one of the most widely used cybersecurity tools in the industry. It has been recognized as a leader in the Gartner Magic Quadran...

Learning Splunk, or any new technology, can be challenging at any age, but it's never too late to start. In this series I'll blog and document my personal experience at age of 40 to learn about Splunk to get certified to further enhance my career Here are some tips that can help you learn Splunk quickly and effectively: Start with the basics: Familiarize yourself with the Splunk architecture and its core concepts, such as indexing, search, and reporting. Why? How? When? Get hands-on experience: Splunk is a tool that can be learned best by doing. Create your own instances and practice with sample data to get a feel for how it works. How? Cost? When? Take online courses: There are many online courses and tutorials available that can help you learn Splunk quickly. Consider taking an online course to get a comprehensive understanding of the tool. Where? Cost? When? Join the Splunk Community: The Splunk community is a great resource for learning and getting support. Join the Splunk ...

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

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...

Hi, Today's requirement is to create a month's table, to be used in a SSRS report parameters, to be passed to a stored procedure. the parameters needs to have Month Name, Number, Abbreviation, Start and End of month. Please find the T-sql code below: ; WITH months (MonthNumber) AS ( SELECT 1 UNION ALL SELECT MonthNumber + 1 FROM months WHERE MonthNumber < 12) SELECT MonthNumber, DATENAME( month , DATEADD( month , MonthNumber, -1)) AS [MonthName], UPPER ( LEFT (DATENAME( month , DATEADD( month , MonthNumber, -1)), 3)) AS MonthAbbr, DATEADD( month , DATEDIFF( month , 0, CONVERT ( VARCHAR (2), MonthNumber) + '/1/' + CONVERT ( VARCHAR (4), YEAR (GETDATE()))), 0) AS StartOfMonth, DATEADD(d, -1, DATEADD(m, DATEDIFF(m, 0, CONVERT ( VARCHAR (2), MonthNumber) + '/1/' + CONVERT ( VARCHAR (4), YEAR (GETDATE()))) + 1, 0)) AS EndOfMont...

Today I was checking a question on one of the forums about trimming a leading zero from a string, and the string has characters, also has middle and ending zeros, so the methods that comes to your mind quickly won't work !!  If you're thinking about converting to INT then to a string again ! so I thought about a script component that uses the .NET (String.TrimStart Method) you can read about it more here : http://msdn.microsoft.com/en-us/library/system.string.trimstart.aspx here's the input scenarios that I came with and the output results.... Steps: 1-I created a flat file (TXT) with punch of rows to test 2-Only one output from my flat file for simplicity, named Col0 3-script component (transformation Type), using Col0 as input. 4-created an output column Col0Cleaned   5-added the above highlighted line... and that's' it!   Please let me know if you have any scenarios that this solutions couldn't fix! package and solution can be do...