Assuming group is required, the following 57 results were found.
-
including shipping and tax. The second is to associate these to the invoiced items and work out the profit. The third is to group by the sales person, date, and customer so as to generate meaningful reports. The first dataset should be just the profit...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
the drama across the web, the system introduces only a few new fundamental improvements (particularly Access Control and Groups) which actually only means some minor database alterations. I've googled, yahood and binged, but still can't find a good way...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
This is an article to serve as a guide in terms of styling a radio group into a group of Tabs. This is only a guide or reference which was applied for one client but would need adapting to match the colors or style the next client wants. Why? The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
at the time of install. Also note, this module will NOT generate thumbnails if you select "Public" as the authorized service group. I know it's the default option but you need to select an user group with higher privileges like "Super User"....
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
to the template. Copy over Users: Rename the Admin ID in the new v34 system to match your v25 system. Check your usergroups are the same in both systems. Import new ones. Copy all users except the v25 admin to your v34 database (with status=blocked)...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
MAX(a.VisitorID) ID, a.VisitorIP IP, a.DateTimeStamp Date FROM custombu_stats_visits a WHERE YEAR(a.DateTimeStamp)='2010' GROUP BY a.VisitorIP ORDER BY MAX(a.VisitorID) DESC ) t1 LEFT OUTER JOIN wikimedia_user b ON t1.ID=b.user_id GROUP BY t1.IP ORDER...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
Another article on styling a radio group to become a weekly calendar carousel. In that a radio group displays the days of the week with arrows allowing the user to select the next or previous week. This is a follow on from my other articles on restyling...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
and environment. Our setup is: SQL Server 2008 Report Builder 2.0 BMC Service Desk Express 9.8 DataSet1: Incident # Group Name Close Date & Time Assigned to Full Name Incident Type The objective of this article is to explain how to hide "Series1" from...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
the new table `#_content` Import Users: export SQL file and amend the insert(s) into the new table `#_users` Import User Group Maps: export SQL file and amend the insert(s) into the new table `#_user_usergroup_map` Viewing Articles in the Administrator...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
// // reset and set radio group options clear input.Color_Picker; for each l_ColorRow in l_ColorPalette { for each v_ThisColor in l_ColorRow { input.Color_Picker:ui.add(v_ThisColor); } } Step 2: Replace the text with colored boxes //... // // reset and...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
this you should be on the following screen: Select the Report Type: For this calendar we want matrix because we're going to group based on the rows: Design the Matrix: Ok so we want weekday in the columns (to have mon-sun along the top), "Order" in rows...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
to select the exchange fields. Check/ensure the "In Use?" is ticked. Store/save your XET Setting up the Stu-Talk Message Group (SMG) This should be done before continuing as the remaining screens will refer to this and allow you to specify the related...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: *
-
1 Me,Myself,I Note that the following queries include the nested version because I find myself needing to group concatenate more often from another table then using data from the same table. MySQL SELECT ( SELECT GROUP_CONCAT(column_to_return_as_string)...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
line items, alongside the product name, list price, quantity, tax, etc. In the example below, we have added a column called "Group Name" in the CRM Quote module as per the following screenshot: How? Again at the time of this article, this is only...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
hour. Then I'll write the SQL queries to get the individual responses into a table with labels and columns that can help me group them (and identify which responses belong to which survey attempts). Then I'll write the SQL to sum up the responses per...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
INSERT INTO mydb_upgrade_j25.myprefix_jcomments ( id, parent, thread_id, path, level, object_id, object_group, object_params, lang, userid, name, username, email, homepage, title, comment, ip, date, isgood, ispoor, published, subscribe, source,...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
solution and can follow these quick steps: Right-click the grey header of the tablix row (left-most grey part) Select "Add Group" then "Parent Group..." Specify the "Group by" (in my case "Day"), the grey part will display a grouping icon Now select the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
WS_VSCROLL = $00200000 Const WS_HSCROLL = $00100000 Const WS_SYSMENU = $00080000 Const WS_THICKFRAME = $00040000 Const WS_GROUP = $00020000 Const WS_TABSTOP = $00010000 Const WS_MINIMIZEBOX = $00020000 Const WS_MAXIMIZEBOX = $00010000 Const WS_TILED =...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
developers, is that "two heads are better than one" does apply more than we think. A colleague of mine suggested adding a group by to the query which works (tested with both the keyword 'distinct' and without it with no difference in the response): //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
Mail to User” is set to “Yes” Test Joomla can message: Login to your Joomla Admin Panel Create a TEST joomla user group containing you (or if “Super Users” is a tiny group then use these) Navigate to Users > Mass Mail Users > Select the group you just...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB