James Trenberth Posted October 6, 2017 Share Posted October 6, 2017 How do I rearrange lighting positions so that they are in the desired order when generating Paperwork Quote Link to comment
RickR Posted October 6, 2017 Share Posted October 6, 2017 Best to do the sorting in the report. (I strongly recommend the interactive report/worksheets in the library over the "Generate Reports" command.) Worksheets can be sorted by a column value or alpha. I usually sort by position name, but sometimes by X or Y since I always draw with 0,0 at plaster-line center lots of raw position information translates to stage positions. Put =Ycoordinate() in a database column and it should show the insertion point value. Sort by that and you have an Upstage/Downstage or L/R order. You can also set that column to 0 width so you don't see it on the page. You can also sort by multiple columns so booms with the same X can be sorted L/R with their Y coordinate. Clear as mud? Worksheets can get really complex so feel free to ask for specifics. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.