CrossTab - "column" names missing for rows

[itlee]

I have a crosstab report (created in VS2005) defined as:

rows: sample, code, country
columns: yields, compounds
summary fields: Min(results)

and is displayed like:

---yield of metals---
arsenic lead nickel
01180 BHG03 Brazil 7.49 33.7 12.9
01185 DLF01 Brazil 10.9 10.2 6.3

what i need to do is supply the "column headings" for the rows above the row values so it looks like this:

---yield of metals---
[highlight]sample code country[/highlight] arsenic lead nickel
01180 BHG03 Brazil 7.49 33.7 12.9
01185 DLF01 Brazil 10.9 10.2 6.3

Anyone have suggestions?

Thanks,
Lee.



itlee. MCP\Analyst\Programmer\SQL\.NET\VB\C#

 

[lbass]

To get the titles in the upper left corner, you would have to insert a text box. Format it to repeat on horizontal pages. If you need it to repeat on new pages, it would need to be in the page header, with the page header formatted to "underlay following sections." If the crosstab is currently in a report header section, you would have to move it into a group header that is based on a formula that includes all records, e.g.:

whilereadingrecords;
""

...in order to get a page header.

Alternatively, you can create a formula like this:

whilereadingrecords;
"sample " + "code " + "country"

Add this as your row #1 in the crosstab. This will result in an outer column with the heading. You can rotate this 90 degrees and then minimize the width.

-LB