We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Linq + xml type inference

Hi,

i’m sorry but i have another problem with xml and linq.
The DataSet created through dataSet.readXml() doesn’t seem to have the correct datatypes (or linq reporting engine doesn’t).

For example it doesn’t handle boolean values or date correctly.

If i have an xml containing this attribute:
1950-04-01T00:00:00+01:00

and try to output it on the template using format options for date like this:
<span style=“font-size:10.0pt;font-family:
Verdana;mso-fareast-font-family:“MS Mincho”;mso-bidi-font-family:“Times New Roman”;
mso-ansi-language:EN-GB;mso-fareast-language:IT;mso-bidi-language:AR-SA” lang=“EN-GB”><<[identity.first().birthDate]:“dd.MM.yyyy”>><!–[if gte mso 10]>

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Tabella normale"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

<![endif]–>

the pdf will output the string value and not the correct date:
1950-04-01T00:00:00+01:00

The same occours with boolean datatypes which are always treated as strings…
Once again Mail merge and XmlDataSet treated this values correctly.

Thanks


Hi Simone,

Thanks for your inquiry. I have tested the scenario and have managed to reproduce the same issue at my side. For the sake of correction, I have logged this problem in our issue tracking system as WORDSNET-12394. I have linked this forum thread to the same issue and you will be notified via this forum thread once this issue is resolved.

We apologize for your inconvenience.

Hi Simone,

Further to my last post, note that in contrast to Mail Merge, LINQ Reporting Engine heavily depends on the type of a data field processed. Otherwise, it would be impossible for the engine to use members of this type which is essential due to the engine’s concept. By this reason, the birthDate field is treated as a string and can not be formatted using a date-time pattern.

In this case, you need to use an XML schema that explicitly specifies the type of the birthDate column as “xs:dateTime”. Please load the xml schema as shown below. Hope this helps you.


DataSet dataSet = new DataSet();

dataSet.readXmlSchema(MyDir + "input.xsd");

dataSet.readXml(MyDir + "input.xml");

