I have prepared a query with two structures : One for year and other for key figure, so as to get the key figure value corresponding to the year(restricted) in one column and that corresponding to previous year (offset assigned as -1) in another column in the report. I got it when i executed the query. But when i executed from crystal reports, the key figure value is not showing in columns, but in two separate rows - current year and previous year. how can i resolve this??