April 2012 – James Software Development Corner

Microsoft Office 2010 – Change the NavePaneSearch to the old Find and Replace dialog box (Ctrl-F)

I personally don’t like the new NavPaneSearch.

You can change the behavior of Ctrl-F to bring up the old ‘Find and Replace’ dialog box.

a) In options, click ‘Customize Ribbon’
b) Click the ‘Customize…’ button to the right of label, …

Active Reports 6 – How to display page header information on a subreport within a parent report

You can create a page header for a report, but if that report is used as a sub-report, the page header and page footer of that report does not render. Instead, only the parent report’s page header and page footer …

Active Reports 6 – How to communicate from sub report to parent report

The following illustrates one way to communicate information from a sub report back to its parent or main report. It may not be the cleanest way, but it works.

Let’s say you have a main report, RPT-001.rpx. This report has …

SQL Server – Convert NULL to 0 in Select Statement

The first SELECT statement gives you a value of ‘NULL’.
The second statement gives you a value of ‘0’ because the true value returned is
‘NULL’

SELECT SUM(number_of_whatever) AS CalculatedValue
        FROM some_table
        WHERE some_column = 'some_value'
          AND (some_date_column = '2011-12-01'

…