PDF Table action :- Column Headings

[Former Member]

hi all,

Column heading's of the PDF table generated are currently the Column Name's of the Document configuration Column Properties of the Document XML structure. I need the Column Description to show up as headings for the PDF table so that i case use special characters.

In short How do i use the Column description and NOT the Column name of the XML for the PDF table Column headings.

Example :

Column Properties

Name : Automatic_Manual

Description : A/M

Right now the Column property NAME appears as the PDF Column heading instead i need the description to show up.

Appreciate ur response.

Thanks,

Gilmour

[Former Member]

Gilmour,

how do you create the XML document?

If you use a SQL query, use the SELECT ... AS to set the column name you want. As an alternative, you can build a MII XML document and use the XML document action configuration to set the column names you need in your PDF table.

Michael

[Former Member]

Michael,

SQL query is not being used. The xml is generated using the XML document action. In the XML document configuration it doesnt allow any special chararcters as column names. We can use special characters in the Description but we dont have any option in PDF table action to use Column description as the table headings. By defualt it takes the Column names.

thanks,

Gilmour

[Former Member]

I see.

Here is another idea. You cannot use the XML document action to set the column name, but you can try the following:

- create a xml document action, however leave the configuration empty

- use the xml column action to create the desired columns in the empty document (special chars are allowed)

When adding rows:

- use the xml row action to add an empty row

- use the xml data item action to add the column names and values

Hope this helps.

Michael

[Former Member]

Hi Mike,

Nice suggestion !! I have once tried with it but we cant have deformed XML mapped as to the source of the PDF tables. Using special characters in XML will lead to a not well formed XML.

Thanks,

Amit