Queries & Parameters

Writing and Editing SQL Report Queries
The underlying SQL for a report is edited easily within the Report Editor interface in the "Command Text" section. The edit...
Sat, 23 Jul, 2016 at 4:43 PM
Viewing the SQL generated by QuickReportz on Execute
When a report is executed by the consumer QuickReportz generates a SQL command based upon the defined parameter types along with some additional metada...
Sat, 23 Jul, 2016 at 5:08 PM
Overview of Parameter Types and Common Attributes
There are several parameter types included within QuickReportz you can use to collect user input from report consumers.     Each paramet...
Fri, 27 Jan, 2017 at 8:47 PM
Using the String Parameter Type
The string parameter allows for a text value to be input by a report consumer in a text box. In addition to the to the common attributes available ...
Fri, 27 Jan, 2017 at 8:38 PM
Using the Number Parameter Type
The number parameter allows for a numeric value to be input by a report consumer in a text box. In addition to the to the common attribute...
Fri, 27 Jan, 2017 at 8:38 PM
Using the Date Parameter Type
The date parameter allows for a date to be input by a report consumer in a text box or using a calendar control.  In the following example two parameter...
Fri, 27 Jan, 2017 at 8:37 PM
Using the Boolean Parameter Type
The boolean parameter allows for a true or false (yes/no) to be input by a report consumer via a checkbox control.  In the example below, a parameter nam...
Fri, 27 Jan, 2017 at 8:47 PM
Using the Label Parameter Type
The label parameter type isn't really a parameter but provides a way to display information to the report consumer.  This is used commonly when creati...
Sat, 27 Aug, 2016 at 2:45 PM
Using the Dropdown Parameter Type
The drop-down parameter allows a report consumer to choose a single option. In addition to the to the common attributes available to...
Tue, 21 Mar, 2017 at 8:01 PM
Implementing Cascading Parameters
It is possible to chain drop-downs together, or other parameter type controls together so when an item is selected in a drop-down it will cause other ...
Tue, 21 Mar, 2017 at 7:55 PM