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

02 December 2011 work on your reporting server as well. I'm using the database "ReportServer". select * from ( SELECT TOP 1 c.[Name] AS [ReportName] , e.[ReportID] AS [ReportID] , e.[TimeStart] AS [TimeStamp] , e.[Parameters] AS [Parameters] , e.[ByteCount] AS [Size] ,...

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

Before and After, Highs and Lowshttps://joellipman.com/articles/microsoft/ssrs/before-and-after-highs-and-lows.html

03 August 2011 2011 45 Report 003 287 2011 94 A working example using the ReportServer database in SSRS 2008 R2: SELECT Catalog.Name AS ReportName, DATEPART(dayofyear, ExecutionLogStorage.TimeStart) AS DayOfYearRun, DATEPART(week, ExecutionLogStorage.TimeStart) AS...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• 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 use another invokeUrl to 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...

• 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 ID v_AppOwner = "JoelGoHappy"; v_AppName = "ZohoInventory_eBayPictureServices"; v_FormName = "Inventory_Photo"; v_ReportName = "Inventory_Photo_Report"; m_Blank = Map(); m_CreatorParams = Map(); m_CreatorParams.put("Zoho_Inventory_ID",v_ItemId);...

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

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

14 March 2024 this record (use a custom report that only has the 2 searchable fields) var config = { appName : "joes_quote_builder", reportName : "Contacts_Report_SearchableByWidget", criteria : "(Primary_Email == \"" + v_ShopifyEmail + "\" && Shopify_ID == \"" +...

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

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 v_AppOwner = "myCreatorAppOwner"; v_AppName = "myCreatorAppName"; v_FormName = "eBay_Webhook_Payloads"; v_ReportName = "eBay_Webhook_Payloads_Report"; m_Payload = crmAPIRequest; v_Type = "Unknown"; l_SoapActions = List();...

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