Assuming would is required, the following 210 results were found.
-
exported report when we followed that suggestion. Consider the following report in design view, only the circled headings would appear on the exported report: The solution I found that worked for me, was to make all the heading boxes the same height and...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Reports 9, created extra columns. This issue could not be replicated on the client machine (ie. from my workstation). I would have to upload the report to the server, configure the web application to use the newly uploaded report, export to a Crystal...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
format (eg. 2012-03-04) Reverse Dates Order If you have a date filter list and want it sorted in descending order, I would recommend you return it in SQL date format (yyyy-mm-dd) and then do "Sort Z to A". You may find that the field needs to be...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script has to split a single spreadsheet into multiple worksheets of 3000...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Additional Others around the web have suggested the following but I don't have these options to grant and would have to grant them via a terminal/command line to MySQL. GRANT SELECT, LOCK TABLES, RELOAD, PROCESS, TRIGGER, SUPER, REPLICATION CLIENT, SHOW...
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
(if already installed it just lets you click on "Ok"). Initially I got a support agent from GoDaddy to do this who said it would take about 6 hours to 2 days to take effect. Not sure what was supposed to happen but 2 days later it still wasn't working....
- Type: Article
- Author: Joel Lipman
- Category: cPanel
- Language: *
-
suffix Type Type the parameters you want as default Press /settings Settings will default some settings although, again, I wouldn't recommend these if you're just starting off. Leaving these on default as you experiment and become more familiar with the...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
weeks later. At this point, the bank/building society will take the full cheque amount back out of your account. This would then leave you out of pocket for the amount on the cheque and the amount you passed on as the difference. Fake escrow sites. A...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
I was waiting to move house during 2020 but then a virus capable of locking down the world manifested itself. I thought this would be temporary but after 4 months of slouching over the coffee table, my back is suffering terribly. I figured on a personal...
- Type: Article
- Author: Joel Lipman
- Category: Articles
- Language: *
-
GuiControl, MoveDraw, MainRedBackground, w%A_GuiWidth% h%A_GuiHeight% Return If I just used GuiControl, Move,... then this would be as above but if you are using images, then you will get problems with the image repeating... so use moveDraw which...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
respond to the ENTER key after you typed something (this is for a search feature) in addition to having a button if the user would rather click then press the ENTER key. Then create the mouseover and mouseout effects afterwards. Add the image for your...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: *
-
languages. For Example, the statement: If (ThisCondition = true) ThisVar:=1 Else ThisVar:=2 Converted to Ternary this would look like: ThisVar:=(ThisCondition = true) ? 1 : 2 I'll add as there are a whole bunch of methods using the Ternary Operator in...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
as blue despite the mouse cursor not being anywhere near it. Proper HTML mouseovers: When I have a more stable solution. I would however recommend cwebpage.dll at as a minimum for internal HTML pages for use in an AutoHotkey GUI.
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB
-
and vice-versa CRM to Creator Depends on the format of the datetime in your Creator field but standard would be: v_CrmTime = "2021-01-01T01:23:45+01:00"; v_CreatorTime = v_CrmTime.getPrefix("T") + " " + v_CrmTime.getPrefix("+").getSuffix("T"); info...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
course the menu could have been created with just one item with no title and positioned at the bottom of another menu; this would look like it was all part of one menu). toubkal wrote: This cannot be done by joomla administration but can be done by...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
After I installed the rokstories module from www.rockettheme.com, if I clicked on one of the articles (rokstory), I would get a page with the article on it but with the following error (3x) above it: Warning: Invalid argument supplied for foreach() in...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
enabled. How? Basically you have to include &view=article as opposed to Joomla v1.5.x when the option and id parameters would suffice: - SEF URL http://www.joellipman.com/support/documentation/449-module-joes-word-cloud-jwc.html - Direct Link...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
During a site upgrade, the commenting extension for Joomla called JComments would return errors when using PHP version 7. This is a quick article to document what needed doing to fix the errors. How? First some errors: ERROR: plgContentJComments...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
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 wasn't getting very far because I'd even ask the border to be grey and save the project but when I...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
values (setup in the subscription section). The report being subscribed to is hidden in tile view. Cases where this would NOT work Reports where the connection string to the data source is held in the parameters (though, with more time, we could have...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB