Jump to content

Importing records for report


This topic is 8571 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I need to setup a layout to print out a report that uses data from different databases. I am told that I need to print the report from the database in which the data lives in. To achieve printing a page with data from different databases, I believe I need to set up fields in my main database and import the data into these fields. Is this what I need to do? If so, How can I get the data from a portal to slide when printing?

Link to comment
Share on other sites

No, you'd use portals and relationships. But the problem is that portals have a fixed number of rows, so your pages will either have too many or too few to fit the number of records.

Printing in the local file is easier because you just need to make a normal layout, FMP repeats the BODY part as many times as there are records.

Link to comment
Share on other sites

quote:

Originally posted by Vaughan:

No, you'd use portals and relationships. But the problem is that portals have a fixed number of rows, so your pages will either have too many or too few to fit the number of records.

Unless you will be printing as list from the portal file with heading from the main file.

Link to comment
Share on other sites

I've started setting it up by using relationships and printing the portals, and yes it is not easy. Could you not set up the layout in the other database, then copy and paste it into the main report? Stupid question? Why can't I set up a set of fields as repeating fields and import the records from the portal to these fields, then use the sliding method? Perhaps another stupid question.

Link to comment
Share on other sites

The problem with portals and repeating fields is that both have fixed number of rows.

The best way to do it is with a normal list layout in the file that the related records are in. Create a relationship back to the main file to bring across all of the information that you need to appear in the header. Find, sort then print.

The "Go to Related Records" scrip step is good for doing this stuff: in the master file, find the record you want. Run the script that uses the "go to related records (show only related records)" step, then print the layout.

Link to comment
Share on other sites

This topic is 8571 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.