Advertisement

03.29.2008 at 08:51AM PDT, ID: 23279493
[x]
Attachment Details

crystal report formart/query

Asked by cognos79 in Crystal Reports Software

Here is the business logic for my problem:
I have to list all the companies and their point of contacts and all the programs that the company is associated with. Company is at higher level and contacts, programs are at child level.
A company can have more than one point of contact and may have either 0 or more than 1 associated programs. Attached is the report output. The programs should be the first column.IS it possible to do this?
I think this is not possbile in sql bc when I do a join on company Id and get the programs and point of contacts it will repeat the same data. what other approach can I follow?

Thanks...
Start Free Trial
Attachments:
 
output.txt (612 bytes) (File Type Details) 
final report output
 
[+][-]03.29.2008 at 11:38AM PDT, ID: 21237634

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.29.2008 at 02:17PM PDT, ID: 21238173

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.29.2008 at 04:13PM PDT, ID: 21238542

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.31.2008 at 01:29PM PDT, ID: 21248874

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.31.2008 at 02:23PM PDT, ID: 21249335

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.31.2008 at 05:42PM PDT, ID: 21250420

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

Zone: Crystal Reports Software
Sign Up Now!
Solution Provided By: cognos79
Participating Experts: 1
Solution Grade: A
 
 
[+][-]03.31.2008 at 06:34PM PDT, ID: 21250606

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.

 
[+][-]04.01.2008 at 06:18AM PDT, ID: 21253557

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.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628