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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CrossTab Joining Row Information

Status
Not open for further replies.

Ballistical

Technical User
Mar 10, 2004
2
AU
Hi All
I am using CR 9.0
I want to use a cross tab table that has multiple row infomation in it eg

Sample_ID Product Sampled_Date Location FR BubbleSize
5678 Beer 01/01/05 East Wing
5699 Wine (null) West Wing

FR and BubbleSize are fictitious tests that are for the report that is generated which is used by technicians to fill in results.

Using the crosstab option wants to group by all of the row information and apparently this is way its meant to be used. I tried creating a simple formula that joins the row header information together but it doesn't seem to like it when some row values are null. (I think)

Can anyone help me with my fictitious beer problem

Thanks in advance. I'm new to this so please be gentle.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top