Crystal Reports question (using VB)

[Brad]

This is the next step of a bigger project that I am working on and I have
hit a wall.

All forms that I have created for this project are working fine. This is
the one that I have a problem with.

I have a dataset that contains entry information for dog shows. Each breed
of dog needs it's own judges book for that particular show. Each dog entry
is also entered into one of five (5) aged based classes and then further
split into males and females. So I have the dataset pulling in just the
entry information for the particular show that we are working on. Here is
the problem.

When I create the Crystal Report, I have the groups that work however I need
the entry to appear in a certain column that appears on the report. Should
this be done through a formula? The other bigger problem that I have is
that only one entry is appearing on one report at a time where I need one
form for each breed and if there are ten entries for that breed, I need
these ten entries to appear all in their respective class columns on the
form. Make sense?

My header information for the form which are groups, works just fine (this
is the show date, the show number, the breed and the variety (if
applicable)).

I just need a starting point or change my approach to this.

I am sorry also if I am posting to the incorrect newsgroup, but I try to
post in the Crystal Reports group and I really don't get a response.

Thanks for the help.

Brad

 

[Bernie Yaeger]

Hi Brad,

I looked at your post quite a while ago and hoped someone would answer, but
I feared you wouldn't get much of a response.

This is as good an n/g to post for crystal issues as any; the 'crystal' n/g
is pretty useless.

Re the event - yes, make it a simple formula so that it can then be posted
anywhere on the report. As for the rest of your needs, frankly I can't
follow them. I know that I often work on a cr report and the issues are so
complex, especially when multiple groups are involved, that it virtually
can't be explained and understanding the issues abstractly is almost
impossible.

Sorry I can't be of more help.

Bernie Yaeger

 

[Brad]

Bernie,

Thanks for the reply. I know there is a way to do this, I just have to find
out how.

Brad

 

[Darious Snell]

If I understand correctly you need to create a dataset with two tables in it.
You need a "one-to-many" design on your tables. There needs to be a field in common
such as "breed". Then, you use the schema editor to create a relationship from
the key field in the master table to the key field in the detail table by
dragging and dropping it inside the designer. (You can do this through code as
well)