Assuming will is required, the following 354 results were found.
-
XY coordinates. Export the report to Excel and all the fields in the section appear in the same column. Extra blank columns will not appear. Cause 2: Objects in the same column have different widths To ensure all the objects in the same column have the...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
And according to other web articles on this matter, I have to change the order of my parameters (I will be checking "Student Username" first as "Student Reference" must be calculated and not blank/null): So I tried setting the "Available Values" as...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
DATEPART(year, ExecutionLogStorage.TimeStart), Catalog.Name Chart-wise: create a line chart [Sum(Counter)] will be the data field, [ReportName] will be the series field and [DayOfYearRun] will be category field: So is this doing what I wanted? Well NO....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
server needs to have the "unattended execution account" configured. Some sources are specific saying that the account will need to be able to logon to the external server holding the files. MSDN Quote: When the report is previewed in Report Designer,...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Team Foundation Server (TFS). Sometimes I'll check out an item from TFS and before I get to update it, my connection will drop and my computer will say that it could not connect to either the TFS or my target deploy location. I found a quicker fix than...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
site as this article focuses on getting an Oracle stored procedure to work with SSRS. Main Example: My stored procedure will do the following: Get a student ID number based on the student username Get a student's names and date-of-birth based on the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
-------------------------------------------------------------------------------- -- _jcomments_settings -- ignored as this will load factory settings -- -------------------------------------------------------------------------------- /* INSERT INTO...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
key with the action name (eg. "Print Directory Contents To File" - replace spaces with underscores if you are unsure this will work) Add a key to this one called "command" Under the "command" key, there should be a new string value called "(Default)"....
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
Hmm... I was writing a stored procedure that will scramble data given a table as a parameter. Because I only want to update a temporary table and not the original (source) table, I needed the following stored procedure (or part of). What? This will copy...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
Looks pretty good, doesn't it? The advantages of this is that you can send this data to your developers and the data types will be correct and maybe they'll resolve issues faster than if they were given scrambled data (see my articles on DataJumble and...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
as the DataSource. Why? If you are simply using a text file as your data source, then the options in the connection manager will let you skip rows and specify column datatypes. You don't get that with Excel but you can still control the data range. How?...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
I'd like to use various techniques, and the first part of this article (Stage 1) is the only part you need to modify as this will improve your Joomla search results by giving priority to articles where the search term is in the article title. In the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
package takes data from a source database and puts it in staging in the exact form it came through. Our transform package will convert the data and output it to the target system. For our package to decode what "M" means, it needs to look this up in a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
A quick article on how to rename multiple files using the command prompt and a bit of string manipulation. This example will rename files which contain the string " (Copy)" and replace it with nothing (so removes it). The challenge here is the space...
- Type: Article
- Author: Joel Lipman
- Category: MS-DOS
- Language: en-GB
-
maybe I should have painted my Phantom in chrome. My DJI Phantom FC40 repainted and gimballed. Very close to the ground so will have to watch those landings and thats with thicker than stock pads Done. Here's a video and I will try to post some more:...
- Type: Article
- Author: Joel Lipman
- Category: Quadcopters
- Language: *
-
and double-quotes. You can change this but remember to put two double-quotes if you are searching on it, eg: FIND(""",B1) // will NOT work! FIND("""",B1) // will work FIND("″",B1) // will work You could merge all the statements into one but for...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Warning Save failed with the following error. Another menu item has the same alias in Root. Root is the top level parent You will need: Access to the Joomla Administration Panel (to check for and remove expired menu items) A good database administrator...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
PHP function: "json_encode". How? So here's what I tried and ended up with: If your XML is UTF-8 This is the basic code and will work to fetch some XML and return it in JSON formatting as long as the XML is encoded in UTF-8. // set headers for JSON file...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
here. Basic Example Here's a complete PHP script of a basic example of getting the agencies belonging to a company (note you will need to change the keys and relevant IDs to match your own solution): // specify provider ID $my_provider_id = 1234;...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
Well how to deactivate an account and set up a new one in Windows Live Mail. If you used IMAP all along then the new account will have all your mail. The error Unable to send or receive messages for the Hotmail (someone) account. Subject 'your Microsoft...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF