Category Archives: Business Intelligence

Easy error Log checking

At first at my current job as a DBA, I was not checking SQL Server error logs every day.   Then I started checking production daily to crack down on deadlock issues.  But I was not checking all of the … Continue reading

Posted in Business Intelligence, Database Administration | Tagged , , | Leave a comment

SSRS align text to bottom of page

There was some text I wanted to display at the bottom of a page.  I couldn’t use a footer, because it was all part of a table, with a border. The trick that solved it was this: Add a text … Continue reading

Posted in Business Intelligence | Tagged | Leave a comment

SQL Display time with seconds and AM PM

Instead of showing 12:00:00.0000000 I wanted to display 12:00:00 PM There were some solutions built in for displaying 12:00 PM. However, I wanted the seconds to show as well. Here are some ideas.  Grab the 2 right-hand most characters from … Continue reading

Posted in Business Intelligence | Tagged | Leave a comment

SSRS format US Phone numbers

I have resorted to taking care of this in the stored procedure.  If you have a good way of doing it inside of Visual Studio, let me know in the comments! The T-SQL looks like this. I believe I got … Continue reading

Posted in Business Intelligence | Tagged | Leave a comment

SSRS tablix filter – allow multiple values and NULL

Sometimes it is preferable to filter a tablix on the SSRS side, instead of within the stored procedure.  Usually I do it to avoid using sp_executesql.  In these cases, I’d rather filter the data post-query than make my query harder … Continue reading

Posted in Business Intelligence | Tagged | Leave a comment

SSRS null data parameter in filter

I wanted to filter a date in my Tablix to be greater or equal to than the parameter date.  The only thing was, the parameter may be null.  I tried to think ahead to handle this case, and use the … Continue reading

Posted in Business Intelligence | Tagged | Leave a comment

SSRS subreport not refreshing

I wanted to display some static fields in a subreport, particularly when the DataSet did not return any records, via the parameter that was passed in.    Naively I thought this would work, and when it didn’t, I thought that … Continue reading

Posted in Business Intelligence | Tagged | Leave a comment