If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report with Multiple Columns and Freeze Row Headers
I need to create a report in Access 2000 that prints multiple columns by
group and prints a row header in every page. The output is similar to a pivot table view. Tried creating a subreport 1 for the row headers and a subreport 2 for the multiple columns but subreport 2 only displays 1st column. Thanks in advance for the help. -Benny page 1 Location1 Location1 Location1 Sample1 Sample2 Sample3 Analyte Unit Result Flag Result Flag Result Flag ------------------------------------------------------------------- Lead mg/kg 3.5 U 7.7 J 350 Zinc mg/kg 35 U 711 3500 .... page 2 Location2 Location2 Location2 Sample11 Sample22 Sample39 Analyte Unit Result Flag Result Flag Result Flag ------------------------------------------------------------------- Lead mg/kg 3.5 U 754 J 350 Zinc mg/kg 35 U 711 300 |
#3
|
|||
|
|||
Report with Multiple Columns and Freeze Row Headers
Steve,
Crosstab does not allow me to _create multiple column headers (I need 8 column headers in grouped by 1 column) _create 3 row-column intersections (I need to control each value so I can not concatenate the 3 fields) Thanks, Benny "Steve" wrote: Look at Crosstab query in the Help file. You can then make a report from the crosstab query. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "blimp" wrote in message ... I need to create a report in Access 2000 that prints multiple columns by group and prints a row header in every page. The output is similar to a pivot table view. Tried creating a subreport 1 for the row headers and a subreport 2 for the multiple columns but subreport 2 only displays 1st column. Thanks in advance for the help. -Benny page 1 Location1 Location1 Location1 Sample1 Sample2 Sample3 Analyte Unit Result Flag Result Flag Result Flag ------------------------------------------------------------------- Lead mg/kg 3.5 U 7.7 J 350 Zinc mg/kg 35 U 711 3500 ... page 2 Location2 Location2 Location2 Sample11 Sample22 Sample39 Analyte Unit Result Flag Result Flag Result Flag ------------------------------------------------------------------- Lead mg/kg 3.5 U 754 J 350 Zinc mg/kg 35 U 711 300 |
#4
|
|||
|
|||
Report with Multiple Columns and Freeze Row Headers
Hi Benny,
It appears to me that you could create your example with a crosstab query. Rows would be Analyte and Unit concatenated, Columns would be Location with Sample below it and the Value would be Result. Flag would not be in the crosstab query. Flag would be an unbound textbox in your report and in the control source, flag would be calculated based on Result. The only difficult thing would be to get Location and Sample above each column. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "blimp" wrote in message ... Steve, Crosstab does not allow me to _create multiple column headers (I need 8 column headers in grouped by 1 column) _create 3 row-column intersections (I need to control each value so I can not concatenate the 3 fields) Thanks, Benny "Steve" wrote: Look at Crosstab query in the Help file. You can then make a report from the crosstab query. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications "blimp" wrote in message ... I need to create a report in Access 2000 that prints multiple columns by group and prints a row header in every page. The output is similar to a pivot table view. Tried creating a subreport 1 for the row headers and a subreport 2 for the multiple columns but subreport 2 only displays 1st column. Thanks in advance for the help. -Benny page 1 Location1 Location1 Location1 Sample1 Sample2 Sample3 Analyte Unit Result Flag Result Flag Result Flag ------------------------------------------------------------------- Lead mg/kg 3.5 U 7.7 J 350 Zinc mg/kg 35 U 711 3500 ... page 2 Location2 Location2 Location2 Sample11 Sample22 Sample39 Analyte Unit Result Flag Result Flag Result Flag ------------------------------------------------------------------- Lead mg/kg 3.5 U 754 J 350 Zinc mg/kg 35 U 711 300 |
Thread Tools | |
Display Modes | |
|
|