Empty Columns

[ccognos]

Hi,

I have imported data from excel into sql srv. I generated a report on the sql database.

report has month and for every month sale and purchase figures.

the report shows blank column at the start of the report. and the jan feb march shows after the blank column. How i can remove this blank col?

also how i can sort my data so the it comes as Jan feb March instead of FEB, Jan, March or reverse

regards

[PRIT AMRIT]

Hi,

Looks like there are some 'Null' values columns. If that is the case you can 'Hide' the Null values columns as shown in the attached screenshot. I believe the report is 'Cross-tab'.

For your 2nd question, now it is sorting on the 'String' so it's considering the Alphabets. Try to sort on a 'Date' column. Otherwise, create another DATA ITEM and write a case statement something like below and apply the sort on this DATA ITEM.

Case [Month]
when 'Jan' then '1'
when 'Feb' then '2'
------------------
-----------------
-----------------
when 'Dec' then '12'
End

Thanks
P