You're thinking along the right lines. This isn't doable in a view as a report ready to be seen at a moment's notice. You might be able to accomplish it with a third-party reporting tool, or you can use a little trick to make it look like you have done the same thing. I've used this trick in a few other projects and it works well if the report is "batch generated."
Create a view that has your general report layout but with the event information on separate lines as you would expect. For example:
J. Gibson Event A Phoenix June 1, 2005 Event C New York June 12, 2005 Event A Fresno July 3, 2005 T. Jones Event R Philadelphia May 15, 2005 Event Q Chicago June 12, 2005 Event W Seattle August 9, 2005
Then, during the batch cycle, process the view and create a condensed line for the report based on the data displayed in the view. Based on the information above, it might look like this:
J. Gibson Event A--Phoenix--June 1, 2005; Event C--New York--June 12, 2005; Event A--Fresno--July 3, 2005 T. Jones Event R--Philadelphia--May 15, 2005; Event Q--Chicago--June 12, 2005; Event W--Seattle--August 9, 2005
Another option is to have a report form that parses the view when the form is opened. This gives a more accurate representation of the current data, but it may take a while for the form to display depending on the amount of data in the view.
Do you have comments on this Ask the Expert question and response? Let us know.
Dig Deeper on Domino Resources - Part 7
Related Q&A from Brian Mahoney
Find out what types of calculations can be computed for a column in a Lotus Notes view and the best way to go about it with this expert response. Continue Reading
Find out why you can't use Formula language to include a doclink to a specific Lotus Notes view or database and need to use LotusScript instead. Continue Reading
Discover the reasons behind a Notes/Domino admistrator having trouble with disabled options in the "customize this view" section of his Lotus Notes ... Continue Reading