help

[zhj]

in crystal report 9, i need to insert an header section between two detail sections, is that possible?, how?. something like having two tables that are inserted into one table.

[zhj]

I have a sql table that is composed of sub tables. some sub tables only display data in a detail section of crystal report. It requires multiple detail sections that require their own header sections. How this can be done with crystral report9?. i could not create like
header->detail->header->detail... sections. Or, the sql table has to be revised completely. These sub tables share some columns.

[Lugh]

I'm going to go out on a limb here, and suggest that you have some poor database design. But, perhaps it is simply a sophisticated solution to a tricky problem.

The short answer is that you cannot do quite what you are describing. However, there are options.

One option is to separate out each of your "sub-tables" into a separate subreport. This gives you the maximum flexibility. But, it can require quite a bit of up-front work to get it right.

A second option is to use grouping. There must be some column in your table that tells the reader when they have come to a new "sub-table." Group on that column. Put your header information in the group header.

If neither of these are options, then you have to go for real finesse. Create multiple details sections. Make some of them contain your header information. Create a conditional suppress to only show the details section relevant to the "sub-table." Create another conditional suppress to show the header section if it is relevant to the current "sub-table" AND is not relevant to the "sub-table" of the previous record (using the Previous function in the formula). This will likely take some experimentation to get it right.