InDesign Tables + Dynamic table rows

[Aleks]

HI,

I am working on an urgent project at the moment that contains a lot of
InDesign (CS3) tables.

Some of the tables have 4-5 rows and some have 8-9 rows. The second
column of the table contains dynamic driven data values which i have
marked up with the correct ADORs. On some of the tables - a table row
needs to be turned on or off depending on some logic rules. (i.e. if
memberStatus is equal b then display that row, else hide the row).

What is the best way to do this? Is it possible to add visibility to a
table row (including the text and styling of the row)? If the table
row is turned off by the logic then the rows below would need to move
up (leaving no gap).

Thanks


Regards,
Aleks

[George Marsh]

Aleks

You will need to use a table ADOR, or (depending on the table styling)
could be recreated with tabs and rules above/below.

If you don't have access to uPlan this may be challenging to do purely
in uDirect.

To make a table ADOR you need to create the table with dynamic rows as
a user view, then create a table ADOR from that user view.

There is useful guidance on the XMPie support site around formatting
data (using user views & tables) for use in uChart that may be of use.

Good luck
George

[krish]

Hi Aleks,

 

We are having the same requirement as you described below, Can you please help us on turning on/off the table rows based on business logic.

 

Thanks in Advance,

kris

[couch]

The selection of table rows for a userview or for a table ADOR is based on SQL select command.

EG assuming that you are getting rows of products that a customer had purchased, you would have two tables:

Table 1 - customerData (eg columns "customerID", "Firstname", "Lastname")

Table 2 - purchaseHistory (eg columns "customerID", "product", "purchaseDate")

You would link to table 1 (customerData) as the primary recipient table for your document.

You would create a table ADOR or userview with the query:

SELECT @[purchaseHistory].[product], @[purchaseHistory].[purchaseDate] FROM @[purchaseHistory] WHERE @[purchaseHistory].[customerID] = |->[customerID]

Depending on the number of purchases that the customer had made (or that are listed in the purchaseHistory database) then, the number of rows in the table ADOR and therefore also in the InDesign table would change.