Dynamic Master Page footer based on XML data field [message #1621290] |
Tue, 17 February 2015 20:19 |
Keegan Pena Messages: 8 Registered: February 2015 |
Junior Member |
|
|
Hello all,
My problem is that I have a Header, repeating accounting lines grouped by a Vendor, and a Footer and both the Header and Footer must have a fixed position on the page and display data associated with that Vendor, which changes throughout. I would like for any overflow of the accounting lines to be pushed to the next page naturally without using the Intervals setting on the Group.
So, my solution is to place the Footer on the Master Page and use Global Variables to change the data to the current XML data that is being used by the Group. I have already tried to bind the grid on the Master Page to XML, but it only displays the first Vendor's information.
Will variables fix this, or is there another solution?
Edit: Here are the files. I am currently using an Interval Range of 2 and I for either the Interval Range to change once we get to the second page of the Vendor (keep in mind there will be multiple Vendors), or to have the Footer placed in the Master Page (so that excessive accounting lines don't push it off the first page) and have the data in the Footer still change depending on the Vendor
------------------------------------------------------------------------------------------------------
Keegan
[Updated on: Wed, 18 February 2015 17:25] Report message to a moderator
|
|
|
|
|
Re: Dynamic Master Page footer based on XML data field [message #1624624 is a reply to message #1621290] |
Thu, 19 February 2015 22:59 |
|
I went ahead and modified your design to use the classic models sample database to have actual data and multiple customers/groups. I think the attached does what you're looking for, but maybe not. See the script section in the outline to see where all I used script. I used page variables and passed the values from the current group of the table through persistent global variables to the page variables. From here, I was able to use auto text elements on the master page footer to pull the values from the current page for display in the footer at the bottom of the page. If there are too many credit/debit entries for a single page, they automatically go to the next page, but the same footer appears on both pages. Hopefully this is what you envisioned. Let me know if you have questions.
Note: This requires separate run and render tasks or you'll be a group behind in the footer. To see this from the designer, run the report in the web viewer. If you want to see it in pdf, change the url of the resulting web viewer page to say format=pdf instead of format=html. This will show you how PDF will look with separate tasks.
Michael
Developer Evangelist, Silanis
|
|
|
|
|
|
Re: Dynamic Master Page footer based on XML data field [message #1625985 is a reply to message #1625965] |
Fri, 20 February 2015 19:10 |
|
Exactly. In the interval group on your table, select the check box below the drop down where you selected the interval group. It says something about fixed base interval. If I remember right, you'd put 6 in the text box that activates when you check the box and your 20 in the interval text box above.
Michael
Developer Evangelist, Silanis
|
|
|
|
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04127 seconds