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

10 November 2011 Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting...

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

Regular Expression Basic Usage Exampleshttps://joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

28 October 2013 you use the regular expression: a+ This expression matches all of the following: a aa aaa The expression does not match: bbb Zero or One — Question Mark The question mark matches zero or one--and only one--occurrence of the preceding character or...

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

XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html

13 August 2014 of acceptable values fractionDigits Specifies the maximum number of decimal places allowed. Must be equal to or greater than zero length Specifies the exact number of characters or list items allowed. Must be equal to or greater than zero maxExclusive...

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

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

29 March 2011 WHERE re.RoomId=@GivenRoom AND re.SetId=@setId This seems to have problems because when there are no matching rows (so zero results), BIDS doesn't seem to know what to do with this. We could add a row with a SELECT UNION statement but I found this can...

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

Unix Date Format Specifiershttps://joellipman.com/articles/linux/unix-date-format-specifiers.html

05 July 2011 +) Specifier Description Values/Example Day %a weekday, abbreviated Mon %A weekday, full Monday %d day of the month (dd), zero padded 04 %e day of the month (dd) 4 %j day of year, zero padded 001-366 %u day of week starting with Monday (1), i.e. mtwtfss...

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

Zoho Deluge: Adding / Removing Total Tax from a Quote Recordhttps://joellipman.com/articles/crm/zoho/zoho-deluge-adding-removing-total-tax-from-a-quote-record.html

20 August 2019 this "feature" but the gist is if you want to add tax, it has to be built up in the tax options, if you want this to be zero, you need to pass the option of tax as zero and remove all other options. Take the following code for example, this will add 20%...

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

Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://joellipman.com/articles/crm/zoho/zoho-crm-update-a-custom-field-in-line-items-product-details.html

17 May 2021 l_TaxOptions.add(m_TaxOption1); } else { m_TaxOption0 = Map(); m_TaxOption0.put("percentage",0); m_TaxOption0.put("name","Zero Tax"); m_TaxOption0.put("value",0); l_TaxOptions.add(m_TaxOption0); } m_LineItem.put("Line_Tax",l_TaxOptions);...

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

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 // I don't have a report that takes over an hour to process but in theory this should accommodate it. Problem #1 If zero rows are returned from the search, then there is no REPORTSTARTTIME. There are two options here: Create another dataset (would have...

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

MS Excel - Sort pivottable column headings by datehttps://joellipman.com/articles/microsoft/excel/sort-pivottable-column-headings-by-date.html

12 April 2013 this equation? You can tell me that "10" comes before "8" and it does but just to check, let me pad the 8 with the prefixing zero: Annoyingly "10" still comes before "08" so maybe I'm barking up the wrong tree. If I padded with one more zero so that...

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

Registered Users Cannot Login - Super Users Canhttps://joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 alphanumeric value with a trailing underscore (eg. "abc12_") Check if you have more than one asset with a parent_id equal to zero: SELECT COUNT(*) FROM #__assets WHERE parent_id=0 -- where #_ is the Database Tables Prefix value There can be only one: If...

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

Convert Past Date to Time Ago in PHPhttps://joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

16 May 2019 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually we just want the first two words of those strings: 3 days ago // where event is 3 days ago or just over but less than...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Zoho Inventory: Enable Tracking using the APIhttps://joellipman.com/articles/crm/zoho/zoho-inventory-enable-tracking-using-the-api.html

04 May 2023 info r_CreateItem.get("message"); Error(s) Encountered items with opening stock cannot be deleted, set the opening stock to zero: Guess who's going to have their opening stock set to zero, save the record, then delete it. Source(s) Stack Overflow -...

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

CSS Background Without Causing Scrollbarshttps://joellipman.com/articles/web-development/css/css-background-without-causing-scrollbars.html

23 April 2011 width to be 100 percent of the page. Position the module with absolute on your webpage with background (where left is 0 [zero] because your width is 100%). Position the background image bearing in mind that your layer is 100% of the viewable browser...

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

SSRS Querying on either of 2 Parametershttps://joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 it populates only the first dataset with results; the remaining datasets that need to use the ID parameter all returned zero rows. So one workaround exists where if I combined all 10 dataset queries into 1 mega dataset query, problem solved… Another...

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

The ReportServer Databasehttps://joellipman.com/articles/database/the-reportserver-database.html

08 August 2011 of the person running the report (eg. MYDOMAIN\myusername) RequestType bit NOT NULL User or System. Can be 1 or 0. This was zero "0" when I would run a report as a user. Format nvarchar(26) NULL This is the rendering format. Mostly RPL if viewed in MS...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• 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 = v_studentreference; This errors when the student does not have a username. No rows are returned for the first query and a zero isn't inserted. Note: Running just one of the queries will work as normal with the NVL function. Running the second based on...

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

Three boxes, two roll over, one falls outhttps://joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 this to 990 pixels in width fixed the problem. I'm guessing this was because 990 divided by 33 leaves a remainder of zero but I'm not 100% sure this fixes the issue throughout other systems. IMO: Somewhere in the Javascript (based on jquery), the script...

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

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

07 March 2014 search -- then you must be limited on what you know about this person... Refine your search. -- This "where" clause returns zero rows if dob, reference, -- forename and surname parameters are not populated. In addition, we also need a second dataset in...

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

SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

13 June 2014 Under "Variable Mappings" specify the Variable "User::SourceExtractFile" (based on this example) and keep the Index at 0 (zero). OK to close the dialog Edit your Data Flow as per usual, selecting your dynamic connection manager as the Flat File Source....

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

Joes Word Cloud (JWC) Downloadhttps://joellipman.com/component/content/article/joes-word-cloud-jwc-downloads.html?catid=92

07 September 2015 (eg. Word Background) do not load if not enabled. - Added Joomla! Admin Option: Module width. - Corrected division by zero if no words found (?) sets to 1. - Now includes absolute path for word link (JURL::base()). - Date Uploaded: Sat, 14th May 2011...

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