Creating customized cross-tab

[nvtjellis]

We just purchased Crystal Report 8.0. Yes it is an older version, but we are using ProcCare's Child Care Manager application. Their system will not support ver. 9 or 10.
We need to create a report using data from ProCare's Access data base. Crystal Report is used by ProCare to create reports, but their report must be generic to all their users, so we have to create our own.
We are not trained in Crystal Report and so have to fly by the seat of our pants. We have looked at Cross-tab
but can not modify the cross-tabs for our needs. Can we create our own cross-tab and have the data inserted as noted by the "X"'s. Or if we can change the cross-tabs, then how. This detail design is what we need. Also, this cross-tab will need to repeat across the page before going to the next page. We are able create the "table" with MS/Word and key in the information. But we rather have the data base supply the information and Crystal Report seems to be the way to go.....
Can anyone help us here
----------------------------------
|Child's Name|Mon|Tue|Wed|Thr|Fri|
|---------------------------------
| xxxxxxxx | | | | | |
| Grade x | x | x |x | x | x |
| Teacher ---------------------
| xxxxxxx | | | | | |
| | x | x | x | x | x |
|---------------------------------

 

[synapsevampire]

First, MS Word can query data as well, however I would suggest learning Crystal, it si a far superior reportuing tool.

Since you didn't share what the data looks like, user interaction (parameters), etc., rather you only show the a pseudo example of the intended output, I can't get too specific.

A manual cross-tab should work for you, but again, this is all wild speculation since you feel that xxxxxxx is a meanignful representative of something.

It appears that you would group by Student, and then by Teacher.

Now build Running Totals or Formulas to display the individual data point with filtering criteria such as:

day({table.date}) = 2

This is an overview, and may not suit your needs, and I understand that it's fairly vague, but you should supply technical information instead of text descriptions:

Example data (not X's for every field please)
Expected output (based on the example data).

It doesn't have to be real data.

-k

 

[nvtjellis]

The sample format would have the following data in it.

Child's last,first name, Child's Grade, Teacher.

The two rows will have one of the following values:
F, E/O, V or NO.
I tried showing the format of the what I wanted.

I'm learning CR, just get it last Tuesday. I believe I can create what we want, just need directions on the "how to".
If I can "create" the layout I desire (customized), just where and how can I.

If I'm leaving something out, let me know.