Would someone mind trying this little snippet of code and tell me if it works?

We're trying to add a drill-down to a subtotal but we don't want the by field to be displayed. So the snippet works as long as I take the noprint off of the by field, but as soon as the noprint is there, it results in an agent crash. I'd like to know what, if anything, it does on someone else's installation -- be it crash, work, or error.

TABLE FILE CAR
PRINT
     CAR
     DEALER_COST
BY COUNTRY NOPRINT
ON COUNTRY SUBTOTAL AS '*TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
TYPE=SUBTOTAL,
     BY=1,
     FOCEXEC=app/test2y45,
     BACKCOLOR=YELLOW,
$
ENDSTYLE
END

Thanks!!

What is the code in test2y45?

It's just a dummy fex -- it doesn't matter. When I run the above, I never even get a report to display so I never even get the opportunity to drill to anything.

Well, under MRE 7.6.2 on Win platform, the report ran fine, yellow highlight came up and I changed the drill down to a fex in the area and it ran from the drill down.

Report ran fine as-is in 5.3.2 self-service and MRE.

It ran fine as is in 7.1.3 Self-Serve.

I think I oversimplified my repro. Would one of you try this please?

TABLE FILE CAR
PRINT
     CAR
     DEALER_COST
BY COUNTRY NOPRINT
ON COUNTRY SUBTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBTOTAL,
     BY=1,
-*	 COLUMN=DEALER_COST,
     FOCEXEC=app/test2y45,
$
ENDSTYLE
END

If that blows up, try uncommenting the "COLUMN=DEALER_COST" line. If that works, switch it back and try commenting out the "SET HTMLCSS ON" line. If I leave it as-is above, it blows up, if I make either of the changes then it works. As it turns out, we might end up using the COLUMN= anyway -- just confusing why I'm getting agent crashes. I'll be working with techsupport too -- just wondering who else is experiencing the same thing.

thanks for your help!!

These both works for me in 762

TABLE FILE CAR
PRINT
CAR
DEALER_COST
BY COUNTRY NOPRINT
ON COUNTRY SUBTOTAL
ON TABLE PCHOLD FORMAT HTML
-*ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBTOTAL,
BY=1,
COLUMN=DEALER_COST,
FOCEXEC=app/unix_test.fex,
$
ENDSTYLE
END


-------------------------OR------------------------


TABLE FILE CAR
PRINT
CAR
DEALER_COST
BY COUNTRY NOPRINT
ON COUNTRY SUBTOTAL
ON TABLE PCHOLD FORMAT HTML
-*ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBTOTAL,
BY=1,
-* COLUMN=DEALER_COST,
FOCEXEC=app/unix_test.fex,
$
ENDSTYLE
END

What about as-is? Did it work that way too?

Unknown error occurred. Agent on reporting server EDASERVE may have crashed. Please investigate reporting server log.

quote:

Unknown error occurred. Agent on reporting server EDASERVE may have crashed. Please investigate reporting server log.

Good! Welll, not good, but glad that I'm not the only one.

If I comment out BY=1 and leave DEALER_COST, the fex runs shows the link on the dollar field totaled with link.

If I put both in BY=1, column=dealer_cost, the output looks the same.

I think the issue is that you have to let WebFOCUS know what you are subtotaling on so it knows how to handle the data. When it doesn't, the system crashes and burns.

Not sure what BY=1 is getting you of course I learn something new almost daily from this forum.

worked fine as-is in 5.3.2

quote:

Originally posted by Leah:
I think the issue is that you have to let WebFOCUS know what you are subtotaling on so it knows how to handle the data. When it doesn't, the system crashes and burns.

Not sure what BY=1 is getting you of course I learn something new almost daily from this forum.

The BY=1 tells WF that you want the drilldown to only appear on the first by field. Funny thing is, the exact syntax that Dev Studio produces is what crashes. If I modify it as described above then it works. No worries, I'll end up putting the column on there anyway.

Thanks for your help!

Does not work as is on 762. Get agent crash on edaserver.

TABLE FILE CAR
PRINT CAR DEALER_COST
BY COUNTRY NOPRINT
ON COUNTRY SUBTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=SUBTOTAL,
BY=1,
COLUMN=DEALER_COST,
FOCEXEC=app/xxxxxx(MYCOUNTRY=N1),$
ENDSTYLE
END

this worked fine in 5.3.6 from mre. Ira