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

03 August 2011 yesterweek, yestermonth, yesteryear and do the layout in PHP. Now let's say I have one RDL or SSRS Solution. I could do a dataset per SQL query but it doesn't seem that ideal. In Theory: SELECT ItemName, DATEPART(dayofyear, ItemDate) as DayOfYear,...

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

SSRS Redirect after a report is runhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-redirect-after-a-report-is-run.html

12 August 2011 report execution auto-redirect after are a report is run ssrs vbscript post report processing ssrs auto redirect based on a dataset value

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

SSRS AlphaNumeric Parameter Validationhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-alphanumeric-validation.html

07 November 2011 to complete the check: The Plan User enters value in parameters and clicks on "View Report" Report passes parameter to dataset which gets formatted by the database Report retrieves (select) formatted parameter as a field value to use Report loads with...

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

No rows returned in Oracle causes SP to failhttps://www.joellipman.com/articles/database/pl-sql/no-rows-returned-in-oracle-causes-sp-to-fail.html

24 January 2012 issue was the problem after all. The first query was erroring despite the stored procedure compiling successfully. An empty dataset is still an error it would seem. -- Error I was getting ORA-20001: 1234567:$:ORA-01403: no data found ORA-06512: at...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Zoho Deluge - Get Refresh/Access Token API v2https://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-refresh-access-token.html

17 July 2019 Happens if you don't convert the field-value pair dataset to a string: m_RecordData = Map(); m_RecordData.put("Field_To_Update", "Value_To_Put"); m_Data = Map(); m_Data.put("data",m_RecordData.toJSONList()); r_RecordUpdate = invokeUrl [ url :v_EndPoint...

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

Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-custom-related-lists-deluge.html

30 July 2021 is a tag discrepancy in the function. The related list cannot be displayed.: You are trying to return (an empty record dataset).

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

ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zohoanalytics-pivot-campaigns-vs-contacts.html

20 March 2023 This query needs each campaign name specified to see the results per contact person. You can only use this in another dataset which won't use a sub-query more than 2 levels deep. We're only displaying the maximum value alphabetically found in member...

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

Zoho Creator: Find Duplicates by Customer Name for Large Datasetshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-find-duplicates-by-customer-name-for-large-datasets.html

12 July 2023 one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records and that's only half of the production system's contacts. I needed a quick bit of code to find...

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

Oracle: order by subquery missing right parenthesishttps://www.joellipman.com/articles/database/pl-sql/oracle-order-by-subquery-missing-right-parenthesis.html

05 December 2013 the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue. I get this error when having to use an ORDER BY...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: *

Zoho Deluge: Generate and Send a CSV via Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-and-send-a-csv-via-email.html

16 June 2021 Google Sheets or Microsoft Excel: // // init l_NewCSVrows = List(); v_ThisEventTime = zoho.currenttime; // // loop through dataset for each r_Event in zoho.crm.getRecords("Events", 1, 200, "Year_Month:equals:2021-06") { v_ThisEventTime =...

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