Search
-
Category: (MS Windows)
... column) and the days of the week along the top. Why? The excel report would hit a bug where it couldn't work out that 10 (Wednesday) happened after 8 (Monday). How? See the following screenshot ...Created on 12 April 2013 -
Category: (Product Documentation)
So it's the end of the month again and I have to prepare a report for some investors. The idea of an infographic report has excited them to no end but because the end of the month didn't wait for me to ...Created on 03 April 2013 -
Category: (Computer Repair)
Event 1 A friend reported her phone was constantly being drained, wasn't lasting the day on a full charge and knew how to close apps running in the background (double-click "home" button and hold down ...Created on 27 November 2012 -
Category: (Transact SQL)
... column we have setup default values, let's use the example "Data Not Yet Available". Unfortunately the end-user reported these default values sometimes list twice, especially when the case is different, ...Created on 10 October 2012 -
Category: (Automation)
Not a useful note and more of a personal opinion then factual, but beyond the inventors of the Internet or any hardware has to be the following notion from IBM: a 1976 research report by Lance A. ...Created on 13 September 2012 -
Category: (General Joomla!)
... _jcomments_reports -- -------------------------------------------------------------------------------- INSERT INTO mydb_upgrade_j25.myprefix_jcomments_reports ( id, commentid, userid, name, ...Created on 07 June 2012 -
Category: (Oracle SQL)
... result set. Furthermore I am using this stored procedure in a SQL Server Reporting Services (SSRS) environment and don't want to return any rows if there are no matches (not a blank row either) ...Created on 24 January 2012 -
Category: (MS Reporting Services)
What? So I've spent a fun time googling and binging but still haven't found a simple and complete example of getting a resultset from an Oracle stored procedure and displaying this in SQL Server Reporting ...Created on 19 January 2012 -
Category: (Oracle SQL)
... and aah-ing, I have written this article as a note for me to demo a working stored procedure and how to use cursors. I'm told I need to use this for SQL Server Reporting Services (SSRS) which is why I'm ...Created on 16 January 2012 -
Category: (MS Reporting Services)
What? I have created an SSRS report which can compare 4 reports side by side and brings up their latest execution times to the nearest millisecond. The report has 4 parameters. Each parameter is a ...Created on 14 December 2011 -
Category: (MySQL)
... ''); END; END IF; END; END WHILE; RETURN Dirty; END; | DELIMITER ; On my system, this reported an error but still created the function. This should create a function ...Created on 06 December 2011 -
Category: (MS Reporting Services)
Why? I've recently written a report for SQL Server Reporting Services 2008 R2 (SSRS) which will compare up to 4 reports and will compare the time taken for each one. The breakdown or what I was able ...Created on 02 December 2011 -
Category: (MS Reporting Services)
How to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular ...Created on 17 November 2011 -
Category: (MS Reporting Services)
... have a database using Oracle 10g, and a SQL Server Reporting Services v2008 R2 environment. My use for this was when displaying an audit log displaying the oracle errors. Oracle Errors An Oracle ...Created on 10 November 2011 -
Category: (MS Reporting Services)
Intro If you ever want to check the parameters submitted with a report for alpha numeric characters (so it doesn't contain symbols, punctuations, etc) then you should do this at the database level, and ...Created on 07 November 2011 -
Category: (MS Reporting Services)
What? We have a report in SQL Server Reporting Services 2008 R2 (SSRS) reading from an Oracle 10g database which works great and lists all the details on a specific student. An additional request is ...Created on 04 November 2011 -
Category: (MS Reporting Services)
My Setup XP SP3 Workstation Business Intelligence Development Studio 2008 (BIDS) SQL Server Reporting Services 2008 R2 (SSRS) What do I want? I have a report displaying room bookings. Each ...Created on 26 October 2011 -
Category: (MS Reporting Services)
The Problem I've set some tablix headers but when I request the same report in PDF format, the tablix headers only appear once on the first page. Every subsequent page simply displays the report header ...Created on 26 October 2011 -
Category: (MS Reporting Services)
I have googled, binged and asked but to no avail. Some self-proclaimed IT experts in forums said "why would you want to do that?". Unhelpful Bellends. It's a bit like asking me "Why can't I turn on ...Created on 11 October 2011 -
Category: (MS Reporting Services)
... report after they've already gone through the hassle of clicking on the big fat refresh button... Keeping It Simple Silly. So the suggestion of selecting all cells and then right-clicking and selecting ...Created on 30 September 2011