<w:LatentStyles DefLockedState=“false” DefUnhideWhenUsed=“false”
DefSemiHidden=“false” DefQFormat=“false” DefPriority=“99”
LatentStyleCount=“371”>
<w:LsdException Locked=“false” Priority=“0” QFormat=“true” Name=“Normal”/>
<w:LsdException Locked=“false” Priority=“9” QFormat=“true” Name=“heading 1”/>
<w:LsdException Locked=“false” Priority=“9” SemiHidden=“true”
UnhideWhenUsed=“true” QFormat=“true” Name=“heading 2”/>
<w:LsdException Locked=“false” Priority=“9” SemiHidden=“true”
UnhideWhenUsed=“true” QFormat=“true” Name=“heading 3”/>
<w:LsdException Locked=“false” Priority=“9” SemiHidden=“true”
UnhideWhenUsed=“true” QFormat=“true” Name=“heading 4”/>
<w:LsdException Locked=“false” Priority=“9” SemiHidden=“true”
UnhideWhenUsed=“true” QFormat=“true” Name=“heading 5”/>
<w:LsdException Locked=“false” Priority=“9” SemiHidden=“true”
UnhideWhenUsed=“true” QFormat=“true” Name=“heading 6”/>
<w:LsdException Locked=“false” Priority=“9” SemiHidden=“true”
UnhideWhenUsed=“true” QFormat=“true” Name=“heading 7”/>
<w:LsdException Locked=“false” Priority=“9” SemiHidden=“true”
UnhideWhenUsed=“true” QFormat=“true” Name=“heading 8”/>
<w:LsdException Locked=“false” Priority=“9” SemiHidden=“true”
UnhideWhenUsed=“true” QFormat=“true” Name=“heading 9”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“index 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“index 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“index 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“index 4”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“index 5”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“index 6”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“index 7”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“index 8”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“index 9”/>
<w:LsdException Locked=“false” Priority=“39” SemiHidden=“true”
UnhideWhenUsed=“true” Name=“toc 1”/>
<w:LsdException Locked=“false” Priority=“39” SemiHidden=“true”
UnhideWhenUsed=“true” Name=“toc 2”/>
<w:LsdException Locked=“false” Priority=“39” SemiHidden=“true”
UnhideWhenUsed=“true” Name=“toc 3”/>
<w:LsdException Locked=“false” Priority=“39” SemiHidden=“true”
UnhideWhenUsed=“true” Name=“toc 4”/>
<w:LsdException Locked=“false” Priority=“39” SemiHidden=“true”
UnhideWhenUsed=“true” Name=“toc 5”/>
<w:LsdException Locked=“false” Priority=“39” SemiHidden=“true”
UnhideWhenUsed=“true” Name=“toc 6”/>
<w:LsdException Locked=“false” Priority=“39” SemiHidden=“true”
UnhideWhenUsed=“true” Name=“toc 7”/>
<w:LsdException Locked=“false” Priority=“39” SemiHidden=“true”
UnhideWhenUsed=“true” Name=“toc 8”/>
<w:LsdException Locked=“false” Priority=“39” SemiHidden=“true”
UnhideWhenUsed=“true” Name=“toc 9”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Normal Indent”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“footnote text”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“annotation text”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“header”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“footer”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“index heading”/>
<w:LsdException Locked=“false” Priority=“35” SemiHidden=“true”
UnhideWhenUsed=“true” QFormat=“true” Name=“caption”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“table of figures”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“envelope address”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“envelope return”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“footnote reference”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“annotation reference”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“line number”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“page number”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“endnote reference”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“endnote text”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“table of authorities”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“macro”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“toa heading”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Bullet”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Number”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List 4”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List 5”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Bullet 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Bullet 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Bullet 4”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Bullet 5”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Number 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Number 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Number 4”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Number 5”/>
<w:LsdException Locked=“false” Priority=“10” QFormat=“true” Name=“Title”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Closing”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Signature”/>
<w:LsdException Locked=“false” Priority=“1” SemiHidden=“true”
UnhideWhenUsed=“true” Name=“Default Paragraph Font”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Body Text”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Body Text Indent”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Continue”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Continue 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Continue 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Continue 4”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“List Continue 5”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Message Header”/>
<w:LsdException Locked=“false” Priority=“11” QFormat=“true” Name=“Subtitle”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Salutation”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Date”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Body Text First Indent”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Body Text First Indent 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Note Heading”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Body Text 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Body Text 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Body Text Indent 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Body Text Indent 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Block Text”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Hyperlink”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“FollowedHyperlink”/>
<w:LsdException Locked=“false” Priority=“22” QFormat=“true” Name=“Strong”/>
<w:LsdException Locked=“false” Priority=“20” QFormat=“true” Name=“Emphasis”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Document Map”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Plain Text”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“E-mail Signature”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Top of Form”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Bottom of Form”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Normal (Web)”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Acronym”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Address”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Cite”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Code”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Definition”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Keyboard”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Preformatted”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Sample”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Typewriter”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“HTML Variable”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Normal Table”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“annotation subject”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“No List”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Outline List 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Outline List 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Outline List 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Simple 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Simple 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Simple 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Classic 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Classic 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Classic 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Classic 4”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Colorful 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Colorful 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Colorful 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Columns 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Columns 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Columns 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Columns 4”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Columns 5”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Grid 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Grid 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Grid 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Grid 4”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Grid 5”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Grid 6”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Grid 7”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Grid 8”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table List 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table List 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table List 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table List 4”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table List 5”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table List 6”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table List 7”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table List 8”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table 3D effects 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table 3D effects 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table 3D effects 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Contemporary”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Elegant”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Professional”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Subtle 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Subtle 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Web 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Web 2”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Web 3”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Balloon Text”/>
<w:LsdException Locked=“false” Priority=“39” Name=“Table Grid”/>
<w:LsdException Locked=“false” SemiHidden=“true” UnhideWhenUsed=“true”
Name=“Table Theme”/>
<w:LsdException Locked=“false” SemiHidden=“true” Name=“Placeholder Text”/>
<w:LsdException Locked=“false” Priority=“1” QFormat=“true” Name=“No Spacing”/>
<w:LsdException Locked=“false” Priority=“60” Name=“Light Shading”/>
<w:LsdException Locked=“false” Priority=“61” Name=“Light List”/>
<w:LsdException Locked=“false” Priority=“62” Name=“Light Grid”/>
<w:LsdException Locked=“false” Priority=“63” Name=“Medium Shading 1”/>
<w:LsdException Locked=“false” Priority=“64” Name=“Medium Shading 2”/>
<w:LsdException Locked=“false” Priority=“65” Name=“Medium List 1”/>
<w:LsdException Locked=“false” Priority=“66” Name=“Medium List 2”/>
<w:LsdException Locked=“false” Priority=“67” Name=“Medium Grid 1”/>
<w:LsdException Locked=“false” Priority=“68” Name=“Medium Grid 2”/>
<w:LsdException Locked=“false” Priority=“69” Name=“Medium Grid 3”/>
<w:LsdException Locked=“false” Priority=“70” Name=“Dark List”/>
<w:LsdException Locked=“false” Priority=“71” Name=“Colorful Shading”/>
<w:LsdException Locked=“false” Priority=“72” Name=“Colorful List”/>
<w:LsdException Locked=“false” Priority=“73” Name=“Colorful Grid”/>
<w:LsdException Locked=“false” Priority=“60” Name=“Light Shading Accent 1”/>
<w:LsdException Locked=“false” Priority=“61” Name=“Light List Accent 1”/>
<w:LsdException Locked=“false” Priority=“62” Name=“Light Grid Accent 1”/>
<w:LsdException Locked=“false” Priority=“63” Name=“Medium Shading 1 Accent 1”/>
<w:LsdException Locked=“false” Priority=“64” Name=“Medium Shading 2 Accent 1”/>
<w:LsdException Locked=“false” Priority=“65” Name=“Medium List 1 Accent 1”/>
<w:LsdException Locked=“false” SemiHidden=“true” Name=“Revision”/>
<w:LsdException Locked=“false” Priority=“34” QFormat=“true”
Name=“List Paragraph”/>
<w:LsdException Locked=“false” Priority=“29” QFormat=“true” Name=“Quote”/>
<w:LsdException Locked=“false” Priority=“30” QFormat=“true”
Name=“Intense Quote”/>
<w:LsdException Locked=“false” Priority=“66” Name=“Medium List 2 Accent 1”/>
<w:LsdException Locked=“false” Priority=“67” Name=“Medium Grid 1 Accent 1”/>
<w:LsdException Locked=“false” Priority=“68” Name=“Medium Grid 2 Accent 1”/>
<w:LsdException Locked=“false” Priority=“69” Name=“Medium Grid 3 Accent 1”/>
<w:LsdException Locked=“false” Priority=“70” Name=“Dark List Accent 1”/>
<w:LsdException Locked=“false” Priority=“71” Name=“Colorful Shading Accent 1”/>
<w:LsdException Locked=“false” Priority=“72” Name=“Colorful List Accent 1”/>
<w:LsdException Locked=“false” Priority=“73” Name=“Colorful Grid Accent 1”/>
<w:LsdException Locked=“false” Priority=“60” Name=“Light Shading Accent 2”/>
<w:LsdException Locked=“false” Priority=“61” Name=“Light List Accent 2”/>
<w:LsdException Locked=“false” Priority=“62” Name=“Light Grid Accent 2”/>
<w:LsdException Locked=“false” Priority=“63” Name=“Medium Shading 1 Accent 2”/>
<w:LsdException Locked=“false” Priority=“64” Name=“Medium Shading 2 Accent 2”/>
<w:LsdException Locked=“false” Priority=“65” Name=“Medium List 1 Accent 2”/>
<w:LsdException Locked=“false” Priority=“66” Name=“Medium List 2 Accent 2”/>
<w:LsdException Locked=“false” Priority=“67” Name=“Medium Grid 1 Accent 2”/>
<w:LsdException Locked=“false” Priority=“68” Name=“Medium Grid 2 Accent 2”/>
<w:LsdException Locked=“false” Priority=“69” Name=“Medium Grid 3 Accent 2”/>
<w:LsdException Locked=“false” Priority=“70” Name=“Dark List Accent 2”/>
<w:LsdException Locked=“false” Priority=“71” Name=“Colorful Shading Accent 2”/>
<w:LsdException Locked=“false” Priority=“72” Name=“Colorful List Accent 2”/>
<w:LsdException Locked=“false” Priority=“73” Name=“Colorful Grid Accent 2”/>
<w:LsdException Locked=“false” Priority=“60” Name=“Light Shading Accent 3”/>
<w:LsdException Locked=“false” Priority=“61” Name=“Light List Accent 3”/>
<w:LsdException Locked=“false” Priority=“62” Name=“Light Grid Accent 3”/>
<w:LsdException Locked=“false” Priority=“63” Name=“Medium Shading 1 Accent 3”/>
<w:LsdException Locked=“false” Priority=“64” Name=“Medium Shading 2 Accent 3”/>
<w:LsdException Locked=“false” Priority=“65” Name=“Medium List 1 Accent 3”/>
<w:LsdException Locked=“false” Priority=“66” Name=“Medium List 2 Accent 3”/>
<w:LsdException Locked=“false” Priority=“67” Name=“Medium Grid 1 Accent 3”/>
<w:LsdException Locked=“false” Priority=“68” Name=“Medium Grid 2 Accent 3”/>
<w:LsdException Locked=“false” Priority=“69” Name=“Medium Grid 3 Accent 3”/>
<w:LsdException Locked=“false” Priority=“70” Name=“Dark List Accent 3”/>
<w:LsdException Locked=“false” Priority=“71” Name=“Colorful Shading Accent 3”/>
<w:LsdException Locked=“false” Priority=“72” Name=“Colorful List Accent 3”/>
<w:LsdException Locked=“false” Priority=“73” Name=“Colorful Grid Accent 3”/>
<w:LsdException Locked=“false” Priority=“60” Name=“Light Shading Accent 4”/>
<w:LsdException Locked=“false” Priority=“61” Name=“Light List Accent 4”/>
<w:LsdException Locked=“false” Priority=“62” Name=“Light Grid Accent 4”/>
<w:LsdException Locked=“false” Priority=“63” Name=“Medium Shading 1 Accent 4”/>
<w:LsdException Locked=“false” Priority=“64” Name=“Medium Shading 2 Accent 4”/>
<w:LsdException Locked=“false” Priority=“65” Name=“Medium List 1 Accent 4”/>
<w:LsdException Locked=“false” Priority=“66” Name=“Medium List 2 Accent 4”/>
<w:LsdException Locked=“false” Priority=“67” Name=“Medium Grid 1 Accent 4”/>
<w:LsdException Locked=“false” Priority=“68” Name=“Medium Grid 2 Accent 4”/>
<w:LsdException Locked=“false” Priority=“69” Name=“Medium Grid 3 Accent 4”/>
<w:LsdException Locked=“false” Priority=“70” Name=“Dark List Accent 4”/>
<w:LsdException Locked=“false” Priority=“71” Name=“Colorful Shading Accent 4”/>
<w:LsdException Locked=“false” Priority=“72” Name=“Colorful List Accent 4”/>
<w:LsdException Locked=“false” Priority=“73” Name=“Colorful Grid Accent 4”/>
<w:LsdException Locked=“false” Priority=“60” Name=“Light Shading Accent 5”/>
<w:LsdException Locked=“false” Priority=“61” Name=“Light List Accent 5”/>
<w:LsdException Locked=“false” Priority=“62” Name=“Light Grid Accent 5”/>
<w:LsdException Locked=“false” Priority=“63” Name=“Medium Shading 1 Accent 5”/>
<w:LsdException Locked=“false” Priority=“64” Name=“Medium Shading 2 Accent 5”/>
<w:LsdException Locked=“false” Priority=“65” Name=“Medium List 1 Accent 5”/>
<w:LsdException Locked=“false” Priority=“66” Name=“Medium List 2 Accent 5”/>
<w:LsdException Locked=“false” Priority=“67” Name=“Medium Grid 1 Accent 5”/>
<w:LsdException Locked=“false” Priority=“68” Name=“Medium Grid 2 Accent 5”/>
<w:LsdException Locked=“false” Priority=“69” Name=“Medium Grid 3 Accent 5”/>
<w:LsdException Locked=“false” Priority=“70” Name=“Dark List Accent 5”/>
<w:LsdException Locked=“false” Priority=“71” Name=“Colorful Shading Accent 5”/>
<w:LsdException Locked=“false” Priority=“72” Name=“Colorful List Accent 5”/>
<w:LsdException Locked=“false” Priority=“73” Name=“Colorful Grid Accent 5”/>
<w:LsdException Locked=“false” Priority=“60” Name=“Light Shading Accent 6”/>
<w:LsdException Locked=“false” Priority=“61” Name=“Light List Accent 6”/>
<w:LsdException Locked=“false” Priority=“62” Name=“Light Grid Accent 6”/>
<w:LsdException Locked=“false” Priority=“63” Name=“Medium Shading 1 Accent 6”/>
<w:LsdException Locked=“false” Priority=“64” Name=“Medium Shading 2 Accent 6”/>
<w:LsdException Locked=“false” Priority=“65” Name=“Medium List 1 Accent 6”/>
<w:LsdException Locked=“false” Priority=“66” Name=“Medium List 2 Accent 6”/>
<w:LsdException Locked=“false” Priority=“67” Name=“Medium Grid 1 Accent 6”/>
<w:LsdException Locked=“false” Priority=“68” Name=“Medium Grid 2 Accent 6”/>
<w:LsdException Locked=“false” Priority=“69” Name=“Medium Grid 3 Accent 6”/>
<w:LsdException Locked=“false” Priority=“70” Name=“Dark List Accent 6”/>
<w:LsdException Locked=“false” Priority=“71” Name=“Colorful Shading Accent 6”/>
<w:LsdException Locked=“false” Priority=“72” Name=“Colorful List Accent 6”/>
<w:LsdException Locked=“false” Priority=“73” Name=“Colorful Grid Accent 6”/>
<w:LsdException Locked=“false” Priority=“19” QFormat=“true”
Name=“Subtle Emphasis”/>
<w:LsdException Locked=“false” Priority=“21” QFormat=“true”
Name=“Intense Emphasis”/>
<w:LsdException Locked=“false” Priority=“31” QFormat=“true”
Name=“Subtle Reference”/>
<w:LsdException Locked=“false” Priority=“32” QFormat=“true”
Name=“Intense Reference”/>
<w:LsdException Locked=“false” Priority=“33” QFormat=“true” Name=“Book Title”/>
<w:LsdException Locked=“false” Priority=“37” SemiHidden=“true”
UnhideWhenUsed=“true” Name=“Bibliography”/>
<w:LsdException Locked=“false” Priority=“39” SemiHidden=“true”
UnhideWhenUsed=“true” QFormat=“true” Name=“TOC Heading”/>
<w:LsdException Locked=“false” Priority=“41” Name=“Plain Table 1”/>
<w:LsdException Locked=“false” Priority=“42” Name=“Plain Table 2”/>
<w:LsdException Locked=“false” Priority=“43” Name=“Plain Table 3”/>
<w:LsdException Locked=“false” Priority=“44” Name=“Plain Table 4”/>
<w:LsdException Locked=“false” Priority=“45” Name=“Plain Table 5”/>
<w:LsdException Locked=“false” Priority=“40” Name=“Grid Table Light”/>
<w:LsdException Locked=“false” Priority=“46” Name=“Grid Table 1 Light”/>
<w:LsdException Locked=“false” Priority=“47” Name=“Grid Table 2”/>
<w:LsdException Locked=“false” Priority=“48” Name=“Grid Table 3”/>
<w:LsdException Locked=“false” Priority=“49” Name=“Grid Table 4”/>
<w:LsdException Locked=“false” Priority=“50” Name=“Grid Table 5 Dark”/>
<w:LsdException Locked=“false” Priority=“51” Name=“Grid Table 6 Colorful”/>
<w:LsdException Locked=“false” Priority=“52” Name=“Grid Table 7 Colorful”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“Grid Table 1 Light Accent 1”/>
<w:LsdException Locked=“false” Priority=“47” Name=“Grid Table 2 Accent 1”/>
<w:LsdException Locked=“false” Priority=“48” Name=“Grid Table 3 Accent 1”/>
<w:LsdException Locked=“false” Priority=“49” Name=“Grid Table 4 Accent 1”/>
<w:LsdException Locked=“false” Priority=“50” Name=“Grid Table 5 Dark Accent 1”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“Grid Table 6 Colorful Accent 1”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“Grid Table 7 Colorful Accent 1”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“Grid Table 1 Light Accent 2”/>
<w:LsdException Locked=“false” Priority=“47” Name=“Grid Table 2 Accent 2”/>
<w:LsdException Locked=“false” Priority=“48” Name=“Grid Table 3 Accent 2”/>
<w:LsdException Locked=“false” Priority=“49” Name=“Grid Table 4 Accent 2”/>
<w:LsdException Locked=“false” Priority=“50” Name=“Grid Table 5 Dark Accent 2”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“Grid Table 6 Colorful Accent 2”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“Grid Table 7 Colorful Accent 2”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“Grid Table 1 Light Accent 3”/>
<w:LsdException Locked=“false” Priority=“47” Name=“Grid Table 2 Accent 3”/>
<w:LsdException Locked=“false” Priority=“48” Name=“Grid Table 3 Accent 3”/>
<w:LsdException Locked=“false” Priority=“49” Name=“Grid Table 4 Accent 3”/>
<w:LsdException Locked=“false” Priority=“50” Name=“Grid Table 5 Dark Accent 3”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“Grid Table 6 Colorful Accent 3”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“Grid Table 7 Colorful Accent 3”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“Grid Table 1 Light Accent 4”/>
<w:LsdException Locked=“false” Priority=“47” Name=“Grid Table 2 Accent 4”/>
<w:LsdException Locked=“false” Priority=“48” Name=“Grid Table 3 Accent 4”/>
<w:LsdException Locked=“false” Priority=“49” Name=“Grid Table 4 Accent 4”/>
<w:LsdException Locked=“false” Priority=“50” Name=“Grid Table 5 Dark Accent 4”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“Grid Table 6 Colorful Accent 4”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“Grid Table 7 Colorful Accent 4”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“Grid Table 1 Light Accent 5”/>
<w:LsdException Locked=“false” Priority=“47” Name=“Grid Table 2 Accent 5”/>
<w:LsdException Locked=“false” Priority=“48” Name=“Grid Table 3 Accent 5”/>
<w:LsdException Locked=“false” Priority=“49” Name=“Grid Table 4 Accent 5”/>
<w:LsdException Locked=“false” Priority=“50” Name=“Grid Table 5 Dark Accent 5”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“Grid Table 6 Colorful Accent 5”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“Grid Table 7 Colorful Accent 5”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“Grid Table 1 Light Accent 6”/>
<w:LsdException Locked=“false” Priority=“47” Name=“Grid Table 2 Accent 6”/>
<w:LsdException Locked=“false” Priority=“48” Name=“Grid Table 3 Accent 6”/>
<w:LsdException Locked=“false” Priority=“49” Name=“Grid Table 4 Accent 6”/>
<w:LsdException Locked=“false” Priority=“50” Name=“Grid Table 5 Dark Accent 6”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“Grid Table 6 Colorful Accent 6”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“Grid Table 7 Colorful Accent 6”/>
<w:LsdException Locked=“false” Priority=“46” Name=“List Table 1 Light”/>
<w:LsdException Locked=“false” Priority=“47” Name=“List Table 2”/>
<w:LsdException Locked=“false” Priority=“48” Name=“List Table 3”/>
<w:LsdException Locked=“false” Priority=“49” Name=“List Table 4”/>
<w:LsdException Locked=“false” Priority=“50” Name=“List Table 5 Dark”/>
<w:LsdException Locked=“false” Priority=“51” Name=“List Table 6 Colorful”/>
<w:LsdException Locked=“false” Priority=“52” Name=“List Table 7 Colorful”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“List Table 1 Light Accent 1”/>
<w:LsdException Locked=“false” Priority=“47” Name=“List Table 2 Accent 1”/>
<w:LsdException Locked=“false” Priority=“48” Name=“List Table 3 Accent 1”/>
<w:LsdException Locked=“false” Priority=“49” Name=“List Table 4 Accent 1”/>
<w:LsdException Locked=“false” Priority=“50” Name=“List Table 5 Dark Accent 1”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“List Table 6 Colorful Accent 1”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“List Table 7 Colorful Accent 1”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“List Table 1 Light Accent 2”/>
<w:LsdException Locked=“false” Priority=“47” Name=“List Table 2 Accent 2”/>
<w:LsdException Locked=“false” Priority=“48” Name=“List Table 3 Accent 2”/>
<w:LsdException Locked=“false” Priority=“49” Name=“List Table 4 Accent 2”/>
<w:LsdException Locked=“false” Priority=“50” Name=“List Table 5 Dark Accent 2”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“List Table 6 Colorful Accent 2”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“List Table 7 Colorful Accent 2”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“List Table 1 Light Accent 3”/>
<w:LsdException Locked=“false” Priority=“47” Name=“List Table 2 Accent 3”/>
<w:LsdException Locked=“false” Priority=“48” Name=“List Table 3 Accent 3”/>
<w:LsdException Locked=“false” Priority=“49” Name=“List Table 4 Accent 3”/>
<w:LsdException Locked=“false” Priority=“50” Name=“List Table 5 Dark Accent 3”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“List Table 6 Colorful Accent 3”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“List Table 7 Colorful Accent 3”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“List Table 1 Light Accent 4”/>
<w:LsdException Locked=“false” Priority=“47” Name=“List Table 2 Accent 4”/>
<w:LsdException Locked=“false” Priority=“48” Name=“List Table 3 Accent 4”/>
<w:LsdException Locked=“false” Priority=“49” Name=“List Table 4 Accent 4”/>
<w:LsdException Locked=“false” Priority=“50” Name=“List Table 5 Dark Accent 4”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“List Table 6 Colorful Accent 4”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“List Table 7 Colorful Accent 4”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“List Table 1 Light Accent 5”/>
<w:LsdException Locked=“false” Priority=“47” Name=“List Table 2 Accent 5”/>
<w:LsdException Locked=“false” Priority=“48” Name=“List Table 3 Accent 5”/>
<w:LsdException Locked=“false” Priority=“49” Name=“List Table 4 Accent 5”/>
<w:LsdException Locked=“false” Priority=“50” Name=“List Table 5 Dark Accent 5”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“List Table 6 Colorful Accent 5”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“List Table 7 Colorful Accent 5”/>
<w:LsdException Locked=“false” Priority=“46”
Name=“List Table 1 Light Accent 6”/>
<w:LsdException Locked=“false” Priority=“47” Name=“List Table 2 Accent 6”/>
<w:LsdException Locked=“false” Priority=“48” Name=“List Table 3 Accent 6”/>
<w:LsdException Locked=“false” Priority=“49” Name=“List Table 4 Accent 6”/>
<w:LsdException Locked=“false” Priority=“50” Name=“List Table 5 Dark Accent 6”/>
<w:LsdException Locked=“false” Priority=“51”
Name=“List Table 6 Colorful Accent 6”/>
<w:LsdException Locked=“false” Priority=“52”
Name=“List Table 7 Colorful Accent 6”/>
</w:LatentStyles>
<![endif]–><!–[if gte mso 10]>

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0pt 5.4pt 0pt 5.4pt; mso-para-margin-top:0pt; mso-para-margin-right:0pt; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0pt; line-height:107%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri",sans-serif; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

<![endif]–>

Hi, in my use case a cannot use an xsd for the xml.
Is there another way of handling it ?

If not i cannot jump to linq and have to remain on mail merge !
So i ask you to add the if (conditional) statement in mail merge too, please…

thanks

Hi, in my use case a cannot use an xsd for the xml.
Is there another way of handling it ?

If not i cannot jump to linq and have to remain on mail merge !
So i ask you to add the if (conditional) statement in mail merge too, please…

thanks

Hi Simone,

Thanks for your inquiry.

simone.padovan:

Hi, in my use case a cannot use an xsd for the xml.
Is there another way of handling it ?

You are using XML as data source. In this case, you need to load the XML schema into DataSet. If you do not load the xml schema into DataSet, the date field will be treated as string.

Note that in contrast to Mail Merge, LINQ Reporting Engine heavily
depends on the type of a data field processed. Otherwise, it would be
impossible for the engine to use members of this type which is essential
due to the engine’s concept. By this reason, the birthDate field is
treated as a string and can not be formatted using a date-time pattern.

simone.padovan:

So i ask you to add the if (conditional) statement in mail merge too, please…

Unfortunately, I have not understood this query. Could you please share some more detail about this query? We will then provide you more information on this.

I’d like to use this feature with Mail Merging:

http://www.aspose.com/docs/display/wordsjava/Using+Conditional+Blocks

