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

Free Support Forum - aspose.com

LINQ Reporting Engine Formatting Issue

The new LINQ reporting engine feature is quite powerful, and provides almost everything that we require. However, the syntax required to get certain formatting is not up to the standards of our high compliance customers. Here is the main use case:


We would like to have an ordered list with different levels, with no space between lines. In order to do that, the template looks like this:

1 <<foreach [a in List]>><<if [a.Level == “1”]>><<[a.item]>><o:p></o:p>

<<foreach [in a.Other]>><<[OtherLabel]>>: <<[OtherField]>>

1.1 <><<elseif [a.Level == “2”]>><<[a.item]>>

<<foreach [in a.Other]>><<[OtherLabel]>>: <<[OtherField]>>

1.1.1 <><<elseif [a.Level == “3”]>><<[a.item]>>

<<foreach [in a.Other]>><<[OtherLabel]>>: <<[OtherField]>>

1.1.1.1 <><<elseif [a.Level == “4”]>><<[a.item]>>

<<foreach [in a.Other]>><<[OtherLabel]>>: <<[OtherField]>>

<><><>


That just won’t do, as the template has a very odd structure that won’t make sense to our users. Is there a way to prevent newlines from coming after <>'s, >'s, and such? Because then we could do this:

<<foreach [a in List]>><o:p></o:p>

<>

1 <>

<>

<>: <>

<>

<>

1.1 <>

<>

<>: <>

<>

<>

1.1.1 <>

<>

<>: <>

<>

<>

1.1.1.1 <>

<>

<>: <>

<>

<>

<>

This template looks nice, but between every bullet in the resulting document there are four or so newlines.

So is there a way to have both: a nice looking template with a nice looking output document. Right now we can only have one of the two.

I've also attached a word document with the two pages. The first has the template that results in the document that we want. The second has the template layout we want, but the resulting document is not what we want.

Thanks!

Elliot

Hi Elliot,


Thanks for your inquiry. To ensure a timely and accurate response, please attach the following resources here for testing:

  • Aspose.Words generated output document which shows undesired output
  • Your expected document which shows the correct output. Please create this document using Microsoft Word application.
  • Please create a standalone simplified Java application (source code without compilation errors) that helps us reproduce your problem on our end and attach it here for testing.

As soon as you get these pieces of information ready, we’ll start investigation into your issue and provide you more information. Thanks for your cooperation.

PS: To attach these resources, please zip them and Click ‘Reply’ button that will bring you to the ‘reply page’ and there at the bottom you can include any attachments with that post by clicking the ‘Add/Update’ button.

Best regards,

Here are the items you requested.

Hi Elliot,


Thanks for the details. We have logged your requirement in our issue tracking system as WORDSNET-12400. Our product team will further look into the details of this problem and we will keep you updated on the status of this issue. We apologize for any inconvenience.

Best regards,
Hi Elliot,

Please use attached "template.docx" file. The file contains foreach and if tags in separate paragraphs with a hidden font applied. Thus, these tags are present but not seen until the "¶" button is pressed in the MS Word editor.

I have attached the "result.docx" file obtained using this template and LINQ Reporting Engine. Although, the file contains unwanted paragraph breaks, they have a hidden font applied. Thus, these paragraph breaks are not seen as well.

If you want to save the result document using one of non-MS-Word file formats like PDF, then Aspose.Words will not consider hidden paragraphs during conversion by default, so they will not appear in the output.

If you want to save the result document using an MS Word file format, then these paragraphs will not be seen in the output until the "¶" button is pressed in the MS Word editor.

If you will want these paragraph breaks to be completely removed instead of being hidden, this can be achieved with a little bit of coding. Please let us know then and we will provide you a code snippet.

Best regards,

Thank you for that, it was quite helpful. I think that removing the lines completely would be best. Could you provide the code snippet?



Thanks!
Elliot

Hi Elliot,


Thanks for your request. We are working on developing required code snippet and will get back to you soon.

Best regards,

Hi Elliot,


Here is requested code:
DataSet dataSet = new DataSet();
dataSet.readXml(getMyDir() + “in.xml”);

Document document = new Document(getMyDir() + “template.docx”);

ReportingEngine engine = new ReportingEngine();
engine.buildReport(document, dataSet);

removeHiddenEmptyParagraphs(document);
document.save(getMyDir() + “result.docx”);


private static void removeHiddenEmptyParagraphs(Document document) throws Exception {
NodeCollection paragraphs = document.getChildNodes(NodeType.PARAGRAPH, true);
Paragraph paragraphToRemove = null;
<font color="RED"><b>for</b></font> <font color="BLUE" size="+1"><b>(</b></font>Paragraph paragraph <font color="BLUE" size="+1">:</font> <font color="BLUE" size="+1"><b>(</b></font>Iterable<font color="BLUE" size="+1"><</font>Paragraph<font color="BLUE" size="+1">></font><font color="BLUE" size="+1"><b>)</b></font> paragraphs<font color="BLUE" size="+1"><b>)</b></font> <font color="BLUE" size="+1"><b>{</b></font>
    <font color="RED"><b>if</b></font> <font color="BLUE" size="+1"><b>(</b></font>paragraphToRemove <font color="BLUE" size="+1">!</font><font color="BLUE" size="+1">=</font> <font color="RED"><b>null</b></font><font color="BLUE" size="+1"><b>)</b></font> <font color="BLUE" size="+1"><b>{</b></font>
        <font color="GREEN"><i>// Remove a paragraph previously marked for removal.

paragraphToRemove.remove();
paragraphToRemove = null;
}

    <font color="RED"><b>if</b></font> <font color="BLUE" size="+1"><b>(</b></font><font color="BLUE" size="+1">!</font>paragraph<font color="BLUE" size="+1"><b>.</b></font>hasChildNodes<font color="BLUE" size="+1"><b>(</b></font><font color="BLUE" size="+1"><b>)</b></font> <font color="BLUE" size="+1"><font color="BLUE" size="+1">&</font><font color="BLUE" size="+1">&</font></font> paragraph<font color="BLUE" size="+1"><b>.</b></font>getParagraphBreakFont<font color="BLUE" size="+1"><b>(</b></font><font color="BLUE" size="+1"><b>)</b></font><font color="BLUE" size="+1"><b>.</b></font>getHidden<font color="BLUE" size="+1"><b>(</b></font><font color="BLUE" size="+1"><b>)</b></font><font color="BLUE" size="+1"><b>)</b></font> <font color="BLUE" size="+1"><b>{</b></font>
        <font color="GREEN"><i>// Mark a hidden empty paragraph for removal, but do not remove it straight away,

// since it would break the loop.
paragraphToRemove = paragraph;
}
}

<font color="RED"><b>if</b></font> <font color="BLUE" size="+1"><b>(</b></font>paragraphToRemove <font color="BLUE" size="+1">!</font><font color="BLUE" size="+1">=</font> <font color="RED"><b>null</b></font><font color="BLUE" size="+1"><b>)</b></font> <font color="BLUE" size="+1"><b>{</b></font>
    <font color="GREEN"><i>// Remove the last paragraph marked for removal.

paragraphToRemove.remove();
}
}


I hope, this helps.

Best regards,

Hi Elliot,


Regarding WORDSNET-12400, our product team has completed the work on your issue and has come to a conclusion that they won’t be able to implement the fix to your issue. Your issue (WORDSNET-12400) has now been closed with ‘Won’t Fix’ resolution. Please use the workaround mentioned in my previous post.

Best regards,