Jump to content

  •  

Photo

How to print data from portal?


  • Please log in to reply
7 replies to this topic

#1 Andrew5  enthusiast

Andrew5
  • Members
  • 101 posts
  • FM Application:9
  • Time Online: 21h 57m 15s

Posted 06 March 2008 - 03:59 AM

I have a very simple set up: client contact data with a 1 to many relationship in a portal that lists charges and payments. I need to make a printable billing report for each client. I can set up a header, footer, and grand summaries, but how do I get the report to print portal data restricted to one client? Thanks.
  • 0

#2 Matthew Stetson  novice

Matthew Stetson
  • Members
  • 6 posts
  • FM Application:9 Advance
  • :

Posted 06 March 2008 - 05:23 AM

There are traditionally two ways to do this:

1. Build the report on a layout for the line items rather than the client. You can isolate the specific records you want using a Go To Related Record script step from the client record through the relationship that seeds the portal.

2. Build the report with a fairly large portal and use the Sliding/Printing Up option to remove the empty rows.

The first option is almost always the better choice. The only time I've used the second is when I need to list records from multiple related tables on the same report and didn't want a temporary table to aggregate them all.

Hope this helps!
  • 0

#3 Andrew5  enthusiast

Andrew5
  • Members
  • 101 posts
  • FM Application:9
  • Time Online: 21h 57m 15s

Posted 06 March 2008 - 07:29 AM

Thank you, although could you be more concrete as to your answer? I start a new layout, put the client name in the header, and put the fields from the portal in the body. I have a button that takes me from the client main screen to the report, but the data that shows up isn't what I need. Hmm.

My portal data will generally exceed the size of the screen.
  • 0

#4 Søren Dyhr  Carpal Tunnel

Søren Dyhr
  • Members
  • 6,230 posts
  • FM Application:10 Advance
  • Time Online: 8h 5m 2s

Posted 06 March 2008 - 07:42 AM

but the data that shows up isn't what I need


You took notice of which of tables it should go from, the most atomic one namely itemlines.

But perhaps you should tell us why it isn't what you need? "Exceedes" could have a lot of interpretations!

--sd
  • 0

#5 FestiveEmbalmer  enthusiast

FestiveEmbalmer
  • Members
  • 83 posts
  • FM Application:9 Advance
  • :

Posted 06 March 2008 - 10:15 AM

Did you forget to use the "Go To Related Record" script step? Just going to the new layout will not display the records you want.

Go To Related Record
Also, make sure you are viewing the data in list view. You can approximate the same look/feel of your portal by grouping your fields similarly and sizing the body field to a small row.
  • 0

#6 Matthew Stetson  novice

Matthew Stetson
  • Members
  • 6 posts
  • FM Application:9 Advance
  • :

Posted 06 March 2008 - 01:38 PM

As already stated, the two big things are to make sure the button uses Go To Related Record to isolate the line items you want. Just switching layouts will show all records (or the last found set) rather than just those related to the original. Also, if the layout is set to View as Form (you can check in the View menu when in Browse mode) you will only see the first record rather than the list.

The other thing; if you copy/pasted the fields from the portal to the new layout they may be referencing the wrong table object. Double-click each one and make sure they're pointed to the same table object you used to create the layout.
  • 0

#7 Andrew5  enthusiast

Andrew5
  • Members
  • 101 posts
  • FM Application:9
  • Time Online: 21h 57m 15s

Posted 07 March 2008 - 04:49 PM

I have poked around with Go to Related Record but it seems to me this is not my answer. For example. given a main table of contact names, there is a child table portal with a 1 to many relationship that holds charges, dates, etc. The portal appears on the contact screen. It is a scrollable portal. I need another layout that will display the charges of one customer suitable for printing- ie an invoice. I can make a report that will print all charges, sorted alpha by customer with subsummaries, etc. but how can I restrict that report to just one customer? The charges for that one person could be many pages long. Thanks everyone.
  • 0

#8 Søren Dyhr  Carpal Tunnel

Søren Dyhr
  • Members
  • 6,230 posts
  • FM Application:10 Advance
  • Time Online: 8h 5m 2s

Posted 08 March 2008 - 02:05 AM

GTRR have a (SO) option, otherwise will you show the entire related table ... without the SO option chosen will a script fired from a single portal line get you to that lines corresponding record in the related table, surrounded by the rest of the records in the table.

There is a subtle difference in speed between with or without the option chosen. On the other hand can it deal with a TO not connected to same TOG ... and another powerful feature reveals itself:

http://www.sumware.n...ngfoundsets.php

So depending of which part you use, just one of them or both will you get significant results pretty different, but extremely handy.

--sd
  • 0




FMForum Advertisers