List reporting format

[scarlet1978]

Hi,

I am trying to create a report that looks like:

Heading1 Name1 Name2 Name3
Heading2 Date1 Date2 Date3
Heading3 Amount1 Amount2 Amount3

(i.e. with the headings listed down the left hand side and the data in columns following).

Using columns under page setup gives the correct format, however it repeats the heading name for each column, which I don't want.

Any ideas?

 

[lupins46]

I guess you could probably do this by using use side by side subreports and then manipulate the recordset for each subform to select different records.
And I suppose you could build each line of the report in code and save it to a table, and then print that.

(Neither of which I would be eager to do!)

 

[scarlet1978]

So what you're trying to say is that it isn't going to be easy, right?

 

[lupins46]

No fooling you, eh?-)

(If you have less than 256 records then you could send the data to excel and do a simple row-columns transform)

 

[060159]

Have you tried haveing group headers and footers? Without seeing your dataset and what you are trying to do it is difficult to say how best to resolve it, but I have done several of these types of reoprt and the method works.

 

[scarlet1978]

I have tried group headers and footers - but using them puts the headings across the first line and the data in columns underneath, right? I basically need to transpose that somehow.