Assuming want is required, the following 282 results were found.
-
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: *
-
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: *
-
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
-
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
-
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
-
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: *
-
the standard staff image and so we spend more time on "how do you make it like it was in XP?" situations. How? Who doesn't want to change their desktop background wallpaper? Using Windows 7, who doesn't want it to be a slideshow as well? Create a folder...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
If we don't run them as local administrators on the workstation, they error incessantly and never manage to do what you want them to do. What? I want to create a desktop shortcut that I can double-click and it will run the above programs in...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
weren't too much of an issue either as MS Windows detected these without needing software. Long rant to justify why I didn't want to drive home (~20 to 40 minutes commute) and pick up my laptop. How? The work and research for this was all in one YouTube...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: *
-
this example, find typos as well, eg. "Daat ont Ety Aviable". How? Mine's a bit of a copout as it is a two-step process. I wanted a query that searched every column containing strings in the database and we are somewhat limited in Sql Server 2008 R2 by...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
in SSMS, Right-click on the database Select Tasks > Restore... > Database Specify the "to a point in time" if you don't want to restore from the most recent backup and double-check the "Start/Finish Date" is the one you want. OK Searches ssms restore...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- 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: *
-
the haystack string and find needle): DECLARE @Haystack VARCHAR(31); SET @Haystack = 'String1.String2.String3.String4'; -- I want "String4" from Haystack SET @Delimiter = '.'; PRINT @Haystack; -- yields "String1.String2.String3.String4" SELECT REVERSE(...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments. Why? We wanted a T-SQL version despite having successfully built a custom script component for SSIS. How? You can search my site for how...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
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
-
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
-
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