Search the Community
Showing results for tags 'alternate shading'.
-
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.
- 1 reply
-
- alternate shading
- suppress
-
(and 1 more)
Tagged with: