Assuming something is required, the following 129 results were found.
-
here (sample data): And this is what a Data Viewer returned when executed: My columns were being pushed out of alignment (something about {CR}{LF} being displayed for the blank rows and inserted in the next line) and creating discrepancies that would...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
Simple bit of SQL but as you can see we have a few fields that need decoding (suffixed by "_code"). Run as it is, yields something like the following: sequenceID student_reference student_title_code student_name student_gender_code...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
"DataSet1" is my dataset -- and Count(Fields!Field1.Value, "DataSet1") returns the maximum number of rows retrieved Yields something like: This is the bottom left of a report where both the above examples (fill and borders) have been applied:
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
dataset) =IIF(Sum(Fields!Counter.Value, "Equipment") send to back), the expression for visibility on the textbox should be something like: =IIF(Sum(Fields!Counter.Value, "Equipment")>0, True, False) If you're bugged by the warning "Overlapping report...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
BETWEEN '01/01/2010' AND '08/01/2011' GROUP BY DATEPART(dayofyear, ItemDate), DATEPART(year, ItemYear), ItemName // yields something like ItemName DayOfYear YearRun Counter --------------------- -------------- ------- ------- Report 001 181 2010 134...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
On the system that used to do this, we could use the HTML attribute "OnError" to load an alternative image. We would like something similar for SSRS. Solution #2: Alternative image if file does not exist More of a workaround than a solution but by...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
various reports) in a table and then to color the backgrounds based on whether they are the fastest or slowest in the set. Something like: The DataSet This should work on your reporting server as well. I'm using the database "ReportServer". select *...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
[@StudentReference]. Fixing this resolved all 3 issues below!!! Encountered Issues ORA-01403 no data found & ORA-06512 something else - Fixed by specifying the query parameter properly (ex: Parameter name = p_STUDENT_ADNAME, Parameter Value =...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
I just had to put something here as I have been buying and returning failed/corrupt USB pens. In the past few months I have been trying to upgrade my 16Gb USB Integral Pen from Play.Com to a 32Gb equivalent. I use my USB pen as the "My Documents"...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
Thought I'd put something here as a lot of my clients and friends are all surprised by the Aero features and weren't aware that these existed in Windows Vista (and originally from Linux variants). Sometimes you may only have partial Aero effects. This...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
I'm going to do a bunch of screenshots: The error is that I can't receive/send messages on this account. The problem has something to do with DeltaSync no longer being supported. Deactivate the account by deselecting "include this account when receiving...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
access to. Tick the boxes for role membership next to public and db_datareader. Confirm by clicking OK. You should get something like the following: Database-level role names from http://msdn.microsoft.com/en-us/library/ms189121(SQL.100).aspx...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
you can copy, paste and run against your SQL database. Simply run the query that the above outputted and you should get something like the following: Value Source Count ------- ------------------------- -------- dnya myTable1.Title 2 DNya...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB
-
asking me "Why can't I turn on my computer" and me replying "why would you want to do that?". Anyway, I was looking for something like the record separator in Oracle SQL*Plus where a row of data (blank or made of symbols) separates two sets of data from...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
myResultSet REFCURSOR; EXEC sp_get_studentdetails_from_ad(:myResultSet,'jsmith2012'); PRINT myResultSet; Should yield something like: MYRESULTSET -------------------------------------------------------------------------------- STUDENTID...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found; No...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB
-
past that quickly with just 1 person (me!) on the site so they just refuse the connnection after a while. Obviously something is not right. I am searching the forums for an answer and if I don't find one I'll repost. I just thought I'd share this with...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
list, within the loop run the activities query and replace the string "STRING_TO_REPLACE_PER_ITERATION" with the User ID. Something like: $result=mysql_query($user_list_query); while($row=mysql_fetch_assoc($result)) { $this_user_id=$row['UserID'];...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
arranged prior to launch Discuss expectations for changes and support (response times) Critical - nothing works! Major - something important is broken Minor - less urgent but still broken Request - nice to have Support structure / maintenance rates...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
might already have something similar to this but this deserves its own article. Why? Well try to search the web for a PHP/MySQL solution which suggests on how to count the hours between two times on the same date, when one of the hours is on the other...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *