Tag

#ssrs

12 blogs

  1. T-TSQL - Create 4 week Moving Total

    This article will offer you a way to calculate a 4 week moving total in SQL using SQL Server. There are more ways to Rome but this is a way you can use to calculate it using a date dimension.

    SQL Server, Power BI7 Dec 2015 · 7.4k reads
    7.4k

  2. Create a KPI box with an image / text overlap in SSRS

    A common wish in SQL Server Reporting is to create an image with a text inside the image. When you are a common user of SSRS, you know this is not so easy. You cannot simply insert an image and a ...

    Power BI1 comment1 Dec 2015 · 16.7k reads
    16.7k

  3. SSRS2008R2 - Keep Header Visible While Scrolling

    When you build a report in SSRS2008R2 and you want the top header to stay in place while you scroll down, you would normally expect the option "Keep header Visible While ...

    Power BI29 May 2013 · 3.8k reads
    3.8k

  4. Wrong dot and comma in SSRS

    In SSRS you can set in a cell how the value should be displayed. This can cause some problems if you do not know how to change certain settings. The dot and comma can be displayed ...

    Power BI13 May 2013 · 4.1k reads
    4.1k

  5. SSRS Sparkline: NOW and TREND

    The SSRS sparkline is a powerful little chart that shows a trend at a glance. Google Finance, for example, uses the sparkline to show the price of a share over the day, while ...

    Power BI13 May 2013 · 4k reads
    4k

  6. Target line/StripLine in Reporting Services

    In SSRS 2008 R2 you can add a target line to a chart. This is useful to show, for example, what the target is, so you can quickly see which values go over the target.

    SQL Server29 Aug 2012 · 4.9k reads
    4.9k

  7. The selected report is not ready for viewing

    Lately I have often been annoyed by the following error message: The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. ...

    Power BI12 Nov 2008 · 3.8k reads
    3.8k

  8. Problems when exporting to Excel

    When you make a report in Reporting Services, you often want to export it to Excel. Reporting Services quite often messes up the layout. For example, it often inserts columns ...

    Power BI10 Nov 2008 · 3.8k reads
    3.8k

  9. Passing a multi-value parameter to a drillthrough report

    This article describes how to pass a multi-value parameter from report A to report B the easy way. I fiddled around with it for a long time myself to get it working. The ...

    Power BI3 Nov 2008 · 3.3k reads
    3.3k

  10. Parameter security when exporting to Excel

    Parameter security In our environment we use an ASP.NET web portal to offer reports, which are all made in Reporting Services 2005. The security with regard ...

    SQL Server17 Sep 2008 · 3.3k reads
    3.3k

  11. Divide by zero SSRS / division by 0 #error

    Division by 0 is not allowed in Reporting Services/SQL Server. With this simple formula you can prevent division by 0, so the #Error message no longer appears in your report. This formula ...

    Power BI12 Aug 2008 · 5.5k reads
    5.5k

  12. 'Show All' in a parameter box

    Say you want to use a parameter in your report with, for example, the names of the countries where you have customers. You will often want a choice in your ...

    Power BI3 Aug 2008 · 3.3k reads
    3.3k
(12 rows affected)sqlblog.nl