Writing an Events Report in Crystal

Rita Nicholson

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

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

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

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

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

Sent from my iPad

James Andrews

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

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?