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, …
Month: April 2012
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' …