Worksheet for Listing Sheet Number or/and Sheet Name?

[orlando Teixeira]

Hello Ppl

I am trying to make a report to list all of the existing sheet layers but order them by Sheet Number.

Can this be doable????

p.s. i google it and search here but i didnt find a solution...

thx in advanced

[michaelk]

In the Architect workspace there is a command. I think it's Tools>Reports>Create Sheet List

But it's really easy to roll your own. It pulls the data from the title block, which pulls the data from the sheet layer navigation palette.

Create a database row in a worksheet with the criteria:

RECORD 'your title block record' IS PRESENT

For the Sheet Number column use the call:

=('your title block record'.'S_Sheet Number_SN') to get the sheet number. Similar calls to get the sheet title or whatever else you want.

Then sort by the sheet number field.

I'll post an example.

It's from 2013. It will probably work fine in 2011, but a thing or two might get funky....

hth

mk

[orlando Teixeira]

Hello good morning

thx for your reply

I cant do as you said, i am doing something wrong.

By the way, you are getting sheet number from title block or sheet layer ????

I am asking this because i wanna extract those records from sheet layer not from title blocks ...

Thx

p.s. file attatched

Edited October 14, 2012 by orlando Teixeira

[orlando Teixeira]

Hello michaelk

well i was nocking my head in the walls when i decided to remake the worksheet using "make report" and using my titleblock fields.... and guess what ????

I am a dumbass because it worked at the first try lololol

Thx for your answer, it was the correct one

Orlando