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

20 January 2010 of good customer service. It only really manages the payment side and the complicated tasks of invoicing, but Community Builder provides more options for your website members. If Joomlapolis ever complete the CB Subscription component then there is no...

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

Community Builder in Joomla Vulnerabilityhttp://mail.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 I understand that visiting this site may harm my computer. Continue? Even if you use the latest versions of Community Builder (v1.2) and Joomla (v1.0.14) then you're vulnerable to a hack. Watch for users signing up with the .ru top-level domain as they...

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

SSRS Report Builder 2.0 - Error during processinghttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-report-builder-20-error-during-processing.html

06 May 2010 The Issue After modifying a report and on running it, Report Builder 2.0 returns the following error: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'DataSet1'. The...

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

Report Builder 2.0 - Hide Series1http://mail.joellipman.com/articles/microsoft/ssrs/report-builder-20-hide-series1.html

06 May 2010 it. The work around I've documented is a "solution" to my situation 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...

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

If Then Else in Report Builder 2.0 Expressionshttp://mail.joellipman.com/articles/microsoft/ssrs/if-then-else-in-report-builder-20-expressions.html

06 May 2010 WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0 I'm looking at the following if statement: If (MyFieldName = 0) Then Return 1 Else Return MyFieldName Can be...

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

ZohoCreator: Basic Widget with Zoho Datahttp://mail.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 a basic search on a table of data and returns one record as a result. The use-case here is that we are enhancing a quote builder form in Zoho Creator. The JS widget (aka the Quote Builder) will need to post a new quote to the system as well as show...

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

MessageBox or AlertDialog in Android Javahttp://mail.joellipman.com/articles/google/androidos/messagebox-or-alertdialog-in-android-java.html

20 October 2014 which you attach to some event import android.app.AlertDialog; import android.content.DialogInterface; new AlertDialog.Builder(this) .setTitle("Some Title") .setMessage("some message") .setPositiveButton("OK", new DialogInterface.OnClickListener() {...

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

Basic Android App using Google Maps and Current Locationhttp://mail.joellipman.com/articles/google/androidos/basic-android-app-using-google-maps-and-current-location.html

10 October 2014 Additional Additional: A little more control on the animation? CameraPosition cameraPosition = new CameraPosition.Builder() .target(myCoordinates) // Sets the center of the map to LatLng (refer to previous snippet) .zoom(17) // Sets the zoom...

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

Android: Function to let user take photo or choose existinghttp://mail.joellipman.com/articles/google/androidos/android-function-to-let-user-take-photo-or-choose-existing.html

04 November 2014 view) { final View v = getLayoutInflater().inflate(R.layout.dialog_edititem_photo, null); AlertDialog.Builder b = new AlertDialog.Builder(this); LayoutInflater inflater = this.getLayoutInflater(); b.setView(v); b.setPositiveButton("Take Photo", new...

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

Zoho Survey: Zoho CRM Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-survey-zoho-crm-webhook.html

01 October 2025 configure the webhook to return the Response ID, Email, and Survey ID: 1. Login to Zoho Surveys 2. Click on the Survey > Builder > Hub > Triggers > Webhook > Manage 3. Post URL is the REST API URL of the ZohoCRM function (this function) 4. Set Request...

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

Zoho CRM: Updating a CRM record Custom Line Items using API v7http://mail.joellipman.com/articles/crm/zoho/zoho-crm-updating-a-crm-record-using-api-v7.html

18 December 2024 ]; Additional Note(s): The trigger input can be workflow, approval, blueprint, pathfinder, or orchestration(for the Journey Builder feature). If "trigger" is not mentioned, the automation actions related to the API will get executed. Enter the trigger...

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

Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttp://mail.joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

04 February 2025 each category and hit save and close starting with the parent categories first Copying article heading images from SP Page Builder to normal Joomla Articles SELECT new.`id`, old.`id`, json_extract(old.`attribs`, '$.spfeatured_image') AS `image_src`,...

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

Error during processing - Converting Date/Timehttp://mail.joellipman.com/articles/database/t-sql/error-during-processing-converting-datetime.html

13 July 2010 their solutions but just check you haven't done this silly mistake. I'm only guessing the same error would happen in Report Builder 2.0 which I've stopped using as my day job wants us to use Business Intelligence Development Studio for all our SQL...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

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

05 January 2011 the Solution Explorer > select "Add New Report" Select the "Shared Data Source" you just created > Next Click on the "Query Builder" button Right-click on any empty space in the first frame > Select "Add Table..." Add and specify the query as you would...

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

Returned a data type that is not validhttp://mail.joellipman.com/articles/database/t-sql/returned-a-data-type-that-is-not-valid.html

06 January 2011 AS Month Solved by changing SQL statement to t1.Date AS Month This will return the SQL date but using your report builder or business intelligence development studio, you can specify in the report designer how to format the returned value to a more...

• Type: Article
• Author: Joel Lipman
• Category: Transact-SQL
• Language: *

Parameters not being used in report processinghttp://mail.joellipman.com/articles/microsoft/ssrs/parameters-not-being-used-in-report-processing.html

07 January 2011 convincing SQL script. This article is just a note on when using Business Intelligence Development Studio (BIDS) or Report Builder 2.0 and when previewing the report, the parameters are not accounted for (ie. the SQL query creating the dataset does not...

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

SQL Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/database/t-sql/sql-calendar-in-business-intelligence-development-studio.html

14 January 2011 if you bear with me as I add captions to the below screenshots: Design the Query: So copy the above text, click on query builder and "edit as text", then paste it into there. When you ok this you should be on the following screen: Select the Report...

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

URL passed settings in Reporting Serviceshttp://mail.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 Customize the Toolbar (Advanced) To enter custom code for a report, view the report properties, the first field in Report Builder or Business Intelligence Development Studio (BIDS) is "Code". Click on the browse button next to it to edit. Visit...

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

Room Availability Calendar in Business Intelligence Development Studiohttp://mail.joellipman.com/articles/microsoft/ssrs/room-availability-calendar-in-business-intelligence-development-studio.html

23 March 2011 in the "data" cells. 2. Use the SQL code above: So you can paste this straight into the textarea or use "Query Builder". 3. Select Matrix Tablix: We want all rooms on the left and the time along the top. We select a matrix because this will...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: *

Android OS: Add GoogleMap as fragmenthttp://mail.joellipman.com/articles/google/androidos/android-os-add-googlemap-as-fragment.html

25 November 2014 // adding marker googleMap.addMarker(marker); CameraPosition cameraPosition = new CameraPosition.Builder() .target(new LatLng(17.385044, 78.486671)).zoom(12).build(); googleMap.animateCamera(CameraUpdateFactory .newCameraPosition(cameraPosition)); //...

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