Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Difficulty is a fine catalyst for miracles
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services

Crystal Reports, Xcelsius (Dashboarding) and SQL Reporting Services Blog

Welcome to our blog of scribbles and musings designed to share with YOU our insights, knowledge and experience from training, designing and writing reports using Crystal Reports, SQL Server Reporting Services and Crystal Dashboarding (Xcelsius) for our customers.

Please contact us with any questions, queries and/or issues that may have arisen from your use of Crystal Reports, SQL Reporting Services and/or Crystal Xcelsius in response to out blog posts.

We love nothing better to be challenged by something that makes others scratch their heads Feed ME!!!!


How do I extract characters before a specific character in a string field using SQL

Working with a new client, they wanted to extract a company name from a field that had extra characters.

Read More

How Do I return the 4 weeks data starting from the Previous Friday date in SQL?

Working with a new client, one of their reports needs to return data from the previous 4 weeks from the last Friday

Read More

How Do Preset Export Options in Crystal Reports 2016?

During a recent Crystal Reports Writing project, the user was running their reports from a 3rd party crystal report viewer to export their reports

Read More

When is a zero not a zero??????

I have had a number of clients recently contacting me with conditional formulas not behaving as expected, when testing for zeros.

Read More

The Things You Learn at a 42 Under 42 Dinner

I am lucky enough to be part of the North West 42 under 42 alumni, and as such get invited to their annual dinner this week.

Read More
Crystal Reports, Crystal Dashboarding (Xcelsius) & SQL Reporting Services Blog, Training, Consultancy, Report Writing, Support & Maintenance