SSRS Dropdown parameter cannot be blank!https://www.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a dropdown populated by a list of all available reports. Why? I want the report to be run with the 3rd and 4th parameter as OPTIONAL....

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Sort order a dropdown list in MS InfoPath without programminghttps://www.joellipman.com/articles/microsoft/infopath/sort-order-a-dropdown-list-in-ms-infopath-without-programming.html

21 July 2011 2007 (SharePoint 2007). The situation is that I started creating a SharePoint List (datasheet) and when I made my form dropdown read from the list, it just put elements in the order that I entered them in the datasheet. Googling this led me to browse...

• Type: Article
• Author: Joel Lipman
• Category: Infopath
• Language: *

ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

01 April 2025 to write and I would like to use it as a reference for when I forget how to do this. The use-case here is that we have a dropdown/picklist on a CRM invoice record that has the options of "Deposit" and "Final Balance". This rewrites the invoice line...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Add a template to the dropdown in Kunenahttps://www.joellipman.com/articles/cms/joomla/add-a-template-to-the-dropdown-in-kunena.html

20 September 2009 This is what I had to do to be able to add another template to the dropdown in the Kunena configuration panel: Download your site from your server to a copy on your local disk (hard disk, flash drive, etc) Make sure that the...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Problem creating SSRS report subscriptionshttps://www.joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 get them working. Custom DataSource Upload the report to the ReportServer. Hover the mouse cursor over it and click on the dropdown arrow to its right Select "Manage" in the dropdown menu Select "Data Sources" in the left menu Specify a "custom data...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Excel PivotTable Filter List Orderinghttps://www.joellipman.com/articles/microsoft/excel/excel-pivottable-filter-list-ordering.html

05 September 2011 There are several filters available on the report (only a few to keep it simple silly). When you click on the filter, a dropdown appears with all available values listed. The Problem The values are listed in alphabetical order at first. If any new...

• Type: Article
• Author: Joel Lipman
• Category: Excel
• Language: en-GB

Win32 Constantshttps://www.joellipman.com/articles/automation/autohotkey/win32-constants.html

05 July 2011 = $0002 Const TBSTYLE_GROUP = $0004 Const TBSTYLE_CHECKGROUP = (TBSTYLE_GROUP Or TBSTYLE_CHECK) Const TBSTYLE_DROPDOWN = $0008 Const TBSTYLE_AUTOSIZE = $0010 Const TBSTYLE_NOPREFIX = $0020 Const TBSTYLE_TOOLTIPS = $0100 Const TBSTYLE_WRAPABLE = $0200...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

05 July 2011 := "Input Value" COM_Invoke(pwb, "document.all.search_keywords.value", "Input Value") Dropdown Box Selection - selectedIndex Quote: Post Time Post Subject Topic Title Author Forum This is the HTML for the Sort By Dropdown. The following will set the...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: *

Joes Bug Tracker (JBT)https://www.joellipman.com/component/content/article/joes-bug-tracker-jbt.html?catid=40

07 July 2011 level - Added Admin Section: Manage Projects (each include all versions per entry) --- Project Name --- Category Name (dropdown of categories) --- License (textarea / option require or not) --- Specify Joomla! Article (for General Description) ---...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Creating a custom form field type for Joomla XML fieldsethttps://www.joellipman.com/articles/cms/joomla/creating-a-custom-form-field-type-for-joomla-xml-fieldset.html

25 October 2013 I'm writing a Joomla 2.5.x component for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 should click on to go into. In the bottom right, you can now select your Rocket Theme template (eg. Affinity) in the long dropdown and then click on "Add Module" and then on "Yes". Once added, return to inside the category ROKBB3 so that you can see...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Windows 7: System Clock is constantly going out of synchttps://www.joellipman.com/articles/microsoft/windows-os/windows-7-system-clock-is-constantly-going-out-of-sync.html

28 January 2010 Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

Windows Live Messenger: Error 80048820https://www.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 Change Settings button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: en-GB

Performance Report - Background colors based on dataset valueshttps://www.joellipman.com/articles/microsoft/ssrs/green-red-background-colors-based-on-dataset-values.html

02 December 2011 c.ItemID WHERE e.[ReportID] = @ReportParameter4 ) AS t1 ORDER BY t1.[TimeStamp] ASC Dataset for all reports (used for the dropdown parameters): SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name If you want to use these datasets, parameter...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

19 October 2021 a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing this quite a bit and wanted a quick way of extracting a SELECT list in someone else's...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

PHP Script: Make your own Thumbnail Generator via APIhttps://www.joellipman.com/articles/crm/zoho/php-script-make-your-own-thumbnail-generator-via-api.html

29 May 2025 it downloadable via URL. Why? Performance. I have a client with about 10k images of products that they want to appear in a dropdown menu of a JavaScript widget. When the user first loads up the webpage containing the widget, 10k images are downloaded. I...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Make Upload File Field Mandatoryhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-make-upload-file-field-mandatory.html

18 December 2024 the Create Page (Standard), Edit Page (Standard), and Details Page (Standard). My use-case has a requirement that another dropdown called "Order Type" has to be set to "Supplier". My file upload field is called "Order Confirmation". v_OrderType =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Uninstalling AEC Central and installing Community Builderhttps://www.joellipman.com/articles/cms/joomla/uninstalling-aec-central-and-installing-community-builder.html

20 January 2010 1. Go to your admin panel (back-end) 2. Extensions > Plugin Manager 3. Go to the bottom and change the display # dropdown to ALL 4. Disable Authentication - AEC Access 5. Enable Authentication - Joomla 6. Re-enable any other authentication plugin you...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Accessing a MySQL Database with Business Intelligence Development Studiohttps://www.joellipman.com/articles/database/mysql/accessing-a-mysql-database-with-business-intelligence-development-studio.html

05 January 2011 > select "Add Connection" Click on "Change..." Select "Microsoft ODBC Data Source" > OK Select the data source from the dropdown (the one you just created earlier should be listed) Enter credentials if necessary and click on "Test Connection" Expand the...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Creating a Profile Plugin for Joomla 1.6https://www.joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

27 April 2011 to use an example that worked for me. Important: This is for Joomla version 1.6.x+. Aim / Objective Add a field with a dropdown list. Add a button to upload an avatar (and sync with 3rd party avatar). Not riveting stuff but something that all my clients...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB