Report with grouped data

When filemaker creates a report with grouped data one can either view these data in browse mode without the leading group titels or preview the report in preview mode. In this case the display is limited to the page size.
Is there a way to show the group headings and all the data in an speadsheet-like view, without being restricted to page size (which cannot be set to custom if the printer doesn't accept this)?
Zorro032798Asked:
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.

rogierCommented:
Looking at this quickly I think you could perform a script that first changes your printer settings to whatever you like, let's say selecting a large printer, and A3 paper or some other large format. Then the script calls up preview mode, and you should be able to see your entire spreadsheet, depending on the layout you design.

If you also print hard copies of that database, just perform the print command through another script that resets the printer settings first.

Good luck,
Rogier.
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
Zorro032798Author Commented:
Yes, this is a great tip. Many tnx, Rogier. BTW, are you French? Your name sounds like.
The only drawback to this solution is that you must have a printer connected that supports a big enough paper size. If this is not the case - like it was for me - you can install acrobat installer and choose a custom paper size, which is bigger than A3.
0
rogierCommented:
Non, I'm not French, my name is Flemish. In French it would be withou the "i"...

Glad to hear the tip works for you. I realize you need a printer connected (or at least have the driver for an oversized printer installed), but as you say you could take any freeware pdf generator. Also - depending on the OS you're on - you could define a custom paper size. I tried it in OS X on the Mac and could just define any custom paper size for the printer named "any printer".

Good luck,
Rogier.
0
Zorro032798Author Commented:
ja, natuurlijk :-)
zo'n mooie vlaamse naam, ik had het kunnen weten!
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
FileMaker Pro

From novice to tech pro — start learning today.