Assuming want is required, the following 277 results were found.
-
click and you will be brought to your desktop Aero Shake: If you have lots of windows open on your desktop and you only want to look at one, click and hold its window and shake it! All the other windows will minimize, simply shake the window again and...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
off as your own work or try to sell it without due credit. Check back with us at joellipman.com for updates/fixes. If you want more support/work done to it, you could consider a donation :c) BACKGROUND: OK, it's not the best name for a program and I...
- Type: Article
- Author: Joel Lipman
- Category: Product Documentation
- Language: *
-
base and match their setups as closely as possible. Objective My aim is to have IE 8 installed as my Windows browser (I wanted IE7 and the other 2 as standalones but apparently not possible) and then have IE6 and IE7 as separate browsers. If I was at...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
and username + password). Admin Access to the reporting server if you plan on deploying the report to it. Scenario: We want to report on a MySQL database MySQL login information is a user who exists as a MySQL user and a server user. Reporting server is...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
to query the Title and the Introductions of any valid articles from BOTH tables and return one table with everything I want. Consider the following two tables exist: Joomla Articles (table name: jos_content): id title introtext...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
=FormatDateTime(Fields!BirthDate.Value, DateFormat.ShortTime) Unfortunately if you are using US dates and want the report to use a specific European date format and you spend as long as I did searching the web for a solution, then ignore all the above....
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
of the report. [The second example is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on each cell to specify this so just do it to the first column then bring up the properties pane and scroll...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
Use the SQL code above: So you can paste this straight into the textarea or use "Query Builder". 3. Select Matrix Tablix: We want all rooms on the left and the time along the top. We select a matrix because this will automatically group the rows by room...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
with a centered content section (white semi-transparent layer) of 900 pixels width as shown in the following picture: And I want the clouds as another layer ontop aligned to the top right: Tried and failed: Specifying the width of the div layer the same...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB
-
basing most of this article on the official Joomla 1.6 documentation: http://docs.joomla.org/Creating_a_profile_plugin and I want to use an example that worked for me. Important: This is for Joomla version 1.6.x+. Aim / Objective Add a field with a...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
hostname must not match any domain that is being used on the system. Example, if you have a domain called domain.com and you want to recieve mail on user@domain.com, you must *not* set your hostname to domain.com. We recommend using server.domain.com...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
View (you could probably use a "Standard View", I just used the Datasheet one) Give the view a name, select what columns you want the form to have (I included the IDs for functional purposes) Further down the "Create View" page, there should be a Sort...
- Type: Article
- Author: Joel Lipman
- Category: Infopath
- Language: *
-
query so that the date returns in yyyy-mm-dd 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"....
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
Situation We want some photos taken from another website of ours to display in our report. These are not stored locally on the Reporting Server because other services use these photos on our Intranet and we only want one location to upload the photos....
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- 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: *
-
process failed but when I check the logs, it successfully ran the stored procedure (updating both tables). The Workaround I want to avoid the workaround, because so far my workaround is a fourth report which will do the select to check that the update...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
SSRS Zero Paddinghttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-zero-padding.html
Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We have a database using Oracle 10g, and a SQL Server Reporting...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
+ " second(s)" // yields // 0 hour(s), 1 minute(s), 2 second(s) This isn't what I want... It wasn't accurate enough and always saying 0 seconds was just confusing the end-user... Workaround #1 Although I'm convinced of a solution considering the...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
for all reports (used for the dropdown parameters): SELECT Name, ItemID FROM Catalog WHERE Type = 2 ORDER BY Name If you want to use these datasets, parameter options should be that the Name is the "Label" and ItemID is the "Value", just in case you...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
user. Post-Notes (Update 2012) The performance of the previous version of this query was pretty abysmal and worse if you want to list users who have no associated activities (outer join but all-in-one query). The DBA responsible for the system asked me...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF