Active Reports designer problem

[GoetzInd]

Hey all,

I am trying to modify the generic active reports set up sheet to output only the tool list and the work offset info. I'm having a tough time as I can't even open the layout in the activereports designer. I am getting the attached error on every file I am trying to open.

Side note, we are switching to active reports from x+ because I want to output the holder number and work offset origins. If there is a way to do that in X+ I'd rather stick with that.

 

Thanks,

Mike

[Newbeeee™]

Bare in mind that if you want a tool list, active reports cannot sort by tool number order.

This is a dissapointment.

[ThRaSH]

I am getting the attached error on every file I am trying to open.

You get this error with every file you to try to open or try to preview\run?

Just trying to eliminate what the problem is maybe you could upload one of your .rpx files that is giving your problems so it can be tested.

 

BTW: I came up with a solution on how to use toolholder pictures in a report. Did that work for you?

[ThRaSH]

Bare in mind that if you want a tool list, active reports cannot sort by tool number order.

This is a dissapointment.

So you are trying to generate a report with pre-set or pre-determined tool numbers?

For example your 1st OP uses tool 37, and your 2nd OP uses tool 25 and the report generates 37 then 25,

but you want the report to show the tools in a descending order of 25 then 37?

 

I believe it would be possible to do this thru scripting. You could load an array with your tool numbers,

sort the array, and then print out your report with your tool numbers in descending number order.

[Zoober]

Tool numbers like this?

 

For the work offset origins, what are you wanting? a difference from WCS origin? or an offset number?

[Newbeeee™]

Thrash / Zoober:- Yes, sorted in order as you describe and show.

A friend of mine is working on a bit of code to run the HTML output through it and convert it into word. He says this is very easy (but all things are relative )

 

Is that Active reports straight out into Excel? If so, perhaps CNC should buy it off you so they can offer it as a 'standard' template, as it looks really neat

[Zoober]

No, that is X+ into Excel. But it is unedited right out of X+/MCX

I put my template on the FTP site a while back. It is under the chooks folder as X+Template_zoob.zip

You can look at the macros and see what I did.

[GoetzInd]

For the work offset origins, what are you wanting? a difference from WCS origin? or an offset number?

 

Zoob,

Yes, the difference from WCS origin. We program everything from the center of table rotation, and outputting the wcs origins with the setup sheet would allow our operators to just input those values into the work offsets and away we go. Another idea we have is to output those values after the end of the program in G10 format. Problem is, I dont know how to do it LOL.

 

Mike

[Zoober]

I have all my posts output G10sin the sof postblock.

done using buffers.

[Guest CNC Apps Guy 1]

You can always use a Manual Entry Operation and output the G10's

 

Your G10 line shoudl look like the following

 

G90G10L2P1X0Y0Z0A0B0

G11

 

L2 = G54-G59

P1 = G54

P6 = G59

 

L20 - G54.1 PX (Extended Offsets)

P1 = P1

~

P300 = P300

 

YOu need the G90 so that it does not add the amount to the offset to which you're writing.

 

Use the G11 Just in case you need it. I've seen machines have MACRO issues with Probes and Lasers when G11 was not commanded after a G10.

 

HTH

[GoetzInd]

Another idea we have is to output those values after the end of the program in G10 format. Problem is, I dont know how to do it LOL.

 

James,

It's not that we don't know how to use G10, it's just that I don't know how to get the values automatically posted from the wcs values.

We program everything from a reference point in the center of the pallet (shown in photo) and we would want the G10 values posted incrementally from that point. Is this even possible? Example:

 

N500G91G28Z0.

N510M11(UNLOCK)

N520G28X0.Y0.B0.

N530M10(LOCK)

N540G90

M99

N550M30

 

G10G91L20P1X0.Y-2.137Z9.896B0.0000

G10G91L20P2X-14.30.Y-2.137Z2.77B0.0000

 

M02

%

[Zoober]

Here are a couple of links to threads on the G10 post mods.

Linky

and linky

Go thru them, and if you need more help, I'll be glad to assist.

 

