Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CRN - vertical list?

Status
Not open for further replies.

stacybost

Programmer
Aug 1, 2003
57
US
Is it possible to display a list "vertically" in CRN? I.e. have the list column titles display on the left? I've tried using a crosstab, but the data I need to display is informational, non-numeric text. I keep getting a #!Error message in the cells for the non-numeric facts.

Thanks!
Stacy
 
Hi...would you need multiple rows across the page, or would you only ever be displaying the contents of one record at a time?

If it was only one record at a time, you could create your query, associate it to the page (selecting one record per page), and create a table and simply drag the query elements into the table locations that you want/

If this isnt the case then I'm out of ideas for the moment!

J
 
Thanks JGirl, that is what I ended up doing. There is a required prompt that filters to one record. I was just looking for a better solution, as formatting the table is a pain!

FYI, in 1.1 MR2, you can no longer associated a query to a page. So beware! I had to put the table inside a list, which is ugly. We've had to make a bunch of changes like that. Perhaps I should post a warning about this...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top