Advertisement

03.12.2008 at 08:14AM PDT, ID: 23235333
[x]
Attachment Details

Suppressing blank fields and duplicate rows

Asked by almaler in Crystal Reports Software, SQL Reporting, Business Objects

Tags: Business Objects, Crystal Reports, XI

I am using Crystal Reports XI and have Table A linked to Table B using a left outer join.  Table A contains the name of an asset record and Table B contains the names of people assigned to that asset record.  For example:

Asset Record                                       Contact
===========                                       =======
CI-0000000001                                     John Smith
                                                              Mary Jane

It may be that there is no contact in Table B or one or many contacts in Table B.  For some reason, my report output is showing up like this:

Asset Record                                       Contact
===========                                       =======
CI-0000000001                                    
                                                             
CI-0000000001                                     John Smith

CI-0000000001                                     Mary Jane

I would like to remove the blank field - I don't know why that is show up.Start Free Trial
[+][-]03.12.2008 at 08:50AM PDT, ID: 21107293

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 08:58AM PDT, ID: 21107374

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 10:36AM PDT, ID: 21108592

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 12:07PM PDT, ID: 21109571

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]03.12.2008 at 12:32PM PDT, ID: 21109832

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Crystal Reports Software, SQL Reporting, Business Objects
Tags: Business Objects, Crystal Reports, XI
Sign Up Now!
Solution Provided By: almaler
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628