Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
Be original
 
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!!!!

04
August

How Do I Create a Banded Report with Grouped Tables

During a recent training course a delegate asked "How do I create a banded report in a grouped table?"

Read More
13
June

How Do I Display Zeros instead of Blanks in a Matrix in SSRS 2008?

During a recent SQL Server Reporting Services 2008 report writing project, the client wanted all the spaces of the matrix, to be replaced with zeros.

Read More
13
May

How Do I Sort by Financial Year?

During a recent SQL Server Reporting Services 2008 report writing project, my client wanted the budget vs actuals charts and matrix months sorted by financial year instead of calendar year.

Read More
03
July

Tip: Making all the Page Header Section Heights the same in SQL Reporting Services 2008

A number of clients have asked "How do I ensure that all the page headers of the report are the same height in SQL Server Reporting Services 2008?"

Read More
25
June

How Do I Print Picture Metafiles in Crystal Reports Correctly?

Over the last couple of weeks I have had a number of clients asking the same question "How Do I Print Picture Metafiles (*.wmf and *.emf) extension files correctly"? in various versions of Crystal Reports

Read More
23
May

How Do I Display Double Lines in Tablix Items in SQL Reporting Services?

During a recent SQL Reporting Services 2008 (SSRS 2008) report design project, the client needed to display the totals within a Tablix report item with bottom double line border

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
25
February

How Do I Remove the Extra Pages in SQL Reporting Services 2008?

I have had a number of clients of the past few months all asking the same question, "How Do I Remove the Extra Pages in SQL Server Reporting Services 2008?"

Read More
14
February

How can I Add Multiple Conditions to the Visibility Property in SQL Reporting Services 2008?

During a recent SQL Server Reporting Services 2008 (SSRS 2008) report design project, a client asked "How can I Add Multiple Conditions to the Visibility Property of a Report Item?"

Read More
24
January

How Do I Add Text Summary and/orGroup Name Fields without Losing the Drill Down Functionality in Crystal Reports

I have had a number of customers ask me about how they can retain the drill down functionality, when the Group Name fields and/or Summary fields are added to some text, in various versions of Crystal Reports

Read More
08
January

How Do I Remove Duplicate Records in Crystal Reports?

I have had a number of clients with the problem of their datasets returning duplicate records in Crystal Reports.

Read More
12
December

How Do I Create an Index for a Dynamic Parameter in Crystal Reports 2008?