开发者

Crystal Reports: How do I repeat a constant number of rows / headers on each new page in a cross-tab?

I have some data that I've staged in my database as such:

RowHeader    ColumnHeader    Value
Row1         Col1            (1,1)
Row1         Col2            (1,2)
Row1         Col3            (1,3)
Row1         Col4            (1,4)
Row1         Col5            (1,5)
Row2         Col1            (2,1)
Row2         Col2            (2,2)
...          ...             ...
RowN         ColM            (N,M)

And, as you might guess, I'm putting this in a cross tab in the following manner:

                   Columns:
                   ColumnHeader

Rows:              Summerized Fields:
RowHeader          Max of Value

And this generates the following report:

      Col1   Col2   Col3   ...  ColM
Row1  (1,1)  (1,2)  (1,3)  ...  (1,M)
Row2  (2,1)  (2,2)  (2,3)  ...  (2,M)
      ...    ...    ...    ...  ...
RowN  (N,1)  (N,2)  (N,3)  ...  (N,M)

Now, this report spans multiple pages and on each page, I'd like to always display the data from the first couple of rows and columns (a little like freezing panes in Excel). The number of rows and columns that need to always be displayed is constant. E.g. Let's say, on each page, I want columns 1 to 3 and ro开发者_StackOverflow社区w 1 to appear:

-- Page 1 --

      Col1   Col2   Col3   Col4   Col5
Row1  (1,1)  (1,2)  (1,3)  (1,4)  (1,5)
Row2  (2,1)  (2,2)  (2,3)  (2,4)  (2,5)
Row3  (3,1)  (3,2)  (3,3)  (3,4)  (3,5)
Row4  (4,1)  (4,2)  (4,3)  (4,4)  (4,5)
Row5  (5,1)  (5,2)  (5,3)  (5,4)  (5,5)

-- Page 2 --

      Col1   Col2   Col3   Col6   Col7
Row1  (1,1)  (1,2)  (1,3)  (1,6)  (1,7)
Row6  (6,1)  (6,2)  (6,3)  (6,6)  (6,7)
Row7  (7,1)  (7,2)  (7,3)  (7,6)  (7,7)
Row8  (8,1)  (8,2)  (8,3)  (8,6)  (8,7)
Row9  (9,1)  (9,2)  (9,3)  (9,6)  (9,7)

-- etc. ---

How can I do this?

Ok ok... you caught me... I'm totally new to using Crystal Reports (what gave it away?). I have a feeling that this cannot be done with the way the data is currently staged, but I am totally open to staging the data in another fashion to make this work. Thanks in advance.


You can achieve that.. meaning your able to create a group which can which can dispatch your column. I mean, if you column are month/year and you want only 6 per sheet.. you create a group with a formula indicating if your date in the 6st month of the year then 'start year', else 'end year' you insert your group in the report, then you place your cross in each group... done


You cannot achieve this with cross-tabs. You can achieve this by staging the data differently (i.e. in the manner it needs to be displayed) and creating a normal report.


Morning,

AS I say, you need to find a link between columns... I don't know how to repeat the first 3 columns, as far as they're not labels....

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