Group Header, Page Break, and Sorting with XML data

jmiller · Post by **jmiller** » Thu Jun 30, 2011 3:00 pm

I am trying to create a report using xml data. I want the report to page break when a data value changes. I am having trouble sorting. In the sample data below, I would use as my group header condition. The data that appears in my data band does not stay in the order that it is in the xml file and I can't seem to specify a sort. I want the databand sorted by . Am I doing something wrong?

Doe
John

Doe
Tim

Smith
James

Post by **Ivan** » Fri Jul 01, 2011 4:24 am

Hello,

Can you please send us a sample report template for this data?

Thank you.

jmiller · Post by **jmiller** » Fri Jul 01, 2011 4:48 am

I am attaching the xsd, xml, mrt, and the pdf output I am getting. The data is different than my original post. As you can see in the pdf there are a couple of problems I am having:
1) The first page is blank. It sounds like the "Skip First" property of the group header should address this but it does not.
2) The xml data is already sorted in the order in which it should appear. I just want the page break to occur when the loan number changes. The page break works, but you can see the dates within the loan is now out of order.

Post by **HighAley** » Fri Jul 01, 2011 8:56 am

Hello.

jmiller wrote: 1) The first page is blank. It sounds like the "Skip First" property of the group header should address this but it does not.

Please, try to set "New Page After" property of GroupHeaderBand1 to False.

jmiller wrote: 2) The xml data is already sorted in the order in which it should appear. I just want the page break to occur when the loan number changes. The page break works, but you can see the dates within the loan is now out of order.

In this case you can set the 'Sort Direction' property of the GroupHeaderBand1 component to None or set the sorting order for the CouponData.OnTimeDate in the Databand.

Thank you.

jmiller · Post by **jmiller** » Fri Jul 01, 2011 9:10 am

Let me start with 2): This appears to be working. I thought for sure that I tried this. I did not set the 'Sort Direction' to None but I was pretty sure I tried to add the OnTimeDate sort in the DataBand. Whenever I added the sort it was removing the Data Source from the data band. Maybe I just did something wrong. It is working now.

1) The 'New Page After' does remove the initial blank page, but now LoanNumber '0000002' is appearing on the same page as '0000001'. I wanted a new page whenever the LoanNumber changed.

Post by **Alex K.** » Mon Jul 04, 2011 3:09 am

Hello,

jmiller wrote:1) The 'New Page After' does remove the initial blank page, but now LoanNumber '0000002' is appearing on the same page as '0000001'. I wanted a new page whenever the LoanNumber changed.

Please set the "New PageBefore" property of the GroupHeader component to true.

Thank you.

jmiller · Post by **jmiller** » Wed Jul 06, 2011 7:35 am

That worked. Thanks for your help!

Post by **Alex K.** » Wed Jul 06, 2011 7:53 am

Hello,

We are always glad to help you!
Let us know if you need any additional help.

Thank you.