Assuming that is required, the following 493 results were found.
-
2010, 2011, 2013, 2012. The Solution Bring up the field list of the report (so you see the fields panel) Untick the filter that is not in alphabetical order Click on the Refresh button Re-Tick the filter to add it back to the report Move this added...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
116°35′51″E into 40.079857, 116.603112. How? Let's pretend all the names are in column A, in Column B I have the coordinates that I want to convert: A B ------------------------------------- ---------------------- Beijing Capital International Airport...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
As with all Joomla articles and files, you need to check that they have been published and approved. Sometimes you don't have to and it's all automatic, but if they're not showing: Check that they're in the right section and category Check that they...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
context menu Left-click on Properties Add the word -incognito (including the hyphen/dash) to the end of the Target value Ok that and see if it works Note that if in point 4, if there are any spaces in that value, you should add a double-quote character...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
after another change freeze, I had sent all Wiki articles modified since the last export but then needed to send all images that had also been either added/modified since. How? Using MySQL, the following query lists the image name, size, user who...
- Type: Article
- Author: Joel Lipman
- Category: MediaWiki
- Language: en-GB
-
Basically I thought that the regional settings of a report generated using Report Builder 2.0 on a MS SQL Server 2008 instance were dependent on either the server or the client machine. Realised that this was actually specified in the report. Here's a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
sound silly to some but I've 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...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
to cut the loading time of the first report of the day. Why? Take any SSRS report, if one of us was the first to run it on that day, it would take an additional 60 seconds to get with it and display the report. Any subsequent running of the report...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
This is in the case that you have only one optical drive which is a minimum of a CD Writer and you want to make a copy of a CD. Insert original CD in the drive In the CD Drive dialog box, click CANCEL On the desktop, double-click on MY COMPUTER...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
a quick note as to something that worked for me. Taken from the Oracle forums @ https://forums.oracle.com/forums/thread.jspa?messageID=6861756 Situation I have one column of values that I've suffixed a comma to but I want to display this as a rows in a...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
Ok is it just me who does everything slowly and badly until someone comes along and says why are you doing it like that? My justification is that the job has to be done no matter what. If you've ever sat there with phpMyAdmin or a MySQL Administration...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
quickly suggest ways of pinpointing the source of the problem: In a database/web environment, have you? Commented out lines that you suspect might be the problem? Able to run the SQL queries directly against the database? Matched the datatypes...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
: Minutes : Seconds. We could have tried out some cool new DLL files for MS Windows 10 but we needed something lightweight that doesn't require any extra files and that could work on MS Windows 7 (32-bit) for this particular app. For this reason, we are...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
within a text file. I also find myself copying amounts of code into the same document and then needing lines prefixed so that I can explain the code. What? Change contents of "original_file.txt" The first line of my code The second line of my code The...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: *
-
everything in the original folder? Well what if I don't? Then I have to go through a few hundred files manually checking that I have the converted version and deleting the original. SAMPLE USAGE: If you have a portable media player that needs to convert...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
this is a program I've been wanting for ages. Only way to be sure it doesn't have any malicious code and that it does what I want and looks like I want it to look, was to make my own. What does it do? Amazing. It detects transmissions over a network....
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
Checking by Regular Expression: So I could do it the long way in Zoho Deluge. We match a pattern and replace everything out that conforms to the criteria so a true response will be an empty string: v_MyRegEx =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
in an invoice. Why? A client wanted one of their products to be swapped out with another as they had a 3rd-party feed that kept creating a product that they didn't stock. How? So editing the product_details field of an invoice record seems...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU -------------- ------------- MyProduct1 TEST01 Myproduct2 TEST02...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
So this is an article with some common snippets of code that use the InvokeConnector and do things we can't do in shortcode. List CRM Users (ActiveUsers) Note that this is somewhat superseded by: l_Users = zoho.crm.getRecords("users") or r_User =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *