Fixed length crosstab

[Mustafa]

Hi All,

I use a crosstab on my report. And I need 13 columns, regardless of how much column binded.

Is there a way to do it?

Example is drawn in paint 

[IvanY]

Hi Mustafa,

Since the count of columns in simple tables is fixed most probably you need to restrict the column count in a crosstab. If that is the case you can do so with the query, i.e. since the column count will completely depend on the query you will have to make sure that the query returns the right count of rows with the right data so that you can always have 13 columns.

Regards,
IvanY
Telerik

[Mustafa]

Hi IvanY

Thanks for answer. 
I had asked  columns instead of row, sorry for my fault and English.

I tried to ask how can i set minimum row count. For example, 5 records returned as result of my query and crostab shows only 5 row, but i need crostab shows minimum 13 rows which others are empty.
If record count is more than 13, it's not problem, but when record count is less than 13, how can it be completed to 13? I searched it for hours and I couldn't find anything like that

Regards,
Mustafa

[IvanY]

Hello Mustafa,

It is not very clear to us what your specific scenario is. Because of that we do not know what the best option would be to satisfy your requirement. However it seems that the issue you are having is related to your data. Because of this it seems appropriate to search for a solution of your problem in the creation of the query, i.e. you will have to design it in such a manner that it returns the right amount of rows. For more information please check this thread.

Regards,
IvanY
Telerik

[Mustafa]

Hi IvanY,

Thanks for your answer, but i think i can't explain my problem. Never mind I've decided not to do it :) Thanks for your helps.

Mustafa