SSRS Hide results table if emptyhttps://joellipman.com/articles/microsoft/ssrs/ssrs-hide-results-table-if-empty.html

29 March 2011 value reliable if it's blank? The long way of doing this I would have called this article "Iteration within SQL Server Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX expressions"...

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

MySQL parameters in Excel 2007 PivotTableshttps://joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

24 August 2011 row or column), then click on it and select "Move to Report Filter". Shout in Gordon Ramsey-style: Done! Better than... MS Reporting Services? Yes by far. Fast, quick to setup and a big fat refresh button for the executives. SQL query returns individual...

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

SSRS Retrieving Oracle Stored Procedure Success or ErrorLevelhttps://joellipman.com/articles/microsoft/ssrs/ssrs-retrieving-oracle-stored-procedure-success-or-errorlevel.html

04 November 2011 We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is that there appears a link that will run a stored procedure...

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

SSRS Zero Paddinghttps://joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html

10 November 2011 would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment. My use for this was when displaying an audit log displaying the oracle errors. Oracle Errors An...

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

SSRS Dropdown parameter cannot be blank!https://joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 field) to make this all work. Notes: My convert part of my SQL query is because I had to match the datatype used by our reporting server for the ItemID field which is some sort of hexadecimal ID value that Microsoft are so very fond of. You will need to...

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

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

24 January 2012 when using these as a subquery which has an empty result set. Furthermore I am using this stored procedure in a SQL Server Reporting Services (SSRS) environment and don't want to return any rows if there are no matches (not a blank row either) as one of...

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

AwStats Data Parser (ADP)https://joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=40

03 April 2013 created this program to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data as to your unique visitors (referred to as visitors), the visits these generated...

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

Problem creating SSRS report subscriptionshttps://joellipman.com/articles/microsoft/ssrs/problem-creating-ssrs-report-subscriptions.html

11 November 2013 A quick article on if you are trying to create a new subscription to a SQL Server Reporting Server (SSRS) report and you are getting a warning message similar to the following: Message from webpage Subscriptions cannot be created because the credentials...

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

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 This article details a method we used on a search form in a SQL Server Reporting Services (SSRS) environment. The requirement (amongst others) was that the report ran in less than a few seconds. Analyzing the report through the ReportServer databases...

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

ZohoCRM: Deluge: Map a custom field from user profilehttps://joellipman.com/articles/crm/zoho/zohocrm-deluge-map-a-custom-field-from-user-profile.html

01 September 2021 (similar to team name) and wanted any Opportunity record to have a field showing the user's Division. This would help in reporting later down the line. How? The following code snippet will get the Opportunity/Deal/Potential record details, then get the...

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

Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://joellipman.com/articles/crm/zoho/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

19 October 2022 all the candidates belonging to the same school and updates some number fields on the matched CRM account. Why? For reporting purposes. Although Zoho Analytics can use data imported from both ZohoCRM and ZohoRecruit, it was helpful on the CRM record to...

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

Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://joellipman.com/articles/crm/zoho/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

06 July 2023 Additional: I'm just adding a little extra based on the further feedback, if we're generating a reporting year and week, we have to look at the difference between .toString("y") and .toString("Y"). Lowercase 'y' is the year and uppercase 'Y' is the year...

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

SSRS Use T-SQL Like with a Parameterhttps://joellipman.com/articles/microsoft/ssrs/ssrs-use-t-sql-like-with-a-parameter.html

04 April 2011 based on a user and given a date range. The problem is that there are a few thousand users and Microsoft's SQL Server Reporting Services interface isn't the most fun to scroll endlessly down. Advanced users can type the name really fast for it to...

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

SSRS Display question mark when date is blankhttps://joellipman.com/articles/microsoft/ssrs/ssrs-display-question-mark-when-date-is-blank.html

15 April 2014 to: Microsoft SQL Server Reporting Services 2012 Microsoft Visual Studio 2012 Premium Microsoft Windows 7 Enterprise What? So I have a column in an SSRS report which displays a date. Being rather pernickety, I would like a question mark to display if...

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