Can I make a report with repeating use of fields?

Question

I'm replacing my sailing club's Access database with a QB app. One of the outputs from the Access version is a report that is used to issue food tickets to members. &nbsp;The report is a single page per member with the member's name, number and year printed on each cell in a 5x5 table. Is it possible to do something similar in QB? &nbsp;I think I can imagine a solution involving a child table for the tickets with the output arranged in some sort of crosstab report, but that seems like a lot of work. &nbsp;Is there another approach that would make more sense? &nbsp; Thanks in advance!

mcfneil · Answer

Can you post a screen shot of what you are currently using so we have a better idea of the end goal you are looking for?

thommangothomma · Answer

There's really not much to see. &nbsp;I have a table of members and I basically want to print the member name, member #, and the year in each cell of a 5x5 table. &nbsp;I want that table to be the only thing printed on an 8x11 page, and I want to print 1 page per member. &nbsp;Thanks.

mcfneil · Answer

As far as a natively, and formatting it the way you are looking, no.

You are going to want to use the something similar to "exact forms".

Use have an add-on called "CirrusForms" where you create a template, then just plug in the field IDs for the values you want, push a button and bam. You can do "batch" creations too where you can make multiple sheets for different people all at once.

If you can't get it with the native "exact form" let me know and I can show you en example for you.

_anomdiebolt_ · Answer

This is trivial to do in QuickBase with script. The only question is what this means:

"The report is a single page per member with the member's name, number and year printed on each cell in a 5x5 table"

Post a screenshot of what you want the page to look like.

thommangothomma · Answer

Okay thanks. &nbsp;Here's what I'm thinking this would look like...

Forum Discussion

Can I make a report with repeating use of fields?

9 Replies

Related Content

Merging 2 Fields into a Formula-Text Field for Reporting Purposes

Snapshot Fields

Repeating calendar events

Find and Replace Field Values

Summary Reports