How does one dynamically take values from a Group, add it to an Array, and then print individual values in the Page Footer?

I have a report file, where the report provides information on a "Job" - so this is a "Job Ticket" report. Inside the Job Ticket, there is a group with details that provides information on individual "Components" of which there can be anywhere from 1 Component to 6 Components in any given Job. There is a field applied to each component which is a string and is the "ComponentType" ({sp_JobTicket.ComponentType}).

What I would like to do is put the value of each row of ComponentType into an Array, which I can then call in the Page Footer (i.e., so I can create a Text Object and in it call a value using something like "TypeforComponent[3]"), so even though every printed page will only show the full details of one component, the page footer for each page will provide an at-a-glance view of all the components and their types.

As it is right now, we just hand write the component types for all components on the printed page itself, but we can access the ComponentType through the database, so it seems like we should be able to get it to print on the report.

Where we need the ComponentType values to show up. We're currently hand-writing the values.
Here is a full page preview of of a printed Job Ticket report that has 4 components (so in the Page Footer only 1-4 would have a value, 5-6 are empty), and where everything is currently laid out, and where we're hoping to get things placed: Full Report Preview

Full Report with item locations and expected location for ComponentType value.
AWUniqueAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
DO you need all 6 printed on each page?

If so the only way to do that would be with a subreport.

DO you print 1 job ticket in each run?

mlmcc
0
AWUniqueAuthor Commented:
@mlmcc - Yes, all 6 would be printed in the Page Footer of each page. For tickets that don't have 6 to show, the non-applicable components (e.g., 5 and 6 on a 4-component job) would just remain blank.

A little clarification: We print a "Job Ticket" based on the JobNumber. Each Job is comprised of Components, of which there can be as few as 1, or as many as 6 in a Job. Each Component receives its own printed page. So generally (ignoring overflow) a 4-component job will have 4 printed pages. Our goal is to have at the bottom of each page (in the PageFooter) a summary section showing the ComponentType for all applicable components in a given job.
0
James0628Commented:
If you want one page to show the components that are printed on later pages (which is what it sounds like), then, as mlmcc said, you'd have to use a subreport.  One page in the main report doesn't know what data is going to be printed on the pages that come after that.

 A subreport could read all of the relevant data for a job and produce a list of the components, although putting the subreport in the page footer may be a problem.  CR places some restrictions on the page footer (because of the way it creates the report pages).  But if the subreport is a fixed size (and it sounds like yours would be), then it may be OK.

 James
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rowby Goren Makes an Impact on Screen and Online

Learn about longtime user Rowby Goren and his great contributions to the site. We explore his method for posing questions that are likely to yield a solution, and take a look at how his career transformed from a Hollywood writer to a website entrepreneur.

mlmccCommented:
I would put the subreport in the report header (single job per report) or the group header and produce the array he wants then print it on the page footers.

mlmcc
0
AWUniqueAuthor Commented:
Thanks all. I created a new report showing the data I want and then imported that into my Job Ticket as a subreport, and then set it to link to the parameters used by my main Job Ticket. It shows exactly what I want, and I got it to show correctly in the Page Footer as I'd hoped. Learn something new every day...
0
James0628Commented:
Glad I could help.

 James
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.