Anyone ever try the App Studio Format = Excel Pivot?

[robert fuschetto]

I was wondering how well it worked, any advise etc. Are there limitations to how the pivot is set up etc. Ex: Can I set it to do Running Total In Dept for example..Can I set up Columns/RowsPageArea,...I am not really sure what level of sophistication is available.

I see this when I set the output and I am not really even sure what to do here:

[Patrick Huebgen]

Make sure to add some Page and Cachje fields and only add one measure to start with (measure needs to be "Detail" - PRINT

[robert fuschetto]

YEs, I did this. I was wondering if anyone had any idea to what extent of sophistication a pivot could be set up. Rows, Columns, Page Area etc. Actually it would be nice if WF could just create a hold file, open an excel template and refresh.

[Patrick Huebgen]

I prefer AHTML - way more modern and no Excel needed

[robert fuschetto]

It looks more modern by is not as flexible as a well defined pivot. Now if WF can only produce a very rudimentary pivot not able to take advantage of all feature...then I agree,

😉

[Patrick Huebgen]

It's getting very close to pivot in recent versions of AHTML - if you need even more flexibility and functionality why not use Designer?

[robert fuschetto]

We did...but a couple years ago. It was not up to snuff. Too many things did not work. I understand its gotten better but we are in the middle of other upgrades now so we will need to wait a while before we upgrade again.

:(

[Patrick Huebgen]

it's way better - which version are you using as long as you are on 8207 you should have a very good version

[robert fuschetto]

8207.28....Understand we need not only to interface it with existing content (10+ years worth) but to also start to use it for new content. We started a new portal with it but it quickly fizzled. I used to have al list...a dozen or so items....from issues with interfacing with HOLD files, to charts not sizing correctly to passing parameters, to drop down list issues...it ran the gamut....it simply would have been a step backward for us so we do not use it. I assume by now they have worked the kinks out...but we must wait.

[Patrick Huebgen]

If you want me to send you a sample AHTML just drop me a private message

You are on 8.207.28 already?

Patrick

[robert fuschetto]

We use AHTML now and then but I am not aware it allows the user to move items around etc. Example:

 

So beneath Division we have SubDivision, Company, Dept, Cost Center, Provider....the user may wish to look at any aggregate. In a pivot they would simply drag and drop from page area etc. I am not sure how that would work here...I'd have to put all those items on the report (across the report?) and have them filter...gets messy. Or I'd need to add drill downs which is more work...

This pivot is easier to work with..of course there maybe something I do not know about AHTML...

 

I appreciate your time!