In need of VERY HARD Crystal Questions for Interview! 3

[alistairpaul]

Hi folks - we're about to interview some people that pride themselves on being Crystal experts and I was wondering if anyone could throw some 'killer' questions my way to really test their knowledge.

Thanks for your help!

 

[HoosHot]

best thing - if you have crystal installed and a table (or two) that they can access, see if they can get connected to the database, and see if they can create a semi-decent report on the fly/on the spot. make them group things. the suppress logic is always tough for me - yes, definitely see if they code up some cool crystal logic in the formula editors. just look at some of the questions posed on this forum - ask them the questions and see what their answer is.

 

[kenhamady]

Here's a fun one. Requires knowledge of 3 advanced topics (subreports, shared variables and running total formulas).

Employee table includes Name, SSN and Dept.
Benefit records include SSN, benefit type and cost of each Benefit. One to many relationship between the tables.

Goal is to list all employees from a single department, with the total benefit cost for each Employee, and a grand total for this department.

The problem is that the SSN in one table has the dashes stored, and the other table doesn't. (no link is possible.)

The answer is that you have to use a linked subreport to gather the benefit records for each employee. You need to use shared variables to bring back the subrepot totals to the main report. You then need a variable running total formula to accumulate the totals from the subreport into a grand total in the main report. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[alistairpaul]

Great Stuff Ken - Thanks!

It's no wonder you're at the top of the expert list!

 

[kenhamady]

Of course, your prospect may also read TT.

Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)