March 1, 201015 yr HI there! I have a database with related tables which are all shown in a layout using portals placed in separate tabs. What I need to do is to be able to print a total concise report of the current record, but showing all the information from all the individual portals (relate records) which will be shown as separate sections of the report. The number of related records in each portal is not constant and therefore need something like sliding-and-auto-reducing for all portals. One of the problems also is that two of the related tables have around 100 fields each... I don't seem to have any idea for all of this. Does anyone?
March 1, 201015 yr Create a script to capture the main record ID in a global field or global variable and then print the info that you need from the main record using a print layout. Then in turn go to each of the related tables, perform a find for the related records using the global/variable captured previously and go to a print layout for that particular table to print the info. Repeat the process for each of the related tables.
March 1, 201015 yr Author True, but how would you create a print preview for the whole report, since every section of the report is an individual print step, and how would the report calculate a page number and a total-pages field?
March 1, 201015 yr The 6th item (by Barbara Cooney) on this post http://fmforums.com/forum/showtopic.php?tid/212349/post/345921/hl/report++related++cv/fromsearch/1/#345921 gives more information on the various ways to set up printing related tables
March 1, 201015 yr Author Thanks a lot for your answers. Still some practical problems remain, as for example the fact that one of the related tables contains 100 fields and setting a calc field with all the data formatted properly by function and not in layout. OK, I'll explain further: It's all about an evaluation form, where everything is related to a case number (main table) and then several individual sub-sections of the report. One of them, has ~100 fields with 2 fields related to each field value (Item name - %-Integrity )-should Irelate it to another sub-Table? The others are a bit less complicated but still complicate enough. The final layout appearance is another aspect as well since space-saving is crucial and the original form I was given uses double column. Not to mention the client needs consecutive page numbering (and page# of total # pages format). I hope you get the picture... I am almost desperate! Maybe functionality like this should be a priority for next generation FM, don't you think?
Create an account or sign in to comment