... create map of line items and created SO (fix to invoice only generated on edit)
Date Modified: 2023-03-29 (Joel Lipman)
- If an eBay order comes through as cancelled, then void the sales order, ...
... 1000 ])
// the actual number may be less than this but this is for pagination estimates
v_MaximumOrders = 10000;
v_Year = 2022;
//
// set the filter for orders by status to return: All, Active, Cancelled, ...
... PO ID" = po."Purchase Order ID"
WHERE poi."Item Name" NOT IN ( 'delivery' , 'Delivery' , 'Price Disrepency' )
AND po."Purchase Order Status" NOT IN ( 'Cancelled' )
The second dataset will b ...
... / and ensured the cursor remained as a hand to indicate clickable:
div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(2)
div.zc-Calendar_Day_Select .choice-table-cell span label:nth-child(3)
...
... attributes will remain.
Preview
the Code
The code below can be changed to suit your own styling. It has been intended for use on large desktops so it's a little buggy on smaller cellular/mobile ...
... is a function returning a boolean. Returns false if a cell value has been formatted to a text type. Returns true if the cell value is a number AND the cell data type is numeric.
Search( is a case-insensitive ...
... any more stupid, he'd have to be watered twice a week."
Joke4:="He has two brain cells, one is lost the other is out looking for it."
Joke5:="If you gave him a penny for his thoughts, you ...
... 14-Jul-2014 15-Jul-2014 16-Jul-2014 17-Jul-2014 18-Jul-2014
Last Step:
Format the cells in Excel containing the header under "Alignment" to "Wrap Text". The difference the above does, is that when ...
... areas but displays the report background color instead:
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 ...
What?
A very quick note on why borders may be misbehaving in SSRS. This note corrects the situation at Design time. This is where you are trying to select a cell to have an outline border but then ...
What?
This is a quick article on how to convert some cells in Microsoft Excel to number values...
Why?
OMG. Seriously Microsoft! I have spent an hour trying to convert a column of currency values ...
... In other words, 1.0 in decimal, formatted to time is equal to 24 hours; 0.5 would be 12 hours and so forth. My formula:
-- Given Cell B5 = 0.14 person days from above example.
-- 1 person day = ...
...
This returns the number of unique values in the range A3 to A1000 and excludes the blank/empty cells.
Display all Unique
Found this note on one of Microsoft Help sites:
Office 2010:
Select the ...
... on the left grey margin of this and 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 ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.