Specification PCXML

[BigBart81]

Is there a specification of PCXML?

[atcodedog05]

Hi @BigBart81 

can you be more elaborate on what you are looking for.

[BigBart81]

Hi @atcodedog05

I'm working on some reports, but the design part is limited, so I came up with the idea, to create a template in pcxml and just replace the parts I need in the workflow. For this it would be good to know how pcxml is specified. Looking at the data I saw, that there is a "srcreport" tag and a lot of html tags. But it would be helpful to get more details.

I was used to make SSRS reports, but I don't have the possibility in my new position. As this was pixel perfect, I'm now looking for more control in designing reports.

[danilang]

Hi @BigBart81 

I've never been able to find a reference for Alteryx's PCXML.  @CharlieS is person that I know with the most PCXML experience, so maybe he can point you in the right direction

Dan 

[CharlieS]

If there's documentation, I haven't found it either. As a Hail Mary play, we could ask @AdamR_AYX if he has anything to add. 

All of my work with PCXML/Composer has been entirely based on copy-paste-programming. I'll build/modify code with Formula tools and use the Report Text tools in Expert mode to build it back into PCXML. 

Maybe if there's a specific task you're stuck on, share it and we'll see what we can do to help. 

[BigBart81]

Hi Everyone

Thanks all for your help. At the moment I don't have a specific problem. I just wanted to do some research first. But it looks like there is no specification at all and I will do some reverse engineering.

[BigBart81]

Hi @CharlieS, @danilang, everyone

I created a small repository to document any knowledge about PCXML. Don't know if anyone ist interested, but any support would be welcome. I try to update any new knowledge I create while working with pcxml.

[DawnDuong]

Hi @BigBart81 

Did you manage to get started with the PCXML repository? I cannot seem to find anything on PCXML documentation on Alteryx Help and from the various replies here that does not exist in Alteryx Help >.< 

I am trying to figure out if we can do padding, border formatting etc. with the Expert mode.

Dawn.

[ChrisWaspe]

Hi All. Apologies @BigBart81 for high jacking your discussion slightly but this may help. @CharlieS I am trying to created formatted excel reports with a contents page with hyperlinks to each of the tabs. I have created a process which uses the inbuilt web hyperlink functionality of the Report Text Tool to create the hyperlink node in the underlying excel xml. I have then used a combination of Run Command Tools and other tools to change the file type of the file to .zip, unzip this file, find the appropriate sheet, edit the underlying xml hyperlink child node and then save and recreate the excel file. This process works in theory but currently 'breaks' the excel file. It would be much easier to create the hyperlink child node using the Expert mode of the Report Text tool. I wonder if you could possibly assist with something like this?

[andyrea83]

hi everyone, on the topic of pcxml does anyone know how i can change the table format to be in millions for example i want 1200000 to show as 1.2, when I output to excel....but i dont want to divide by 1,000,000 and lose the detail

anyone have any success with this?

thanks

Andy