Assuming expression is required, the following 36 results were found.
-
A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
contained a subform with a product line item list. If I run this code, I would get the error: Expecting ZC_SUBFORM_250 expression found COLLECTION expression Another error you may get when using the deluge script is: LIST value cannot be assigned to...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Right-click on the "[Order]" cell and select "Add Group" then click on "Parent Group..." as shown. Week grouping expression: you're being asked to Group by, so we click on the "fx" button to enter the below expression: Delete Order Column: Ok the...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
Reporting Services Business Intelligence Development Studio (BIDS) version 2008 through combining Transact-SQL and MDX expressions" but boy what a mouthful, and it's not really iterating anymore. So it's "SSRS Hide results table if empty" though I will...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
select "Insert Row" then "Below". Repeat with all values you want to compare. For each Data cell, Set the background fill expression as per the MDX expression below. The MDX Expression This is to be applied to the "Fill" expression of the textbox with...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
DisplayToolTip: SetTimer, DisplayToolTip, Off ToolTip % %CurrControl%_TT ; The leading percent sign tell it to use an expression. SetTimer, RemoveToolTip, 3000 return RemoveToolTip: SetTimer, RemoveToolTip, Off ToolTip return } Search: Return GuiClose:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
Right-click on the cell you want to put the image in. Insert > Rectangle Set the Rectangle Fill color (I'm using an expression based on the status) to output: Green (for Success), Red (for Fail), Orange (for Unknown). Right-click on the rectangle and...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
You need to go to "Fill" (of each text box in the row - unless there's a faster way) and instead of color, click on the expression button (fx) and use the following: =IIF(RowNumber(Nothing) Mod 2, "#ffffff", "#eeeeee") or =IIF(RowNumber(Nothing) Mod 2,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
on the first will error this procedure. One Issue I just kept getting this error over and over again: ORA-00936: missing expression 00936. 00000 - "missing expression" The solution was to enclose the subquery with an opening and closing parenthesis. --...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
number datepart)DATEADD(datepart, number, date) DATESUB(datepart, number, date) Other If-then-elseIF( expression,value_if_true,value_if_false )IIF( expression,value_if_true,value_if_false ) If...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
XML Schema Referencehttps://joellipman.com/articles/web-development/xml/xml-schema-reference.html
element Defines an element extension Extends an existing simpleType or complexType element field Specifies an XPath expression that specifies the value used to define an identity constraint group Defines a group of elements to be used in complex type...
- Type: Article
- Author: Joel Lipman
- Category: Extensible Markup Language
- Language: en-GB
-
A more comprehensive post on some other regex (regular expressions) to format values in Zoho. How? The following will remove any non-digits: v_MyString = "Hello World 123"; v_MyFormattedString = v_MyString.replaceAll("[^0-9]",""); // yields 123 The...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
trying to create and declare the subform before having specified any record to insert it into. Expecting ZC_SUBFORM_109 expression found COLLECTION expression: I may have tried to make a subform equal the collection rather than inserting the collection...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
written a note because I spent time googling and still didn't find an answer. My situation is that I wanted to put an expression to format the border (empty cells have a border and non-empty don't). This was so that a grid would show for empty spaces. I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
a Month name. An error occurred during local report processing. An error has occurred during report processing. The Group expression used in grouping 'table1_month' returned a data type that is not valid. My DataSet Query was as follows: SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
in a specific format, try... =Format(now(), "ddd, dd MMMM yyyy HH:mm:ss") =Format(now(), "dd/MM/yyyy") The reserved expression letters used are on the MSDN website at http://msdn.microsoft.com/en-us/library/ms146084.aspx NOW() vs TODAY() Noticed this...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
-- ----------------------------------------------------------------------------- -- If you select the part of each expression from the SELECT and run these -- to see what results are returned, it is reading only and not making any -- changes. It will...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
T-SQL Record Separatorhttps://joellipman.com/articles/database/t-sql/t-sql-record-separator.html
when a separator is needed) but this works. Inspired by Namwar Rizvi's blog, I wrapped my SQL query within a common table expression: --Create CTE WITH tblDifference AS ( SELECT t1.*, ROW_NUMBER() OVER (ORDER BY t1.Date ASC, t1.Start ASC, t1.Room ASC,...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
local variable) -- where :ParameterToCheck is another of the report parameters (Oracle local variable) MDX Check /* For Expression Value. Remember to apply to both ACTION and if you use color change FONT. Note for MySQL solution change 0 to 1. */ =IIF(...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB