Need help here...I'm trying to get found sets side by side in a layout

[jgerton]

I have a table full of event data that I can easily show on a layout using a found set by the date of the events.

I would like to create a layout that has the found set of a requested date listed and then right next to it show the following dates events listed.

Using portals and a self-related table, I can't get this to work. And I haven't had any luck finding a previous post related to this topic.

Maybe someone has tried this before or can point out a previous post that addresses this topic.

Thanks,

Jon

[stanley]

Jon:

One way to do this would be to set up two date fields to hold your two dates: the date you searched for and the next day. Both of those would be set via Set Field [] in your report script. Then you could have a portal based on the first date on the left, another based on the second date on the right, and you'd have the data side-by-side.

That's pretty basic, which to me means that I've probably misunderstood the question. Hopefully not.

-Stanley

[jgerton]

When I first attempted this, I had a "report" table with two fields in it, one was the date that was being searched and the other was that day + 1.

Then I got stuck with the layout. I wasn't sure how to get two portals from the same table of data to appear in the layout, and still show up with the data from each day separated out. All I got was the date searched in one portal and the other portal was blank.

If I'm understanding you correctly...

Do I make the table of event data related by event date to search date and the date+1 fields in the report table? And in doing so, that should create a second instance of the event table in the relationship graph, right?

Hope this makes sense.

-Jon