This is a migrated thread and some comments may be shown as answers.

Fixed length crosstab

4 Answers 23 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Mustafa
Top achievements
Rank 1
Mustafa asked on 08 Jan 2014, 09:44 AM
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 

4 Answers, 1 is accepted

Sort by
0
IvanY
Telerik team
answered on 13 Jan 2014, 10:02 AM
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

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

0
Mustafa
Top achievements
Rank 1
answered on 13 Jan 2014, 01:54 PM
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
0
IvanY
Telerik team
answered on 16 Jan 2014, 01:47 PM
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

New HTML5/JS REPORT VIEWER with MOBILE AND TOUCH SUPPORT available in Telerik Reporting Q3 2013! Get the new Reporting version from your account or download a trial.

0
Mustafa
Top achievements
Rank 1
answered on 21 Jan 2014, 11:35 AM
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
Tags
General Discussions
Asked by
Mustafa
Top achievements
Rank 1
Answers by
IvanY
Telerik team
Mustafa
Top achievements
Rank 1
Share this question
or