Show separate finds on one layout

[Oyseka]

Hi all,

Is there a way to show two separate find on a single layout. What I am trying to do is show period data from my Line_Items table and also show the same period in the prior year at the same time for comparison.

[RodSierra]

Well you could simply open a new window from the first found set to find the second criteria, or if from the same window use the extend found set command for the second find.

[Oyseka]

Well you could simply open a new window from the first found set to find the second criteria, or if from the same window use the extend found set command for the second find.

Hi RodSierra,

Yes I thought of the new window route which is fine for me, I've got a 30" monitor but most of my users are on 15" laptops so generally they would not fit on screen. The extend found set would just populate the existing fields with more data so, while it works, it would not give a side by side comparison which is what I am trying to get. I was trying to figure a way to use two separate portals on a layout, one with a self join and the other to 2nd table occurance but I can't figure it out.

[RodSierra]

If you really want to use portals: In your Self join add two global date fields (date start, datestop) to filter the date range. Then duplicate this relationship, and add two more global date fields datestart2, datestop2. You can then have two portals with variable date ranges for comparison. But it may be better to do this in one summary report summarized by the item and the year field.

[Oyseka]

Yep, that does it thank you. It would have been a whole lot easier to just do the summaries but as ever, they are used to a format from excel and they want something the same. Thanks for your input