Here is what it ends up like (no hand edits):

 

 
(***** TOOL LIST START *****)
(T2   * 2.00 3FLT ISCAR FACEMILL [4.95 EXT] * )
(T21  * 3/4 3FLT HANITA FINISH  EM 2.25 LOC [2.3 EXT]  * )
(T22  * 3/4 3FLT HANITA FINISH  EM 1.0 LOC, NECKED 5.00 [5.00 EXT]  * )
(T39  * 7/64 [.109] DIA BORING EM .375 LOC [.75 EXT]ER-11 EXTENSION [5.2 EXT] * )
(T40  * 3/32 [.0313] DIA CARBIDE 2FLT EM .093 LOC [.50 EXT]  * )
(T41  * 5/8 2FLT FINISH BALL EM .75 LOC NECKED 5.00 [5.0 EXT]  * )
(T61  * A6488 .0937 8 X D [2.15 EXT]  6.0 LONG ER HOLDER * )
(T63  * 3.3MM CARBIDE DRILL 1.10 LOC [1.3 EXT] ER-11 EXTENSION [4.5 EXT] * )
(T64  * 2.5MM CARBIDE DRILL .98 LOC [1.50 EXT] * )
(T65  * 1/4 X 90 DEG SPOT DRILL [.75 EXT] ISCAR SHRINK IN 1/4 ID 5/8 OD [4.5 EXT] * )
(T68  * 5MM CARBIDE DRILL 1.73 LOC [1.9 EXT] ISCAR SHRINK IN 6MM ID 16MM OD [4.5 EXT] * )
(T73  * CY093T06 #2 [.221] FLAT BTM CARBIDE DRILL .500 LOC [.75 EXT]   * )
(T74  * .218 CARB DRILL 1.73 LOC [1.80 EXT] ISCAR SHRINK IN 6MM ID 16MM OD [4.5 EXT] * )
(T80  * .1875 X 120 DEG SPOT DRILL [2.0 EXT] * )
(T153 * CY093T15 [.228] FLAT BTM CARB DRILL .500 LOC [.75 EXT]ISCAR SRK1/4X 5/8 [4.5 EXT * )
(T155 * 2.85MM CARBIDE DRILL 1.14 LOC [1.50 EXT] ER-11 EXTENSION [4.5 EXT] * )
(T156 * 2.25MM CARBIDE DRILL .91 LOC [1.50 EXT] * )
(T172 * CY093T16 .1175 REAMER .04X 45 DEG LEAD [2.5 EXT]  * )
(T255 * M6X 1 [.17] CARB TM .528 LOC [1.0 EXT] ISCAR SHRINK IN 1/4X5/8[4.5 EXT] * )
(T256 * M3 X .5 [.090 DIA] CARBIDE THREADMILL .264 LOC [1.0 EXT] * )
(T257 * M4X .7 [.110 DIA] CARBIDE THREADMILL .342 LOC [1.0 EXT] ER-11 EXT [4.5 EXT] * )
(T286 * CY093T10.1207 DIA BORING EM FORM TOOL .375 LOC [.75 EXT] ER-11 EXTENSION [4.5 EX * )
(T293 * CY093T09 .2356 DIA BORING EM FORM TOOL .50 LOC [.75 EXT] * )
(T295 * CY093T17.2390 DIA BORING EM .50 LOC [.75 EXT]ISCAR SHRINK IN 1/4X5/8[4.5 EXT] * )
(T298 * 1.1037 DIA BORING SANDVIK BORING HEAD ADAPTER C3-825A-AAB072A  1.0 LOC [1.25 EXT * )
(T482 * .250 X .010 R ENDMILL [2.0 EXT] ER16-3.5 * )
(***** TOOL LIST END ******)

(***********************************************)
(***********  WORK COORDINATES START  **********)
G90 G10 L20 P1 X-5.56 Y-12.3871 Z2.797 B0. ( B0. )
G90 G10 L20 P2 X-2.8 Y-12.3871 Z-5.56 B0. ( B90. )
G90 G10 L20 P3 X5.56 Y-12.3871 Z-2.8 B0. ( B180. )
G90 G10 L20 P4 X2.8 Y-12.3871 Z5.56 B0. ( B270. )

G11
(***********  WORK COORDINATES END  **********)

[GoetzInd]

Zoober,

Thanks for the help. Are those numbers derived directly from the WCS orgin values?

 

Mike

[Zoober]

Yes they are. The variables tox, toy, toz hold the values in the view manager origin for each view. That is why buffers are used.

These values come from machine zero, so if your WCS origin is not at machine zero, you will need to calculate, as I have done in the above linked thread i quote below.

If you look in the view manager origin values for each view, those are the values that will be in you G10 statement (after calculating any formula like below

toy3 = toy6-25.5905)

My Y machine zero is 25.5905 above my pallet, where I set my WCS.

tox3 = tox6 #Figures X Offset from machine zero

 

toy3 = toy6 - 25.5905 #Figures Y Offset from machine zero

 

toz3 = toz6 #Figures Z Offset from machine zero

 

I hope this makes sense.

[GoetzInd]

Zoob,

This is exactly what i'm looking for. I'm going to poke through the post when I have a chance and see if I can get it to work. Unfortunately, I have pretty limited experience when it comes to posts mods. Definitely something I want to get better at. Thanks for the help.

 

Mike