This SQL statement will produce one row for each record found on the account_table for a given account number
We want also want to join the name and address table to the row. We only want one row from the …
Author: James
Active Reports 6 – Sort a collection in Active Reports
In this example, we take an unsorted Product Collection called ProductCollection that is assigned
to our report Data Source. We instantiate another Product Collection for sorting called
sortedProductCollection. Using a Do Loop, we read the Product Collection and build the…
SQL Server Reporting Services (SSRS) – Multiple IIf statements in an expression behind a textbox
Instead of using a code behind for simple decisions, you can use unlimited multiple IIf statements in an expression behind a textbox.
For example, let’s say you have a parameter called HoldType that can have 3 different values, (1, 2, …
Microsoft Silverlight – Setting Initial Focus on Silverlight Control
Even though you may have set focus to your first enterable textbox in a Silverlight Control, it will not truly receive the focus until the actual Silverlight control has focus first.
In order to do this, add a few lines …
SQL Server Reporting Services (SSRS) – How to Receive an Image into a Report Parameter to a SSRS Report
In this example, I will demonstrate how to convert an image in an Windows Form Application to a Base64 String that can be used to populate a report parameter that will be received into a SQL Server Reporting Services report …