Assuming that is required, the following 494 results were found.
-
2008 and creating a report in Business Intelligence Development Studio (BIDS) or MS Report Builder. Scenario I have a report that specifies some room bookings for a particular week. When I open the report, each drilldown row is collapsed (as opposed to...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
of just specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate), then the range is for that particular date. Solution Easy for some but anything that I spend 30 minutes googling and reading up on is asking for an...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
each page. Situation I have a report which has been set to landscape with zero margins specified. Although BIDS acknowledges that I want this to output to A4 with the correct measurements, the report doesn't seem to have any page breaks. When I run the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Group..." Specify the "Group by" (in my case "Day"), the grey part will display a grouping icon Now select the column that has just been created (usually "Group1") by clicking the grey part above it Delete this column. Check that the grouping grey part...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
MySQL Oracle equivalentshttps://joellipman.com/articles/else/database/mysql-oracle-equivalents.html
title of this article implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? -- return all records that contain non-alphanumeric characters SELECT * FROM myTable WHERE myColumn NOT REGEXP '^[A-Za-z0-9]+$'; -- return all records that...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
if one of the queries fails? To mitigate the chances of misplacing our millions due to some possible error we must ensure that both queries are executed with the expected result before committing any changes to the data. This where transactions are...
- Type: Article
- Author: Ike Francis
- Category: MySQL
- Language: en-GB
-
increase height based on how a heading fits on a page. What? I have a heading like this: The code of this is: A long heading that wraps over several lines When I shrink the browser, I get a heading like this: I want this to happen: The code of this is...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
Just a note to say that I've added two more programs which I regularly use to my download section on this website. As always, these are free to download and include the source codes under the GNU/GPL License v3. If you have autohotkey installed, you...
- Type: Article
- Author: Joel Lipman
- Category: Products
- Language: *
-
MS Excel simply opening the CSV as if it knew what to do with it. It doesn't. Saving the data source as a text file means that Excel will prompt you what to do with each column: 1. Specify that the data is delimited 2. Specify the data is delimited by...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
This happened to a m8s website in VirtueMart 1.1.3. The issue here was that although all the prices lost their float/decimal and were rounded up to the nearest integer... At first we thought this was due to installing a Virtuemart UK Credit Card...
- Type: Article
- Author: Joel Lipman
- Category: Virtuemart
- Language: *
-
As an IT professional, I feel that both OpenSource and Commercial applications have their benefits and neither should go. My day job doesn't involve any Joomla! material but has many Content Management Systems (CMS) commercial equivalents. I use any...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
under a folder (relative) Const SHGDN_INCLUDE_NONFILESYS = $2000 ;// If Not set display names For shell name space items that are Not in the file system will fail. Const SHGDN_FORADDRESSBARConst = $4000 ;// For displaying in the address (drives...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) {...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
so there are more fun things to do out there. If you're the type of AutoHotkey programmer that doesn't like having to use the command prompt to write to an extra text file which your program has to read, then this is for you. DllCall will usually run...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
So I needed to clear space on a workstation's C drive. There are other programs about and even some built-in to MS Windows that could potentially be used. This is a quick article on how to write an AutoHotkey program to simply return the folders in the...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
map while trying to keep it simple enough for my clients. Why am I giving it away for free? Could be malicious or could be that I made this for a website, got paid, and I've used it again and again since. I learnt how to do this because someone else...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
(but reliable). But being limited to the lines of code you can run (ref. "Maximum number of executable statements", anything that reduces the number of lines used would be an improvement. This is how I was doing it previously. // get the date (eg. 1, 2,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
have completed once copying the below scripts). Let's start with the first PHP file which I will call functions.php. Note that you will need to edit the global vars to be used by the functions located at the top of the script:
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: en-GB