Cross Tab - custom columns

rbuser

Following is a sample specification for a type of report that I need: I want
to summarize client income levels by program. The challenge is that the user
can define the income ranges.

For example, in one report the income may be divided into 50 ranges of
income between $0 and $50,000 in increments of $10,000.

In another report it may be say only three ranges of $0 to $15,000, $15,001
to $20,000, $20,000 and higher.

To do this it seems I need to do at least three different things at
run-time:
1) Assign the number of columns needed for the report

2) Assign the column headings for each column

3) Determine the particular column (range) that a specific income value is
assigned to.

I have looked at the examples for cross-tabs and think I understand #2 and
#3, but the examples all seem to have a fixed number of columns which are
known at design time by the programmer. I don't see where/how to solve
problem #1.

Any help would be appreciated.

Using Delphi 6 and ReportBuilder 7.0

Phil Horst

nicocizik

Phil,

I am having a little trouble understanding what you would like your report
to look like. Would you like each income range in it's own column? Please
provide a little more information (i.e. a picture or sample report template)
on what you would like your report to look and we'll go from there.

--