19 March |
How Do I Extract all the Characters before a Specific Character in a String Field? |
During a recent Crystal Reports XI report design project two tables needed to be linked together, where in one table the field only contained the user name, in the second table the field contained the user email address, which consisted of the user name, plus the organisational domain.
Read More |
|
|
07 March |
How Do I Extract Characters from within a String Field in SQL Reporting Services 2008? |
During a recent SQL Server Reporting Services 2008 report design project, one of my clients needed to extract some text after the last instance of a specific character of a string field.
Read More |
|
|
12 December |
How Do I Create an Index for a Dynamic Parameter in Crystal Reports 2008? |
Recently a client had an issue with creating a dynamic parameter based on the Customer Name field returning over 3000 values, and the filtering feature only worked if one was in the correct page.
Read More |
|
|
07 August |
How Do I Return All the Values of a Group on a Single Line in SQL Reporting Services 2008? |
During a recent SQL Server Reporting Services 2008 project I was asked "How Do I Return All the Values of a Group on a Single Line, separated with a vertical line using SQL?
Read More |
|
|
10 April |
How Do I Concatenate the Year to a Custom Financial Year Start Date in SQL Reporting Services |
During a current report design consultancy using SQL Server Reporting Services 2008 I was asked how do I concatenate the year to a custom financial year start date?
Read More |
|
|
03 April |
How Do I Calculate the Number of Business Days Between Two Dates in SQL Reporting Services 2008? |
During a current report design consultancy using SQL Server Reporting Services 2008 I was asked how do I calculate the No. business days between two dates i.e. excluding weekends?
Read More |
|
|
30 March |
How Do I Find the Position of a Specific Character in a String Field? |
I was recently asked during a SQL Reporting Services training session, how does one find a position of a specified character in a string field.
Read More |
|
|
16 November |
How Do I Concatenate Fields with Null Values in SQL Reporting Services? |
During a recent training session a delegate asked how do I concatenate fields that contain null values correctly.
Read More |
|
|
29 September |
How Do I Combine Records from Two Separate Tables in Crystal Reports? |
I was recently asked by a client how do I combine records from two separate tables to make a single dataset in Crystal Reports?
Read More |
|
|
03 February |
How Do I List All the Descriptions of Tables, Views and Fields of a SQL Database? |
Recently while working with a client when they asked, How does one list all the tables and views, with their fields and descriptions of a SQL database?
Read More |
|
|
03 August |
How Do I Find All the Products that Have Not Generated Sales? |
A client recently asked me How do I create an SQL statement that lists all the products that have not generated any sales, that can be used with either Crystal Reports or SQL Server Reporting Services?
Read More |
|
|
15 July |
How Do I List All the Views in an SQL Database? |
Recently while working with a client they asked, how does one list all the views within an SQL database that contains a specific field name?
Read More |
|
|
07 July |
How Do I Change the format of a DateTime field in SQL? |
A client has just asked me how does one format a datetime field in SQL to display the date in the format dd/mm/yyyy?
Read More |
|
|
