Jump to content

Search the Community

Showing results for tags 'table'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Welcome
    • Start Here!
    • News
  • Software-Related Talk
    • Documentation
    • Getting Started
    • The JavaScript Library
    • FusionPro® VDP Creator
    • FusionPro® VDP Producer
    • FusionPro® VDP Server (API)
    • FusionPro® Expression®
    • MarcomCentral®
  • Support
    • Issues, Questions, Etc.
    • Digital Workflow Documents
    • Fonts
  • Off Topic
    • Customer Polls
    • Job Board (Moderated)
    • Reviews, Rants, and General Musings

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


About Me


Location


Occupation


FusionPro VDP software version


OS


Acrobat Version


Homepage


ICQ


AIM


Yahoo


MSN


Skype


User Title

Found 19 results

  1. Hello, I have a table that contains data for anywhere from 1-6 rows that I have successfully set up in Fusion. However, when the additional rows are empty, I need the document to remove the extra empty rows. For example, if a record only contains 3 rows of values, I need the additional 3 rows of the table to hide so that the borders/grids from the table do not populate.
  2. Hi all, I have a multi-line record table I created with the new table GUI in Creator 12.1 (which worked great). However, for the life of me, I cannot figure out how to add just a bottom border, or horizontal rule, between the header and the table contents. I've converted the GUI rule to Javascript and tried tinkering around there based on info I've found in other threads here, but I just can't seem to get what I am looking for. Screenshot attached. Thanks in advance! example1.pdf
  3. Using FusionPro Designer 10.1.11 I'm trying to create a table where the rows have alternate shading with 13 percent black shading starting on row two and following the same every other row. I would like the shading or rows in the table to be suppressed if the data doesn't exist and need some assistance on the coding. I know you can "Loop" code but with alternating row shades was not sure how to do this. This is part an example of my table (the finished table will have a possibility of 40 rows with two columns. new FPTable; var table = new FPTable; table.AddColumns(20000,32000); table.AddRows(40); table.Rows[0].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[0].Cells[0].HAlign = "Left"; table.Rows[0].Cells[0].VAlign = "Middle"; table.Rows[0].Cells[0].Content=Field("cardholder1"); table.Rows[0].Cells[0].Font="Futura Std"; table.Rows[0].Cells[0].PointSize="10"; table.Rows[0].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[0].Cells[1].HAlign = "Left"; table.Rows[0].Cells[1].VAlign = "Middle"; table.Rows[0].Cells[1].Content=Field("credit_limit1"); table.Rows[0].Cells[1].Font="Futura Std"; table.Rows[0].Cells[1].PointSize="10"; table.Rows[1].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[1].Cells[0].HAlign = "Left"; table.Rows[1].Cells[0].VAlign = "Middle"; table.Rows[1].Cells[0].ShadeColor = "Black"; table.Rows[1].Cells[0].ShadePct = "13"; table.Rows[1].Cells[0].Content=Field("cardholder2"); table.Rows[1].Cells[0].Font="Futura Std"; table.Rows[1].Cells[0].PointSize="10"; table.Rows[1].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[1].Cells[1].HAlign = "Left"; table.Rows[1].Cells[1].VAlign = "Middle"; table.Rows[1].Cells[1].ShadeColor = "Black"; table.Rows[1].Cells[1].ShadePct = "13"; table.Rows[1].Cells[1].Content=Field("credit_limit2"); table.Rows[1].Cells[1].Font="Futura Std"; table.Rows[1].Cells[1].PointSize="10"; table.Rows[2].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[2].Cells[0].HAlign = "Left"; table.Rows[2].Cells[0].VAlign = "Middle"; table.Rows[2].Cells[0].Content=Field("cardholder3"); table.Rows[2].Cells[0].Font="Futura Std"; table.Rows[2].Cells[0].PointSize="10"; table.Rows[2].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[2].Cells[1].HAlign = "Left"; table.Rows[2].Cells[1].VAlign = "Middle"; table.Rows[2].Cells[1].Content=Field("credit_limit3"); table.Rows[2].Cells[1].Font="Futura Std"; table.Rows[2].Cells[1].PointSize="10"; table.Rows[3].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[3].Cells[0].HAlign = "Left"; table.Rows[3].Cells[0].VAlign = "Middle"; table.Rows[3].Cells[0].ShadeColor = "Black"; table.Rows[3].Cells[0].ShadePct = "13"; table.Rows[3].Cells[0].Content=Field("cardholder4"); table.Rows[3].Cells[0].Font="Futura Std"; table.Rows[3].Cells[0].PointSize="10"; table.Rows[3].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[3].Cells[1].HAlign = "Left"; table.Rows[3].Cells[1].VAlign = "Middle"; table.Rows[3].Cells[1].ShadeColor = "Black"; table.Rows[3].Cells[1].ShadePct = "13"; table.Rows[3].Cells[1].Content=Field("credit_limit4"); table.Rows[3].Cells[1].Font="Futura Std"; table.Rows[3].Cells[1].PointSize="10"; table.Rows[4].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[4].Cells[0].HAlign = "Left"; table.Rows[4].Cells[0].VAlign = "Middle"; table.Rows[4].Cells[0].Content=Field("cardholder5"); table.Rows[4].Cells[0].Font="Futura Std"; table.Rows[4].Cells[0].PointSize="10"; table.Rows[4].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[4].Cells[1].HAlign = "Left"; table.Rows[4].Cells[1].VAlign = "Middle"; table.Rows[4].Cells[1].Content=Field("credit_limit5"); table.Rows[4].Cells[1].Font="Futura Std"; table.Rows[4].Cells[1].PointSize="10"; table.Rows[5].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[5].Cells[0].VAlign = "Middle"; table.Rows[5].Cells[0].ShadeColor = "Black"; table.Rows[5].Cells[0].ShadePct = "13"; table.Rows[5].Cells[0].Content=Field("cardholder6"); table.Rows[5].Cells[0].Font="Futura Std"; table.Rows[5].Cells[0].PointSize="10"; table.Rows[5].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[5].Cells[1].HAlign = "Left"; table.Rows[5].Cells[1].VAlign = "Middle"; table.Rows[5].Cells[1].ShadeColor = "Black"; table.Rows[5].Cells[1].ShadePct = "13"; table.Rows[5].Cells[1].Content=Field("credit_limit6"); table.Rows[5].Cells[1].Font="Futura Std"; table.Rows[5].Cells[1].PointSize="10"; table.Rows[6].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[6].Cells[0].HAlign = "Left"; table.Rows[6].Cells[0].VAlign = "Middle"; table.Rows[6].Cells[0].Content=Field("cardholder7"); table.Rows[6].Cells[0].Font="Futura Std"; table.Rows[6].Cells[0].PointSize="10"; table.Rows[6].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[6].Cells[1].HAlign = "Left"; table.Rows[6].Cells[1].VAlign = "Middle"; table.Rows[6].Cells[1].ShadeColor = "Black"; table.Rows[6].Cells[1].Font="Futura Std"; table.Rows[6].Cells[1].PointSize="10"; table.Rows[7].Cells[0].Margins = { Top:20, Bottom:30, Left:1800, Right:0 }; table.Rows[7].Cells[0].VAlign = "Middle"; table.Rows[7].Cells[0].ShadeColor = "Black"; table.Rows[7].Cells[0].ShadePct = "13"; table.Rows[7].Cells[0].Content=Field("cardholder8"); table.Rows[7].Cells[0].Font="Futura Std"; table.Rows[7].Cells[0].PointSize="10"; table.Rows[7].Cells[1].Margins = { Top:20, Bottom:30, Left:0, Right:0 }; table.Rows[7].Cells[1].HAlign = "Left"; table.Rows[7].Cells[1].VAlign = "Middle"; table.Rows[7].Cells[1].ShadeColor = "Black"; table.Rows[7].Cells[1].ShadePct = "13"; table.Rows[7].Cells[1].Content=Field("credit_limit8"); table.Rows[7].Cells[1].Font="Futura Std"; table.Rows[7].Cells[1].PointSize="10"; return table.MakeTags(); I'm not sure how to write the rule to purge rows in a table where there is no data and with alternate shading in the cells.
  4. I am working on a table and am new to formatting and alignment etc. What I would like to do is format my date (MM/dd/yyyy), amounts (add $) and keep the first 2 column left aligned but right align the last 3 columns. Any help would be appreciated! var table = new FPTable(); table.AddColumns(8000,29500,7000,7000,5700); var data = FusionPro.GetMultiLineRecords(); for (var rec = 1; rec <= data.recordCount; rec++) { function ExField(str) { return '<p br=false linespacing=0.8>' + TaggedTextFromRaw(data.GetFieldValue(rec, str)); } var content = ["Trx_Date_From","Description","ApprovedAmt", "Payments","Balance"].map(ExField); var row = table.AddRow(); var [cell] = row.Cells; cell.Margins = { 'Top': 1, 'Bottom': 1, 'Left': 0, 'Right': 0 }; cell.VAlign = 'Bottom'; row.CopyCells(0, 1, 2, 3, 4); row.minHeight = 15 * 100; // 15 pt row height. row.SetContents.apply(row, content); } return table.MakeTags();
  5. In my table, I need a thinner border than the standard "thin", "medium", "thick" options cell.SetBorders("Thin", "Magenta", "Bottom"); Is there any way to get a thinner border? The position and number of rows in the table vary based on the data. Or Is there a way to create a line below the text, like can be done in Indesign paragraph rule as another possible option?
  6. Hi, I have a bunch of recipe cards and I'm working on programming FusionPro to merge them into a layout. Each card has an ingredient list formatted as a table. I have that programmed and it works fine. My problem is that below the ingredient list is a list of tools required for producing the recipe. The tool list is in a two column format and it needs to move with the ingredient table so it is always the same distance below the table. In my text frame I have my rule for my ingredient table, a rule for my tool list and I have set the text frame to have two columns. The problem is that when the tool list starts the second column, the text goes to the top of the frame and is overlapping the table. I have attached screen captures of what I'm trying to achieve and what I am achieving. Is there a way to do this? I've looked through the tag reference guide but I don't see any tags for creating a paragraph that has columns. I also don't see any documentation for feeding overflow content from one table cell into another one. Any advice is appreciated. (FusionPro Creator 10.0.16 on Windows 10)
  7. I'm working on a Table that works great except data that has the ampersand (&) returns unexpected results. Example B&A Scholarship Fund returns B Scholarship Fund The "&" is getting stripped including anything until the next word. I know I have to use the NormalizeEntities function but in this particular case don't know where or how to write the syntax. Here's the table: new FPTable; var table = new FPTable; table.AddColumns(13500,1800,5400); for (i=1;i<=12;i++) {//Loop through fields if (Field("Amount_"+i)!="") {//add a row if the Amount field is not empty var tableRow = table.AddRow(); tableRow.Cells[0].HAlign = "Left"; tableRow.Cells[1].HAlign = "Center"; tableRow.SetContents(Field("Designation_"+i),Field("GC"+i),Field("Amount_"+i)); //Add content to the columns for (c=0;c<=2;c++) {//loop through cells to apply margins & font tableRow.Cells[c].Margins = { Top:0, Bottom:68, Left:0, Right:0 }; tableRow.Cells[c].Font = "Crimson Roman"; } } } var totalRow = table.AddRow(); //Add total row totalRow.Cells[0].HAlign = "Left"; totalRow.Cells[2].HAlign = "Center"; totalRow.SetContents("TOTAL 2018 TAX-DEDUCTIBLE GIVING:","",Field("CAL18_TTL")+"*"); //Set total row content for (c=0;c<=2;c++) {//loop through cells to apply margins & font totalRow.Cells[c].Margins = { Top:0, Bottom:68, Left:0, Right:0 }; totalRow.Cells[c].Font = "Brandon Grotesque Bold"; } return table.MakeTags(); Any help would be greatly appreciated!
  8. I need suggestions, please. How does one create the table in the attached PDF from the data in the attached spreadsheet? I planned on using a XDF file to drive the data into the tables. The spreadsheet could be 100-1000 or more records, resulting in a multipage book. Note the data is flowing in columns (not rows) on the PDF. The bottom half of the PDF should be the next 6 records (not repeated like it shows in the example) How do I get the "rows" on the spreadsheet into run in groups of 6 columns: rows 1-6 on the top, rows 6-12 on the bottom. The images, I think using an using external path to pull images into individual graphic frames above the table will work. The images do not have to be included in the table. PRICE LIST TEMPLATE -- DBC UPHOLSTERY.pdf sample Spreadsheet.txt
  9. I cannot figure out how to make the content in the table cell rotate 90degrees. I added the line: myTable.Rows[0].Cells[0].Rotate = 90; and nothing rotates. var myTable = new FPTable; myTable.AddColumns(7200, 7200, 7200, 7200); myTable.AddRows(3); myTable.Rows[0].Cells[0].Margins = new FPTableMargins; myTable.Rows[0].Cells[0].Font="Times New Roman"; myTable.Rows[0].Cells[0].TextColor="Black"; myTable.Rows[0].Cells[0].SetBorders("Thin", "Black", "Top", "Bottom", "Right", "Left"); myTable.Rows[0].Cells[0].Rotate = 90; myTable.Rows[0].CopyCells(0, 1,2,3); myTable.Rows[0].Cells[0].Content = "Header1"; myTable.Rows[0].Cells[1].Content = "Header2"; myTable.Rows[0].Cells[2].Content = "Header3"; myTable.Rows[0].Cells[3].Content = "Header4"; return myTable.MakeTags();
  10. I really didn't want to post this but after hours of searching I couldn't find a reason. I have two templates that use this code. One of the templates refuses to turn the text of the table white. I have: Made the made Variable in the Text Frame as White text I have edited my Table rule so both outcomes show as White I have edited the outcome for other variables other than "RED" and they work I have rewritten the code so not RED would be Black Tried seeing if it composed properly even if preview was bad (didn't work) However, no matter what I have done the code still shows black text on a dark colored background. Here is my code: var tbl = []; var myTable = new FPTable; myTable.AddColumns(3000, 3000, 3000, 3000, 3000); if (Field("RUN COLOR") == "RED") { //Formatting the table for (var i=0; i<2; i++) { var row = myTable.AddRow(); var cell = row.Cells[0]; cell.Margins = new FPTableMargins; cell.Margins = {Bottom: 0, Top: 0, Left: 0, Right: 0}; //cell.SetBorders("Thin", "Black", "Top", "Right", "Bottom", "Left"); cell.HAlign = "Right"; cell.VAlign = "Bottom"; cell.TextColor = "White"; row.CopyCells(0,1,2,3,4); row.minHeight = 800; } } else { //Formatting the table for (var i=0; i<2; i++) { var row = myTable.AddRow(); var cell = row.Cells[0]; cell.Margins = new FPTableMargins; cell.Margins = {Bottom: 0, Top: 0, Left: 0, Right: 0}; //cell.SetBorders("Thin", "Black", "Top", "Right", "Bottom", "Left"); cell.HAlign = "Right"; cell.VAlign = "Bottom"; cell.TextColor = "Black"; row.CopyCells(0,1,2,3,4); row.minHeight = 800; } } //Insert Data into Rows myTable.Rows[0].SetContents("<color name=\"White\">" + Field("BOX09"), Field("BOX07"), Field("BOX05"), Field("BOX03"), Field("BOX01")); //Row 1 myTable.Rows[1].SetContents(Field("BOX10"), Field("BOX08"), Field("BOX06"), Field("BOX04"), Field("BOX02")); //Row 2 BoxSet = myTable.MakeTags().replace(/^\<table/, "<table alignment=right"); return BoxSet; If it is helpful to know this code slightly varies from the other template that does work. Here is that code: var tbl = []; var myTable = new FPTable; myTable.AddColumns(3100, 3100, 3100, 3100); if (Field("RUN COLOR") == "RED") { //Formatting the table for (var i=0; i<3; i++) { var row = myTable.AddRow(); var cell = row.Cells[0]; cell.Margins = new FPTableMargins; cell.Margins = {Bottom: 0, Top: 0, Left: 0, Right: 0}; //cell.SetBorders("Thin", "Black", "Top", "Right", "Bottom", "Left"); cell.HAlign = "Right"; cell.VAlign = "Bottom"; cell.TextColor = "White"; row.CopyCells(0,1,2,3); row.minHeight = 1200; } } else { //Formatting the table for (var i=0; i<3; i++) { var row = myTable.AddRow(); var cell = row.Cells[0]; cell.Margins = new FPTableMargins; cell.Margins = {Bottom: 0, Top: 0, Left: 0, Right: 0}; //cell.SetBorders("Thin", "Black", "Top", "Right", "Bottom", "Left"); cell.HAlign = "Right"; cell.VAlign = "Bottom"; cell.TextColor = "Black"; row.CopyCells(0,1,2,3); row.minHeight = 1200; } } //Insert Data into Rows myTable.Rows[0].SetContents(Field("BOX10"), Field("BOX07"), Field("BOX04"), Field("BOX01")); //Row 1 myTable.Rows[1].SetContents(Field("BOX11"), Field("BOX08"), Field("BOX05"), Field("BOX02")); //Row 2 myTable.Rows[2].SetContents(Field("BOX12"), Field("BOX09"), Field("BOX06"), Field("BOX03")); //Row 3 BoxSet = myTable.MakeTags().replace(/^\<table/, "<table alignment=right"); return BoxSet; If someone could just guide me to what is causing this issue of being black all the time regardless of the Rules or what is set in the Text Frame, I would appreciate it. It may be possible I am just missing something small but it absolutely does not change to White if the background frame is Red.
  11. I have a very complex file. Figured out how to get it to loop through entries and then display additional data tables if it found another User. However, each user needs a copy of their own page, not just a data table, with all of the same information and it needs to flow behind the other one. I am not sure what I need to make this happen. Attaching a sample set so everyone can view what I have already and work through solutions. Sample FPro.zip
  12. [sOLVED] I am working on several items in this field including multiple possible body pages based on column value, overflow, and variable tables based on key customers and multi-row external data. My big issue right now is that my tables display on Preview but nothing shows up during Composition. I am assuming it is simple missed code or misplaced code on my behalf. OnRecordStart if (Field("MCE_Letter_Code") == "1") { FusionPro.Composition.SetBodyPageUsage("PP006", false); FusionPro.Composition.SetBodyPageUsage("PP006_2", false); FusionPro.Composition.SetBodyPageUsage("PP006_3", false); FusionPro.Composition.SetBodyPageUsage("PP006_Overflow",false); FusionPro.Composition.SetBodyPageUsage("PP009", false); FusionPro.Composition.SetBodyPageUsage("PP010", false); FusionPro.Composition.SetBodyPageUsage("PP026", false); } else if (Field("MCE_Letter_Code") == "6") { FusionPro.Composition.SetBodyPageUsage("PP001",false); FusionPro.Composition.SetBodyPageUsage("PP001_2",false); FusionPro.Composition.SetBodyPageUsage("PP001_Overflow",false); FusionPro.Composition.SetBodyPageUsage("PP009", false); FusionPro.Composition.SetBodyPageUsage("PP010", false); FusionPro.Composition.SetBodyPageUsage("PP026", false); } else if (Field("MCE_Letter_Code") == "9") { FusionPro.Composition.SetBodyPageUsage("PP001",false); FusionPro.Composition.SetBodyPageUsage("PP001_2",false); FusionPro.Composition.SetBodyPageUsage("PP001_Overflow",false); FusionPro.Composition.SetBodyPageUsage("PP006", false); FusionPro.Composition.SetBodyPageUsage("PP006_2", false); FusionPro.Composition.SetBodyPageUsage("PP006_3", false); FusionPro.Composition.SetBodyPageUsage("PP006_Overflow",false); FusionPro.Composition.SetBodyPageUsage("PP010", false); FusionPro.Composition.SetBodyPageUsage("PP026", false); } else if (Field("MCE_Letter_Code") == "10") { FusionPro.Composition.SetBodyPageUsage("PP001",false); FusionPro.Composition.SetBodyPageUsage("PP001_2",false); FusionPro.Composition.SetBodyPageUsage("PP001_Overflow",false); FusionPro.Composition.SetBodyPageUsage("PP006", false); FusionPro.Composition.SetBodyPageUsage("PP006_2", false); FusionPro.Composition.SetBodyPageUsage("PP006_3", false); FusionPro.Composition.SetBodyPageUsage("PP006_Overflow",false); FusionPro.Composition.SetBodyPageUsage("PP009", false); FusionPro.Composition.SetBodyPageUsage("PP026", false); } else if (Field("MCE_Letter_Code") == "26") { FusionPro.Composition.SetBodyPageUsage("PP001",false); FusionPro.Composition.SetBodyPageUsage("PP001_2",false); FusionPro.Composition.SetBodyPageUsage("PP001_Overflow",false); FusionPro.Composition.SetBodyPageUsage("PP006", false); FusionPro.Composition.SetBodyPageUsage("PP006_2", false); FusionPro.Composition.SetBodyPageUsage("PP006_3", false); FusionPro.Composition.SetBodyPageUsage("PP006_Overflow",false); FusionPro.Composition.SetBodyPageUsage("PP009", false); FusionPro.Composition.SetBodyPageUsage("PP010", false); } else { } return ""; OnJobStart //Link to the external data file. data = new ExternalDataFileEx("data_feed.csv", ","); if (!data.valid) { ReportError("Cannot successfully read/find the external data file."); } Rule_DataTable //The following if statement will detect if we are currently in preview mode or editing this rule (versus composing output). if(FusionPro.Composition.isPreview == true || FusionPro.inValidation == true) { Rule("OnJobStart"); } //Create empty var table = []; var tbl = []; //Get a count of the total number of records in the external data file NumberOfRecords = data.recordCount; var type = [ [' '] //Header ]; //Create Table var myTable = new FPTable; myTable.AddColumns(13000, 2000, 20000, 8500, 6500); tbl.push(["", "", "Provider Name", "Phone Number", "Miles Away"]); //Header Rows //Now, loop through all records in the external data file and find the records for (var n=1; n<=NumberOfRecords; n++) { function ExField(field) {return data.GetFieldValue(n, field);} if (Field("MCE_Case_Number") == ExField("Case_Number")) { type.forEach(function(s) { var [provider, phone, miles] = s; provider = ExField("Prov_Name"); phone = ExField("Prov_Phone").replace(/^[\D]*(\d{3})[\D]*(\d{3})[\D]*(\d{4})$/, "($1) $2-$3"); miles = FormatNumber("0.0", ExField("Prov_Mileage")/100); tbl.push(['Check to choose this provider', '', provider, phone, miles]); }); } } // Formatting for (var i=0; i<tbl.length; i++) { var row = myTable.AddRow(); var cell = row.Cells[0]; row.minHeight = 2000; cell.Margins = new FPTableMargins; cell.Margins.Bottom = 0; row.CopyCells (0,1,2,3,4); if (i >= 1) myTable.Rows[i].Cells[1].SetBorders ("Thin", "Black", "Top", "Bottom", "Right", "Left"); if (i == 0) cell.HStraddle = 2; myTable.Rows[0].Cells[1].Bold = "On"; cell.VAlign = "Middle"; row.CopyCells (1,2,3,4); myTable.Rows[i].Cells[2].HAlign = "Left"; myTable.Rows[i].Cells[3].HAlign = "Center"; myTable.Rows[i].Cells[4].HAlign = "Right"; var [col0, col1, col2, col3, col4] = tbl[i]; row.SetContents (col0, col1, col2, col3, col4); } myTable.AddRow(1); //Blank row for seperation //Push variable into Array table.push(myTable.MakeTags()); return table; Text Frame If you want a doctor not listed in the chart below, write the name and city on the lines below. Name: City: «Rule_DataTable» Person completing this form: Again I get the results I need from preview but the composition file is well lacking the data table. Suggestions? Another set of eyes on my code helps a lot.
  13. Hi All, I am looking for some ideas and help on how to print data from multiple rows on one page of a two page letter. There is a unique field for each name in the data "account id". There is no set number of rows for each id. One in the full data has 30 rows. I attached a sample of the data and a two page pdf that shows how the data fields need to be laid out. The back page is what has me stumped. I need to get the "close date" and the "amount" for each row that has the same "account id" to be placed on the back page of the doc. I tried searching the forum but not sure what to even search for. I assume I will need to use some kind of table and an array. I am totally ignorant of both I have just dabbled some in JavaScript by reading this forum for ideas and direction. If anyone can point me in the right direction on where to start on this it would be greatly appreciated. TestData.zip VariableLayout.pdf
  14. I created a table using FusionPro. The table has a border on all 4 sides. Below the table, I want to add 12px of margin. In the world of CSS and HTML, the 'margin' is defined as the area OUTSIDE the box. (And 'padding' is the area inside the box). But according to FusionPro, the margin is the area INSIDE the box. Is this correct? I am adjusting my table's bottom margin like this: myTable.Rows[0].Cells[0].Margins.Bottom = 12;...but it's adding space inside the box, not outside as I would expect. So, how can I add 12px of space below my table? (I know I can just add a blank line, but I wanted precise control of the space in pixels. A 'margin' property would do the trick ;-) The CSS Box Model http://www.screencast.com/t/06nAFfFThttp://www.w3schools.com/css/css_boxmodel.asp http://screencast.com/t/06nAFfFT
  15. ==================== [uPDATE] January 14, 2016 ==================== Solution has been found (by Step) and a cleaner code was also provided. I am leaving this thread as it is so others can get help with similar problems. Attachments have been removed. ===================== [ORIGINAL] January 13, 2016 ===================== We have a request to merge one user's letter with their property tables. These tables will vary in quantity per user. Currently I am able to populate the data tables and create an overflow. However, it seems that the first letter for "Johnny" works out and he gets what he is supposed to have. Then the second letter for "Beth" ends up with Johnny's table and both of her tables. The problem continues on from there. I believe it has to do with the array the data is being stored into and how we are calling it to run. Can someone look over the code and see how I get the tables to stay with their owners and not continue on to the next owner? Since the form is for our state government I will be unable to post the original for download. However, I have attached a sample build and test resources used to build the item. Please keep in mind that this is a very large mailing. If there is an issue with memory recall on larger items let me know.
  16. Is there a way to create a table with an image placed in the background? If so, can the image be sized to best fit the table dimensions? This table can have a variable amount of text, hence the height of the table can change. I tried this code below, using the ShadeContent attribute to place an inline graphic. The resulting table had a black background, the image did not appear. What is the correct code to make the background image appear? var table1 = new FPTable; table1.AddColumns(23000); { table1.AddRows(1); table1.Rows[0].Cells[0].Margins = new FPTableMargins; table1.Rows[0].Cells[0].HStraddle = 0; table1.Rows[0].Cells[0].Margins.Top=150; table1.Rows[0].Cells[0].Margins.Bottom=150; table1.Rows[0].Cells[0].Margins.Left=200; table1.Rows[0].Cells[0].Margins.Right=200; table1.Rows[0].Cells[0].ShadeColor = '<graphic file=bboxPict.jpg>'; table1.Rows[0].Cells[0].ShadePct = 100; table1.Rows[0].Cells[0].Content = bbox; table1.Rows[0].Cells[0].TextColor="White"; } return table1.MakeTags();
  17. I'm able to control the width of columns with the javascript, but is there a way to control how tall a row is? I have my top and bottom margins set to '0', but they are still too tall. Is there a setting for defining the exact height I want the row to be?
  18. Hi, For a customer I have to create a business card with a QR-code with a logo in it. The background color of the business card itself is 20% green, but the QR-code which is 100% green must have a white background. My proposed solution was creating a table with background color white, where the table width is measured by content (found this solution here: http://forums.pti.com/showthread.php?t=3233). This works fine. If I could position this table exact in the middle of my text frame, I could place a graphic frame in the same dimensions exact above it. In this graphic frame I would place the logo exact in the middle. Result should be a QR-code with white background and the company logo in the middle. Somehow I don't manage to align the table into the textframe. This is my code: var Text = Rule("getQRcode2"); var PointSize = 7; var Font = "Helvetica"; var Color = "white"; var tm = new FusionProTextMeasure; tm.pointSize = PointSize * 100; tm.font = Font; tm.CalculateTextExtent(Text); var myTable = new FPTable; myTable.AddColumns(tm.textWidth + 100); var theCell = myTable.AddRow().Cells[0]; theCell.PointSize = PointSize; theCell.Font = Font; theCell.ShadeColor = Color; theCell.ShadePct = 100; theCell.Content = Text; theCell.Margins = { Top: 0, Bottom: -68, Left: 0, Right: 0 }; var X=myTable.MakeTags(); X += "<p leading=1> "; return X; Next step would be aligning the table rght-top, but with logo still in the middle of the QR-code. Anybody a clue how to realize this? Thanks!
  19. I am trying to create the name and credential boxes on page 2 of the attached: need to look like this.pdf. Using a table, and text measure to create the variable column widths. I am struggling a bit with the second red row which needs to be a different width that the above row. I think I need to create a new table in order to get the different width, but so far am having no luck in figuring out how to do that. In addition, I am see my long text run past the text box space - so copy ends up cut off or missing. I included my template file and a sample output of what it is doing now. Any suggestions?
×
×
  • Create New...