Array or Cross-tab?

[jaxflorida]

Hello,

I am very glad I found this forum! I have only been using CR about 3 weeks now and I have been given a report to create. I am racking my brain trying to figure this report out. I would appreciate it if someone could help me out.

Let me explain what data I have...

A company can be in several "regions" (eg North CA, South CA, West FL, South FL, All FL)

Now, let me explain what I need...

I need a report that will look up all the regions a company is in and then apply a "check" to a "check box" if that company is in that region. All regions must show on the report but only those which the company is in should be checked.


So, I created a cross tab report that will show what regions a company is in. But I can't seem to bring that into my report to "check" any boxes. Secondly, since that didn't work, I have been researching arrays. I think I understand the concept behind an array, but I can't find how to populate it in any useful way.

Again, I would appreciate any help you can give.

 

[kenhamady]

A true cross-tab will not show all regions unless each region is represented in at least record in the report. I assume that a company in 5 regions will bring 5 records into the report?

If so, I would use a manual cross-tab as described in faq149-243, with a conditional column for each region. Then if the count is greater than 1 you print your checkmark.

My April newsletter described how to add checkboxes and other symbols to a report.

http://www.kenhamady.com/news0204.html

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com