<<if [conditional_expression1]>>
template_option1
<<elseif [conditional_expression2]>>
template_option2

<>
default_template_option
<>

Thanks

Hi Tahir, that’s a better solution, thanks.
It will be nicer, anyway, if dataSet.readXml could directly try to transform string data in date/boolean/number when building the DataSet according to their value.

Thanks U !

Simone

Hi Simone,

Thanks for your inquiry.

simone.padovan:

The DataSet created through dataSet.readXml() doesn’t seem to have the correct datatypes (or linq reporting engine doesn’t).

For example it doesn’t handle boolean values or date correctly.

If i have an xml containing this attribute:
1950-04-01T00:00:00+01:00

and try to output it on the template using format options for date like this:
<<[identity.first().birthDate]:“dd.MM.yyyy”>>

the pdf will output the string value and not the correct date:
1950-04-01T00:00:00+01:00

In your scenario, you can achieve your requirements by using one of following solutions.

1. Using an XML schema that explicitly specifies the type of the birthDate column as “xs:dateTime” in xsd file.

2. Without using an XML schema. Solution shared in my previous post.


Please consider the following xml. There is no information of datatype either the value of birthDate is string or date. So, XML schema should be specified for this using DataSet.readXmlSchema method.

1950-04-01T00:00:00+01:00

This behavior is implemented by the built-in
.Net class. The Java version of the DataSet class (that we have
introduced) works the same way.

Ok, thank u very much

The issues you have found earlier (filed as WORDSJAVA-1152) have been fixed in this .NET update and this Java update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.