Bill Craven

Free Active Reports Setup Sheet

Recommended Posts

1 hour ago, jean said:

Question, I took a original report file and all the subfolders associated with the main file and made copy of all so I can create my own custom post. when I got done I went back and updated the sub reports to "report name" reflect the new named sub-file's but they are not updating when I run report on Mastercam? when I review each file independent if shows my edit but when I run report thru Mastercam it defaults back to original report. 

Am I missing something here??????????????????? :help::unworthy:

thanks in advance

Are you using F2 to select the report you want, from the dialog that opens when you click setup sheet?

Share this post


Link to post
Share on other sites
Just now, So not a Guru said:

Are you using F2 to select the report you want, from the dialog that opens when you click setup sheet?

Yes sir, I've copied the master file and the sub files then proceeded to rename the and update the names to it references the new files so if something went wrong I still had originals..

original= Setup Sheet (MT).rpx

new= Setup Sheet (MT)_FARRAR.rpx then this didn't work so I tried Setup Sheet (MT_FARRAR).rpx

I don't know if their is something else that links it also?

:question:

 

Share this post


Link to post
Share on other sites
1 hour ago, jean said:

Yes sir, I've copied the master file and the sub files then proceeded to rename the and update the names to it references the new files so if something went wrong I still had originals..

original= Setup Sheet (MT).rpx

new= Setup Sheet (MT)_FARRAR.rpx then this didn't work so I tried Setup Sheet (MT_FARRAR).rpx

I don't know if their is something else that links it also?

:question:

 

I don't have my seat active on this laptop, but I'm pretty sure the way the files must be saved is this.

The main file is :

Setup Sheet (main_name).rpx

The slaved files are each preceded by a dash, like this:

-Setup Sheet (main_name-file).rpx

-Setup Sheet (main_name-operation)rpx

-Setup Sheet (main_name-tool).rpx

-Setup Sheet (main_name-tools).rpx

Of course there are many other slave files that you can create, depending upon your own needs. I don't know if it's required, but I keep all of the rpx files in the "Shared Mastercam XXXX/common/reports/SST" directory. That can probably be changed in the files section of the configuration utility.

Also, you must have each sheet pointed to the xml file that populates the fields.

Share this post


Link to post
Share on other sites
27 minutes ago, So not a Guru said:

I don't have my seat active on this laptop, but I'm pretty sure the way the files must be saved is this.

The main file is :

Setup Sheet (main_name).rpx

The slaved files are each preceded by a dash, like this:

-Setup Sheet (main_name-file).rpx

-Setup Sheet (main_name-operation)rpx

-Setup Sheet (main_name-tool).rpx

-Setup Sheet (main_name-tools).rpx

Of course there are many other slave files that you can create, depending upon your own needs. I don't know if it's required, but I keep all of the rpx files in the "Shared Mastercam XXXX/common/reports/SST" directory. That can probably be changed in the files section of the configuration utility.

Also, you must have each sheet pointed to the xml file that populates the fields.

Ok, ill get a fresh start tomorrow and try to rename in this manner. Ill update the thread if I'm successful.

Thank you

  • Like 1

Share this post


Link to post
Share on other sites

You need to open the first RPX file (the one that you click on to run the report in Active Reports Designer) and then open the detail list on the right side and then look for any srpt_file  and then rename the report template so that it matches the report that you renamed. 

 

This is where the link is made.

There maybe multiple srpt_files in the detail section.  You will need to go into each one and update the name to whatever you named it.

 

Then you will need to open that sub report and do the same thing for any srpt_File that you find there.

 

image.png.0117f3f585b02dad8f2667126e64d9bf.png

 

 

  • Like 1

Share this post


Link to post
Share on other sites

Whenever I start working on an Active Report where I am going to be doing major work to it, I will map out the hierarchy by going into each rpx file and looking for the srpt_file and the links.  This makes it much easier for me to keep track of things if I want to rename everything for a new Active Report setup sheet.

The hierarchy is critical in how things are related and what order AR will gather the information for the final output.

 

11.     Setup sheet (MT)

a.     -Setup Sheet (SZ).rpx

                                                              i.      -setup sheet (SZ-M)

                                                            ii.      -setup sheet (SZ-L)

