- 21. SSRS Zero Padding
- / SQL Server 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
- 22. SSRS AlphaNumeric Parameter Validation
- / SQL Server Reporting Services /
- ... Database Level AlphaNumeric Check You may have better ways to do this but here are my database level checks for alphanumeric values: -- ORACLE -- 0 if is alphanumeric, 1 or more if not alpha numeric. SELECT ...
- Created on 07 November 2011
- 23. T-SQL Record Separator
- / Transact-SQL /
- ... 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 ...
- Created on 11 October 2011
- 24. SSRS External Images don't displa
- / SQL Server Reporting Services /
- ... on the status of a student in any case. This meant that I could use the same Oracle PL/SQL query they used to determine whether to display an image or not. Bit of a cop-out I know but after two weeks ...
- Created on 19 September 2011
- 25. MySQL parameters in Excel 2007 PivotTables
- / MySQL /
- ... the executives. SQL query returns individual items while Excel allows drag and drop grouping/drilldown pivot tables. Have managed to get this working with SQL Server, Oracle and MySQL databases... Now ...
- Created on 24 August 2011
- 26. SSRS Querying on either of 2 Parameters
- / SQL Server Reporting Services /
- ... Foundation Server (TFS VS2010) and connecting to an Oracle database (ie. "seamless integration because our setup is perfect and well thought through" not - note the DBMS is not hugely relevant for the purposes ...
- Created on 19 July 2011