I think I may have answered my own question. It was because Crystal was looking at each individual field so naturally it inserted a line for each field.
I have a crosstab with store number as my row and a formula as my detail and date (formatted to show weeks) but when I preview my crosstab, the first week shows on one line and the second week shows to the right but below the first week and so on. So my crosstab looks like this:
week1...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.