b.     -Setup Sheet (FILE).rpx

                                                              i.      -Setup Sheet (OPERATION).rpx

1.     -Setup Sheet (OPERATION-L).rpx

a.     -Setup Sheet (TOOL).rpx

2.     -Setup Sheet (OPERATION-M).rpx

a.     -Setup Sheet (TOOL).rpx

3.     -Setup Sheet (OPERATION-T).rpx

a.     -Setup Sheet (MAN-ENT-INFO).rpx

                                                                                                                                      i.      -Setup Sheet (MAN-ENT-DATA).rpx

                                                            ii.      -Setup Sheet (TOOLS).rpx

1.     -setup sheet (Tool)

a.     -Setup Sheet (TOOL-M).rpx

b.     -Setup Sheet (TOOL-L).rpx                                             

                                                                                                                                      i.      -Setup Sheet (LATHE-TOOL-HOLDER).rpx

                                                                                                                                    ii.      -Setup Sheet (LATHE-TOOL-CUSTOM).rpx

                                                                                                                                 iii.      -Setup Sheet (LATHE-TOOL-INSERT).rpx

                                                                                                                                  iv.      -Setup Sheet (LATHE-TOOL-DRILL).rpx

                                                                                                                                    v.      -Setup Sheet (OP).rpx

c.      -Setup Sheet (TOOL-B).rpx

                                                                                                                                      i.      -Setup Sheet (STATION).rpx

                                                                                                                                    ii.      -Setup Sheet (OP).rpx

                                                         iii.      -Setup Sheet (OFFSETS).rpx

1.     -Setup Sheet (OFFSET).rpx

c.      -Setup Sheet (CAPTURES).rpx

                                                              i.      -Setup Sheet (CAPTURE).rpx

 

 

  • Like 1

Share this post


Link to post
Share on other sites
6 hours ago, Bill Craven said:

Whenever I start working on an Active Report where I am going to be doing major work to it, I will map out the hierarchy by going into each rpx file and looking for the srpt_file and the links.  This makes it much easier for me to keep track of things if I want to rename everything for a new Active Report setup sheet.

The hierarchy is critical in how things are related and what order AR will gather the information for the final output.

 

11.     Setup sheet (MT)

a.     -Setup Sheet (SZ).rpx

                                                              i.      -setup sheet (SZ-M)

                                                            ii.      -setup sheet (SZ-L)

b.     -Setup Sheet (FILE).rpx

                                                              i.      -Setup Sheet (OPERATION).rpx

1.     -Setup Sheet (OPERATION-L).rpx

a.     -Setup Sheet (TOOL).rpx

2.     -Setup Sheet (OPERATION-M).rpx

a.     -Setup Sheet (TOOL).rpx

3.     -Setup Sheet (OPERATION-T).rpx

a.     -Setup Sheet (MAN-ENT-INFO).rpx

                                                                                                                                      i.      -Setup Sheet (MAN-ENT-DATA).rpx

                                                            ii.      -Setup Sheet (TOOLS).rpx

1.     -setup sheet (Tool)

a.     -Setup Sheet (TOOL-M).rpx

b.     -Setup Sheet (TOOL-L).rpx                                             

                                                                                                                                      i.      -Setup Sheet (LATHE-TOOL-HOLDER).rpx

                                                                                                                                    ii.      -Setup Sheet (LATHE-TOOL-CUSTOM).rpx

                                                                                                                                 iii.      -Setup Sheet (LATHE-TOOL-INSERT).rpx

                                                                                                                                  iv.      -Setup Sheet (LATHE-TOOL-DRILL).rpx

                                                                                                                                    v.      -Setup Sheet (OP).rpx

c.      -Setup Sheet (TOOL-B).rpx

                                                                                                                                      i.      -Setup Sheet (STATION).rpx

                                                                                                                                    ii.      -Setup Sheet (OP).rpx

                                                         iii.      -Setup Sheet (OFFSETS).rpx

1.     -Setup Sheet (OFFSET).rpx

c.      -Setup Sheet (CAPTURES).rpx

                                                              i.      -Setup Sheet (CAPTURE).rpx

 

 

