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

11 February 2011 to the name and folder of your report. To hide all except the report (default is True) http:///ReportServer/Pages/ReportViewer.aspx?%2fMYREPORTS%2fDemos%2fRB+Report+for+Me&rs:Command=Render &rc:Toolbar=False To hide just the parameters (default is True)...

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

ZohoCRM: Using Criteria with Module Record Counthttps://www.joellipman.com/articles/crm/zoho/zohocrm-using-criteria-with-module-record-count.html

14 November 2023 Not sure about the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working examples I use in production systems: Pre-amble: I'm...

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

Background Gradient Disappears on Long Pageshttps://www.joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 background (blue) making the text very hard to read. Why? Took me a while to figure out what was the problem, I'd visit some pages and they'd be fine, but when visiting a long page, it would initially display properly but then the white background would...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-searchrecords-with-sorted-results.html

10 February 2022 the standard searchRecords() and then the getRecords() functions: Set the record ID to your own record ID. Set the list of pages to the number of pages you want to search. Keep in mind script execution limits set by Zoho. Set the search criteria string...

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

Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

20 February 2023 this, I'm building on top of my initial GraphQL query which will now retrieve 10 products per page and loop through 3 pages for use in Zoho Deluge. If this works, we can increase the number of pages as well as the number of products per page: The...

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

ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

01 March 2023 is that it asks you to set an estimated number of products that are in your listing, it will then generate the number of pages it thinks it has to loop, so try and give a number higher than the actual number of products you have in your shop, it will...

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

Zoho Deluge: Get All Orders from eBayhttps://www.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: *

ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 */ // // initialize v_CountTotal = 0; v_CountUpdated = 0; l_Pages = {1}; v_PerPage = 1; // for each v_Page in l_Pages { l_Deals = zoho.crm.getRecords("Deals", v_Page, v_PerPage, {"cvid":123456000012345678}); for each m_Deal in l_Deals {...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 It may look clean, clear, obvious... it's just an outline of what I picture as a perfect project; unfortunately the first 2 pages tend to be completed in just over a day and the rest of the time is spent faffing around with design and functionality. We...

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

Zoho Creator / Shopify: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-shopify-get-all-active-products.html

12 October 2021 + "@" + v_ShopID; v_ShopifyApiVersion = "2020-01"; // // loop through 2500 records v_LastID = 0; l_ProductIDs = List(); l_Pages = {1,2,3,4,5,6,7,8,9,10}; for each v_Page in l_Pages { v_Endpoint = v_ShopifyURL + "/admin/api/" +...

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

ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

08 February 2023 ????-??-?? (??? - ???) - ******************************************************************************* */ // // list of pages to loop through (note: issues with multiple pages, do 1 at a time) l_Pages = {1}; v_PerPage = 200; for each v_Page in l_Pages...

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

ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

24 August 2021 are at least 10 thousand if not 100 thousand records. The code I use is a for loop within a for loop or in other words 5 pages (as each page is limited to 200) and 1000 records is the sweet spot in which case the loading bar disappears but the function...

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

Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

15 April 2024 then we'll include the code to count the total number of products, and then finallly show the code to loop through all the pages to retrieve every product from the WooCommerce system. API connection in WooCommerce So we need to get an API connection to...

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

GDPR Privacy Policyhttps://www.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 and dislikes by gathering and remembering information about your preferences. We use traffic log cookies to identify which pages are being used. This helps us analyze data about webpage traffic and improve our website in order to tailor it to customer...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Privacy Policyhttps://www.joellipman.com/static-items/privacy-policy.html

30 May 2009 and dislikes by gathering and remembering information about your preferences. We use traffic log cookies to identify which pages are being used. This helps us analyse data about webpage traffic and improve our website in order to tailor it to customer...

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

Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

07 May 2024 going to use ZohoCreator and its PDF rendering options. What's wrong with just using CSS? It looks beautiful on ZohoCreator pages but then you hit the PDF button and it pretty much vomits your output back to the 90s. The code snippet below is just for a...

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

MacOs: Transcribe Training Video using OpenAI Whisperhttps://www.joellipman.com/articles/apple/macos-transcribe-training-video-using-openai-whisper.html

23 June 2025 it. [Score: 1/10 for effort] I gave the transcript.txt file (all lowercase no punctuation) to ChatGPT as an attachment (~100 pages) and gave it the following prompt: rephrase the following so that it makes sense to a trainee: "" // wait for completion...

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

Terms & Conditionshttps://www.joellipman.com/static-items/terms-conditions.html

30 May 2009 to the user or viewer of our website. The use of this website is subject to the following terms of use: The content of the pages of this website is for your general information and use only. It is subject to change without notice. Neither we nor any...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Anti-Spam override for all submitted datahttps://www.joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

03 February 2010 quite a simple fix and I will hopefully be able to keep it simple for non-programmers. The tweak below will stop any of your pages submitting content containing your banned words. We're going to modify a file containing 2 lines of code by default. The...

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

Running Internet Explorer 6, 7, 8 as standaloneshttps://www.joellipman.com/articles/microsoft/windows-os/running-internet-explorer-6-7-8-as-standalones.html

18 May 2010 Your IE7 standalone will return a few errors but for basic browsing it will navigate to other pages and it will identify itself as IE7 to sites that check your browser details (see below - Additional Info) The Free Virtual PC solution (Requires ISO or...

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