Hi There,
If have a crosstab with 10 columns. The first 5 cols are static and show dates and customer id's. The remaining 5 show the sum over various diameters.
When i preview the report the first 5 cols only show 1 row entry per record.
example
5-06-03 001 Sample1 1 1 1 1 1
001 Sample2 1 1 1 1 1
002 Sample1 1 1 1 1 1
5-07-03 001 Test1 1 1 1 1 1 , and so on.
How can i get it to repeat the date for each line on my crosstab?? Also when i export to excel unless ur slightly comfortable with working in excel, which most users are not, they complain about not knowing the date for a specific line. Please can you help ?
If have a crosstab with 10 columns. The first 5 cols are static and show dates and customer id's. The remaining 5 show the sum over various diameters.
When i preview the report the first 5 cols only show 1 row entry per record.
example
5-06-03 001 Sample1 1 1 1 1 1
001 Sample2 1 1 1 1 1
002 Sample1 1 1 1 1 1
5-07-03 001 Test1 1 1 1 1 1 , and so on.
How can i get it to repeat the date for each line on my crosstab?? Also when i export to excel unless ur slightly comfortable with working in excel, which most users are not, they complain about not knowing the date for a specific line. Please can you help ?