🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

Footer not attached to detail data from previous page

Altair Forum User

Hello everyone,

I am having an issue with attaching Footer information to the Detail dataset from a previous page. This is how the data is structured.

Previous Page

Client name [Header]

Transaction data [Detail]

Next Page

Client name [Header] - same client as previous page

Transaction data [Detail]

Summary data [Footer]

I need the Footer to attach to the Detail from the previous page because the Detail information belongs to the same client but I am guessing Datawatch separates two data sets because they are divided by the Client name reappearing in the Next Page. Is there any way to circumvent this issue? Your help would be much appreciated!

Find more posts tagged with

English

Monarch

Accepted answers

All comments

Altair Forum User

Hi Matthew,

AFAIK, footers will be attached to all detail rows above it until it reaches another footer row. So for your example, a straightforward creation of a Footer template will extract footer fields for each detail row even though the detail row is on the previous page.

Footer templates will work the same way as Append templates but on opposite directions. Appends goes down the detail rows until it reaches another Append row, Footers goes up the details rows until it reaches another Footer row.

HTH

Mela

Altair Forum User

Hi Matthew,

AFAIK, footers will be attached to all detail rows above it until it reaches another footer row. So for your example, a straightforward creation of a Footer template will extract footer fields for each detail row even though the detail row is on the previous page.

Footer templates will work the same way as Append templates but on opposite directions. Appends goes down the detail rows until it reaches another Append row, Footers goes up the details rows until it reaches another Footer row.

HTH
Mela

Hi Mela,

That's what I thought too but the Footer actually doesn't extend to the previous page and that's where I am having a trouble. I think it's because the page header starts again at the top of the Next Page and that's stopping the footer from attaching to the Detail rows from the previous page.

Thanks,

Matt

Altair Forum User

Hi Mela,

That's what I thought too but the Footer actually doesn't extend to the previous page and that's where I am having a trouble. I think it's because the page header starts again at the top of the Next Page and that's stopping the footer from attaching to the Detail rows from the previous page.

Thanks,
Matt

Hi Matthew,

Maybe your Footer Template has a clearing template defined to it?

Mela

Altair Forum User

Hi Matthew,

Maybe your Footer Template has a clearing template defined to it?

Mela

Hi Mela,

Great point. I actually did have a clearing template set on Page Header and removing it solved the issue for this particular section of the extract. However, I remembered why I defined the clearing template in the first place (sorry it's been a while since I built this model). There are client transaction data throughout the report that does not have the Footer and they shouldn't have the Footer value attached from the next page or next client data with Footer information. I guess there is no way to selectively choose when to attach Footer values right?

Thank you for your prompt response by the way. It's been very helpful.

Matt

Altair Forum User

Hi Mela,

Great point. I actually did have a clearing template set on Page Header and removing it solved the issue for this particular section of the extract. However, I remembered why I defined the clearing template in the first place (sorry it's been a while since I built this model). There are client transaction data throughout the report that does not have the Footer and they shouldn't have the Footer value attached from the next page or next client data with Footer information. I guess there is no way to selectively choose when to attach Footer values right?

Thank you for your prompt response by the way. It's been very helpful.

Matt

Hi Matt,

Yes we can't select to which detail row a footer is attached. Hope you find a resolution.

Mela

Altair Forum User

Hi Mela,

Great point. I actually did have a clearing template set on Page Header and removing it solved the issue for this particular section of the extract. However, I remembered why I defined the clearing template in the first place (sorry it's been a while since I built this model). There are client transaction data throughout the report that does not have the Footer and they shouldn't have the Footer value attached from the next page or next client data with Footer information. I guess there is no way to selectively choose when to attach Footer values right?

Thank you for your prompt response by the way. It's been very helpful.

Matt

Matthew,

You could try looking for something that would allow you to successfully trap the footer but effectively trap a blank footer on those pages where there is no footer and none required.

However given the original problem of the detail data crossing pages that may not be so easy.

Plan C would be to capture a footer for all pages but have a way to identify the record from pages where no footer should be in place.

If that is possible you could look at creating context sensitive calculated field that copies the footer when it should be present and is blank when it should not be present. Then use the calculated field as the proxy for the footer.

Difficult to know if it will work - much depends on the report layout. Probably worth considering though.

Grant