Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Drill Down Info 1

Status
Not open for further replies.

NewToCR

Programmer
Oct 20, 2005
54
US
There could be unfortunate thing that I will need to incorporate this into CR.

Company Info List that includes Executives List at the bottom of the Info List.
Done...

Now I need to be able to read Individual Info if I want to by...clicking on Individual Name and open another window or something.

So we have plain nice Company Info List to look at unless we want to drill down to Individual profile. Any...I mean ANY ideas? Thanks a lot
 
1st idea is to provide technical information:

Crystal version
Database/connectivity used
Example data
Expected output

Not knowing what you have, nor what the output should look like, you might want an on demand subreport linked to the Individual, whatever the individual information is that you want, depending upon the database, depending upon the Crystal version, well, you get the idea.

Is Executivce the same as Individual List?

-k
 
CRv 9.0
SQL Server/ODBC

Company Name
Year Established
Yearly Sales
Address

Emloyee List 1. LN_FN
2. LN_FN
3. LN_FN

It could be enough to look at BUT if anyone wants to see address or email of each employee - it should be available.



 
Group by the company, and join the company table to the employee table.

Place the employee data in the details, and the company data in the group header.

Right click the details and select format section->hide.

Now you have drill down capabilities. If they click on the company it will display the employee data for that company.

-k
 
Really? I wil certaintly try and hoping you are right! THANKS
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top