Writing an Events Report in Crystal

Rita Nicholson · June 2015

Hi,

I am trying to write a crystal report (outside of RE) for a Golf Event. I'm having trouble linking the participant table to the event seating. I've set up my groups (foursomes) and will be assigning them to banquet tables, I can't seem to get it to work.

I have:

Records_ID to Participants_recordS_ID

Participants_Event_ID to Special_Event_ID

Special_Event_ID to EventSeatGroup_ID

I've tried a few other linking scenarios but nothing seems to work. Appreciate any help....thanks. Rita

Chester Bammel · June 2015

I am not totally familiar with these tables,
but I think the only thing you need to change is the id you used
for Event Seat Groups.

Special_Event.ID to
EventSeatGroups.EventId

Chester
Bammel

Business
Analyst

IT
Enterprise Services

Division of
Information Technology

Sam
Houston State University

Box
2397 Huntsville, TX 77341

Office - (936) 294-2351

Rita Nicholson · June 2015

thanks Chester but I tried that, it gives me multiple rows for each constitutent, as if they are assigned to each group. I have 36 group (18 golf holes x 2) and each constituent is assigned to each group.

Chester Bammel:

I am not totally familiar with these tables, but I think the only thing you need to change is the id you used for Event Seat Groups.

Special_Event.ID to EventSeatGroups.EventId

Chester Bammel

Business Analyst

IT Enterprise Services

Division of Information Technology

Sam Houston State University

Box 2397 Huntsville, TX 77341

Office - (936) 294-2351

James Andrews · June 2015

I'm also not extremely familiar with event reporting from the back end of RE, but what I take as a starting point for these sorts of situations is to imitate the autogenerated SQL in query. I just wrote a quick one where I pulled in group, group/seating note, seat name & number, table/row name & number, and section name & number, it linked:

Participants.eventID = special_event.ID

tableseat.participantID = participants.ID

sectiontable.ID = tableseat.tableID

eventsection.ID = tableseat.sectionID

And it also used the GetParticipantGroupName() function in the select clause.

Rita Nicholson · June 2015

Thanks, I will give it a try, but I still need to get the table group.

Sent from my iPad

James Andrews · June 2015

Rita Nicholson:

Thanks, I will give it a try, but I still need to get the table group.

Sent from my iPad

Where is the table group in query? Is that different from Group under Participant?

I'm interested in what you find out, because we are heading toward more usage of the Event module and the canned reports are not super useful...

Elaine Tucker · June 2015

Rita,

How are you grouping your teams/foursomes?

When you are writiing the Crystal Report you can group on your "foursome" and that keep them together.

Supress the Group Line and let the detail lines show, that should prevent multiple listings.

Do you have the event in RE?

Writing an Events Report in Crystal

Comments

Categories