Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

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


This topic is 6866 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

Posted

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

This topic is 6866 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.