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

11 February 2011 Further rendering options: MS Reporting Services Device Information Settings To specify the zoom configuration (defaults to 100%) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Zoom=100% Note:...

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

Joes Quicklist Weblinks (JQW)https://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

03 July 2011 > Create a folder for your thumbnails. Go to "Extensions" > "Module Manager" > Click on module to publish/customize it. Specify the images folder as the one you created in step 2. Switch "STOP Thumbnail Service" to "NO" Specify a group which can...

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

Export/Import Database using MySQL Workbenchhttps://joellipman.com/articles/database/mysql/export-import-database-using-mysql-workbench.html

05 February 2013 section. Export/Import happens under the Server Administration section: Let's create a Server Instance, I'm going to specify the Take Parameters from Existing Database Connection option (note that I have obscured my personal settings in the following...

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

Administrator Program Shortcut without Prompthttps://joellipman.com/articles/microsoft/windows-os/administrator-program-shortcut-without-prompt.html

25 February 2013 7, Windows Server 2008 R2 Under the Actions tab, Click on New... Leave "Action" as Start a program for Program/Script, Specify the command path which is usually %windir%\System32\cmd.exe Add arguments in format /c start "Task Name" "Full Path of...

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

SSIS Skip Rows in Excel Source filehttps://joellipman.com/articles/microsoft/ssis/ssis-skip-rows-in-excel-source-file.html

04 April 2013 A quick article on how to skip rows or even specify a range to extract from the Excel file when using as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and...

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

Generate a Timesheet in MySQL https://joellipman.com/articles/database/mysql/generate-a-timesheet-in-mysql.html

05 December 2013 worked on creating a template for the site I just made; I started at 9:45 and finished at 12:00") The final system needs to specify every day of the week and divide all the days activities into the morning and afternoon slots. All days and time slots...

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

Display Feeds to major Social Networkshttps://joellipman.com/articles/web-development/display-feeds-to-major-social-networks.html

16 May 2016 with your facebook URL and replace My Facebook Page with the title of your facebook page. (You may need to specify the app in the Facebook developers tools but this may be for the write-back version). window.fbAsyncInit = function() { FB.init({ appId :...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

11 February 2019 Error Resume Next xTitleId = "JoelsTooCoolForExcel" Set WorkRng = Application.Selection Set WorkRng = Application.InputBox("Specify Data Range", xTitleId, WorkRng.Address, Type:=8) SplitRow = Application.InputBox("Specify Num Rows per Sheet", xTitleId,...

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

Zoho Creator: Receive eBay Order Notifications via Webhookhttps://joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

20 September 2021 = r_Api.API_Version; v_Endpoint = "https://api.ebay.com/ws/api.dll"; v_APICallName = "SetNotificationPreferences"; // // specify the URL of the CRM REST API Function here (can be a mailto:email@address) v_CrmRestFunction =...

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

Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttps://joellipman.com/articles/crm/zoho/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

21 September 2021 variable which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime; // // correction: I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1...

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

Zoho CRM: Upload a Product Photo using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-upload-a-product-photo-using-deluge.html

27 September 2021 upload the photo to CRM: // init v_AppOwner = "joel_the_awesomest"; v_AppName = "joels_app"; v_ReportName = "My_Report"; // specify your CRM record ID for this product v_CrmProductID = 1234567890123456789; // specify your Creator record ID holding the...

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

Zoho CRM: Schedule a Call using Delugehttps://joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-call-with-deluge.html

18 November 2021 // // system/application is set to EST (America/New_York) v_SystemCallTime = '2021-11-19 11:12:34'; // // manual setting to specify system/application offset v_ApplicationTimeOffset = "-05:00"; // // customer is in (America/Los_Angeles)...

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

Zoho Analytics: Setup DataSource via FTP Connectionhttps://joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

12 January 2022 Analytics, a description and then enter in the FTP details as per your configuration, then click on "Next": Step 2 of 2: specify whether first row are headers/column/field names. If necessary, specify the format of the data per column (in this example,...

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

Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

31 March 2022 of your Creator (in edit this application mode) Then go to Setup > Connections > Add Connection Select Zoho OAuth and specify the scope(s) ZohoInventory.items.READ (add some more if you're unsure...) Give it a connection name and note down the...

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

ZohoDeluge: Check Shipment Status via DHL APIhttps://joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

21 March 2023 */ // // initialize v_ShipmentStatus = "error"; v_TrackingNumber = ifnull(p_TrackingNumber,0); // // specify your DHL API Key (no need for the secret or base64 encoding) v_DHL_API_Key = "1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ"; // // build up header...

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

Zoho Deluge: Get All Orders from eBayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

29 March 2023 */ // // declare v_Page = 1; v_PerPage = 100; l_Pages = List(); // // specify the maximum number of orders you think you have on eBay (check eBay homepage and see number of sales [ will be rounded to nearest 1000 ]) // the actual number may be less than...

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

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttps://joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 TXT record itself will depend on your mail server or the domain registrar's website to manage your DNS: Create a TXT record Specify the Host as 1522905495316._domainkey.mycompany.com // Important: if hosted by GoDaddy, Ionos, FastHosts, and similar...

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

Border settings not saving in SSRShttps://joellipman.com/articles/microsoft/ssrs/border-settings-not-saving-in-ssrs.html

24 March 2011 first, then define which border (top, right, bottom, left) the settings apply to... Mad. 1. Type your expressions/specify color first: 2. Specify which border of the cell this applies to:

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

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

18 December 2024 m_Data = Map(); m_Data.put("data",l_RecordsToSend); // // this is REST API so by default all triggers run. Use an list to specify any triggers on update. Use an empty list to stop any. m_Data.put("trigger",{"workflow","approval"}); v_Endpoint =...

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

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

28 September 2009 to it in your main menu (or whatever menu) Return the RokBridge component in Joomla Admin Panel (Components > RokBridge) Specify the name of the Bridge Path (eg. forum) [THIS IS CASE-SENSITIVE (the name as displayed on your menu item)] Set the phpBB...

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