Yes sir, I did do that. I was getting lost for a second and decided to write down the hierarchy. 

looking for the srpt_file and the links

what links? i thought the srpt_file not the links?

thank you

19 hours ago, Bill Craven said:

You need to open the first RPX file (the one that you click on to run the report in Active Reports Designer) and then open the detail list on the right side and then look for any srpt_file  and then rename the report template so that it matches the report that you renamed. 

 

This is where the link is made.

There maybe multiple srpt_files in the detail section.  You will need to go into each one and update the name to whatever you named it.

 

Then you will need to open that sub report and do the same thing for any srpt_File that you find there.

 

image.png.0117f3f585b02dad8f2667126e64d9bf.png

 

 

I did this and went thru all the files and its still linking to the old after I've made edits to -Setup Sheets

Share this post


Link to post
Share on other sites
14 minutes ago, jean said:

what links? i thought the srpt_file not the links?

Yes sir you are correct.  Technically they aren't links, I just meant linking to the correct sub report.

 

Can you zip up your SST directory and send it to me.  I messaged my email address to you.

Share this post


Link to post
Share on other sites
4 minutes ago, Bill Craven said:

Yes sir you are correct.  Technically they aren't links, I just meant linking to the correct sub report.

 

Can you zip up your SST directory and send it to me.  I messaged my email address to you.

Ok, will do.

Share this post


Link to post
Share on other sites

Okay Jean,

 

I looked at your file structure and names and think that I found the culprit.

The parenthesis are a little fussy and have to be named properly in order to get the correct output.

If the original name of a sub-report was: -Setup Sheet (FILE).rpx, you   have to keep the FILE in parenthesis.  You can't add other letters between the parenthesis.  You can add things after.  This is okay:  -Setup Sheet (FILE) Acme Coyote Catchers.rpx    This is not okay:  -Setup Sheet (FILE-MT-Acme Coyote Catchers).rpx

 

This is from the Active Reports Tips and Tricks document that you can download from Mastercam.com  knowledge base:

 

Using Product-Specific Data

 

When you need to display data from more than one product, use the product-specific files. There is also one for Manual Entry operations, highlighted below.

The Setup Sheet.rpx set of files uses product-specific subreports. For example:

 

Setup Sheet

            -Setup Sheet (FILE)

                        -Setup Sheet (OPERATION)

                                    -Setup Sheet (OPERATION-L)

                                    -Setup Sheet (OPERATION-M)

                                    -Setup Sheet (OPERATION-R)

                                    -Setup Sheet (OPERATION-T)

                                    -Setup Sheet (OPERATION-W)

 

Files must be named with “OPERATION-?”, where “?” is L, M, R, T, or W for Lathe, Mill, Router, Manual Entry, or Wire.

If product-specific data is used in one area, use it everywhere or other areas may get no data. For example, if “OPERATION-M” is used, use “TOOL-M”, “SZ-M”, etc.

 

In X8 and earlier, the parser looks only for the dash and the product letter (-L, -M, -R, -T, -W) in filenames. For example, TOOL-LIST.RPX will output only Lathe data.

 

Beginning with X9, the parser looks for the entire name. For example: “OPERATION-M”. The file name must have the product-specific name in one of the following formats:

"(OPERATION-M)" – () Parentheses

" OPERATION-M " – Spaces

"OPERATION-M" – End of filename

"[OPERATION-M]" – [] Brackets

 

Product-specific data cannot be grouped using the Group Header/Footer option. Only one operation, tool, stock, etc. is available to the subreport.

 

Product-specific subreports cannot access data higher in the data hierarchy. For example, you cannot access the NCIFILE-NAME from an OPERATION-M subreport by using //SETUPSHEET/NCFILE/NCIFILE-NAME. There is no direct access, evident when you see the hierarchy:

 

//SETUPSHEET

            //NCFILE

                        //OPERATION

                                    //OPERATION-M

So it looks like you need to go back and rename your templates with those restrictions and then go and update the srpt file links.

 

 

 

 

 

  • Thanks 1

Share this post


Link to post
Share on other sites
6 hours ago, Bill Craven said:

Okay Jean,

 

I looked at your file structure and names and think that I found the culprit.

