need report with all the field headers in left column

[inncoggnitto]

i have a request for a report to list all the data contained in a table w/150 fields. the data is information about a location. it needs to look something like this

name bobs dry cleaners
addr 123 main st
city here
state there

etc. for all 150 columns. i have tried cross tabs, regular, and anything else it could think of. is there an easy way to do this w/o having to do it one field at a time for all 150 fields?

 

[Madawc]

I'm not sure I follow the problem. If you want to show all of the fields at detail line, right-click on Detail and choose Insert Section Below. This will give you as many extra detail sections as you like, say 15 fields each for 10 detail sections, which will be repeated for each record.

Or do you mean something else? If so, please clarify.

It helps to give your Crystal version.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[synapsevampire]

Yeah, the wizards all create columnar data (I think).

One way you might cheat this would be to try selecting a narrow paper size for the printer, then run the wizard, it might do a one row per then...

Sorry, can't test right now.

-k

 

[inncoggnitto]

imagine it like a spreadsheet. across the top would be site 1, site 2, site 3, etc.

down the left side would be the field name for each field. then under the site 1 column would be the data from each field going down the column. hard to represent here but here is a shot

field site 1 site 2 site three
name

name bobs dry cleaners another one ljlkjlk
addr 123 main st 333 new road etc.
city here wheretown
state there tx

the left hand column could be the field name from the table or a text substitute and the data for each field would be in the columns. the table is a giant flat file and to print it out would span a multitude of pages across if it were to be done as a regular columnar report with the fields across the top and the data underneath.

using cr10 developer

 

[synapsevampire]

Ahhh, that is a different matter.

As an alternative, you can instal lthe HP Designjet 3500PCS (standard Windows printer) which allows for about 100" of space in landscape, so you "could" do this in one page in a columnar fashion, and quickly using the wizard.

Of course it would only be good for displaying and exporting unless you actually had that printer.

-k

 

[lbass]

I'm not sure if this is available in CR 10, but in CR 11, if you insert a crosstab->customize style tab, there is an option for displaying summary labels (summarized fields->vertical->check "show labels"). If you then added {table.site} as your column field and added all the string fields as summaries (using maximum as the summary), the field names would be used as the summary labels on the left.

-LB