Search - Joel Lipman .Com

1. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... that key. I can't sit there entering 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 ...; Created on 12 July 2023
2. Performance Report - Background colors based on dataset values: / SQL Server Reporting Services /; ... and when comparing to the previous runs (using a second dataset) you can tell where changes were made and how this affected the reports' performance. What? What I'm trying to do is display a set ...; Created on 02 December 2011
3. SSRS - Lost window with datasets: / SQL Server Reporting Services /; Re: Business Intelligence Development Studio 2008 Often happens to me and not sure why. You open the project and the window panel for the Report Data containing the parameters and datasets isn't there. ...; Created on 25 March 2011
4. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... 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 status per contact per campaign (should be only ...; Created on 20 March 2023
5. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... ze the connection between CRM and ZIA: Click on ChatGPT CRM Click on Reuse Test on keeping conversation context: Still to do: Need to train it on ZohoCRM data with statistics and datase ...; Created on 06 March 2023
6. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; What? An article on the reasoning and steps to generate a dataset using Zoho's ANSI-SQL queries to generate the margins of each invoice in ZohoBooks. Why? We need to create a profits/losses dashboard ...; Created on 03 November 2022
7. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; What? This is an article to quickly demo a couple of snippets of code to display values in a custom related list as well as to display empty custom related lists. Why? Because I keep forgetting ...; Created on 30 July 2021
8. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... someone may want to open this in 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", ...; Created on 16 June 2021
9. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... "}: 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_RecordUp ...; Created on 17 July 2019
10. SSRS Stop Scrolling Behind: / SQL Server Reporting Services /; ... only ever display, the top rows of the dataset. Why? A lot of articles out there on the net are offering solutions that do the exact opposite. Basically, I want the opposite result of "Fixed headers ...; Created on 08 April 2014
11. SSRS: Performance Improvements: SELECT TOP: / SQL Server Reporting Services /; ... solutions dotted about the web but the biggest improvement was the "SELECT TOP 100" brain wave: -- DataSet1: SELECT TOP 100 Reference, Forenames, Surname, DOB FROM PersonsTable WHERE (Reference ...; Created on 07 March 2014
12. Oracle: order by subquery missing right parenthesis: / Oracle PL/SQL /; ... 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 clause in a subquery within an Oracle 11g ...; Created on 05 December 2013
13. No rows returned in Oracle causes SP to fail: / Oracle PL/SQL /; ... ), '???') FROM DUAL; The other issue The "other" issue was the problem after all. The first query was erroring despite the stored procedure compiling successfully. An empty dataset is ...; Created on 24 January 2012
14. Returning Oracle Stored Procedure Resultset in SSRS: / SQL Server Reporting Services /; ... As simple as this sounds, this is not a five-minute job. Even with all your SQL scripts with backups of your datasets, each of these will need tweaking. Create your stored procedure in Oracle (and ...; Created on 19 January 2012
15. SSRS Dropdown parameter cannot be blank!: / SQL Server Reporting Services /; ... entry and the end-user will be none the wiser. OLD: Dataset to populate the dropdown SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name ASC NEW: ...; Created on 14 December 2011
16. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; ... milliseconds it took for a report to execute... I decided to do a database level calculation using two datasets: -- Oracle 10g: DataSet1 -- your normal dataset query with an added field (ReportStartTime) SELECT field1, field2, TO_CHAR(systimestamp, ...; Created on 17 November 2011
17. SSRS AlphaNumeric Parameter Validation: / SQL Server Reporting Services /; ... then get the report 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 ...; Created on 07 November 2011
18. SSRS Retrieving Oracle Stored Procedure Success or ErrorLevel: / SQL Server Reporting Services /; ... report will execute the stored procedure without any problems. I added a second dataset on this report to select the updated data that this stored procedure commits but unfortunately SSRS process both ...; Created on 04 November 2011
19. SSRS Parameters in Oracle Stored Procedure: / SQL Server Reporting Services /; ... to a SQL Server 2008 R2 Reporting Service (SSRS) with Team Foundation Server 2010. The database with our stored procedure is Oracle 10g. The Stored Procedure Rather than a returned dataset, our ...; Created on 02 September 2011
20. SSRS Redirect after a report is run: / SQL Server Reporting Services /; What? This article serves to describe several workarounds or proofs of concept. Why? We have a first report which acts like a search page. You enter the student you are looking for by reference ...; Created on 12 August 2011