General information
Category:
Reports & Report designer
Steve,
The age of the data does not drive this cross tab output. The columns are setup through a system configuration, which drives what the user sees in a grid. It's beyond the scope of this thread but rest assured, how the data is presented (in a cursor) for the report is a cross tab.
>Aaron,
>
>So this is not merely a question of whether there are 10 months or 6 months worth of data that has been cross-tabulated. The user has a number of fields that they are choosing from.
>
>Is the data really "cross-tabulated"?
>
>Does the user have control over what order the columns are to be shown?
>
>In the report output, is there (generally) one row displayed per record?
>
>
>>I'm not sure either, but what steered me in the right direction was the use of the FIELD() API, in conjunction with tests for columncount FCOUNT(). Granted this is not perfect, as I can only put upwards of 10 columns in the report, but the user in theory could setup hundreds of columns (very unlikely).
>>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only