The parenthesis are a little fussy and have to be named properly in order to get the correct output.

If the original name of a sub-report was: -Setup Sheet (FILE).rpx, you   have to keep the FILE in parenthesis.  You can't add other letters between the parenthesis.  You can add things after.  This is okay:  -Setup Sheet (FILE) Acme Coyote Catchers.rpx    This is not okay:  -Setup Sheet (FILE-MT-Acme Coyote Catchers).rpx

 

This is from the Active Reports Tips and Tricks document that you can download from Mastercam.com  knowledge base:

 

Using Product-Specific Data

 

When you need to display data from more than one product, use the product-specific files. There is also one for Manual Entry operations, highlighted below.

The Setup Sheet.rpx set of files uses product-specific subreports. For example:

 

Setup Sheet

            -Setup Sheet (FILE)

                        -Setup Sheet (OPERATION)

                                    -Setup Sheet (OPERATION-L)

                                    -Setup Sheet (OPERATION-M)

                                    -Setup Sheet (OPERATION-R)

                                    -Setup Sheet (OPERATION-T)

                                    -Setup Sheet (OPERATION-W)

 

Files must be named with “OPERATION-?”, where “?” is L, M, R, T, or W for Lathe, Mill, Router, Manual Entry, or Wire.

If product-specific data is used in one area, use it everywhere or other areas may get no data. For example, if “OPERATION-M” is used, use “TOOL-M”, “SZ-M”, etc.

 

In X8 and earlier, the parser looks only for the dash and the product letter (-L, -M, -R, -T, -W) in filenames. For example, TOOL-LIST.RPX will output only Lathe data.

 

Beginning with X9, the parser looks for the entire name. For example: “OPERATION-M”. The file name must have the product-specific name in one of the following formats:

"(OPERATION-M)" – () Parentheses

" OPERATION-M " – Spaces

"OPERATION-M" – End of filename

"[OPERATION-M]" – [] Brackets

 

Product-specific data cannot be grouped using the Group Header/Footer option. Only one operation, tool, stock, etc. is available to the subreport.

 

Product-specific subreports cannot access data higher in the data hierarchy. For example, you cannot access the NCIFILE-NAME from an OPERATION-M subreport by using //SETUPSHEET/NCFILE/NCIFILE-NAME. There is no direct access, evident when you see the hierarchy:

 

//SETUPSHEET

            //NCFILE

                        //OPERATION

                                    //OPERATION-M

So it looks like you need to go back and rename your templates with those restrictions and then go and update the srpt file links.

 

 

 

 

 

Will do! thank you for your help and time.

 

Share this post


Link to post
Share on other sites
On 2/23/2019 at 6:45 AM, Bill Craven said:

Greetings all,

I have developed a setup sheet that is really more of an Operation check list.

Developed for minimal paper waste.

It works with all three of the main program types without changing report templates:  Mill,  Lathe, and Mill/Turn.

The operations are color coded:  Blue is turning, Yellow is Milling, and red is Manual Entry.

If the tools are named in Mastercam the way that I recommend, all of the information will be there for the operator:  Insert codes, etc. 

Included in the zip file that is attached is a sample turning program with milling, the Active report templates, a Word doc with instructions on how to install and where to enter information.

 

For best results, pay  close attention to the Word doc on what and where I enter the names and comments of the tools and operations.

 

image.thumb.png.b8a7f93ffe9641622fca15a9197bcc83.png

 

Disclaimer:  Use at your own risk.  

Active_Reports_OP_Tool_List_short.zip


 

I have my own too.  I am trying to steel some of your ideas and putting on mine of which already existed.  Thanks for the share.

setup.thumb.PNG.e827d916cc2f95e6edd955bd5953b301.PNG

 

 

tools.thumb.PNG.8fd74d52f915f1bcabca7a1f3f4fa04a.PNG

  • Like 2

Share this post


Link to post
Share on other sites

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

  • Recently Browsing   0 members

    No registered users viewing this page.

Join us!

eMastercam - your online source for all things Mastercam.

Together, we are the strongest Mastercam community on the web with over 56,000 members, and our online store offers a wide selection of training materials for all applications and skill levels.

Follow us