Crosstab rows repeat

[Steven]

What would cause the rows to repeat for each row in the datasource even though I only have 1 row group and the group properties are set to use the values from the database?

[Steve]

Hello Steven,

We would appreciate if you send us a sample runnable report showing the behavior you describe and indicate which version you're using. This way we would be able investigate this on our end and get back to your with more information.

Kind regards,
Steve
the Telerik team

[Ronald Andrade]

 hello I have a problem with crostab records in my query I have 2 records, the report I printed 2 times the first row as I can fix this problem


my version of telerik reporting is the 2010

sample   2   HY-601   Ubicación 3142ROA   Mantenimiento 2 hrs   07/05/2012 10:29:29 a.m.

2   HY-601   Ubicación 3142ROA   Mantenimiento 2 hrs   07/05/2012 10:29:29 a.m.

[Steve]

Hi Ronald,

It is not clear what is the problem you've encountered. The records you've pasted are the same so confirm whether your 2 records contain the same data.

Regards,
Steve
the Telerik team

[Ronald Andrade]

I want to do is show a number of records in 2 columns how I can do that?

[Steve]

Hi Ronald,

By default a Table would be populated downwards i.e. with rows for each record and this is expected. To make our Table item "develop" per columns instead, rotate the layout of the Table (right click on a table cell - Rotate Layout option).

All the best,
Steve
the Telerik team

[Kyle]

Crosstab rows are repeating for me when binding the DataSource to the parent DataObject (table group data). I'm using this as my group field: =Fields.StartDate.ToString("D"). This happens if I try to do the same when an embedded second table with a group as well.

[Stef]

Hi Kyle,

If the group's data has repeating records they will be visualized by the Table item. You can add a group by =Fields.StartDate.ToString("D") in the Table item's Detail row group.


For the purpose select the Table item and open the Group Explorer. Under 'Row Groups' double-click the Detail row group to open its Properties. Then add the grouping criteria.

Regards,
Stef
Telerik by Progress

[Sara]

Hello 

I have a problem when I add dataSource to telerik report design the report generate table according to the number of row in the table in the dataset

[Nasko]

Hello Sara,

It seems that the data source is bound to the Report.DataSource property. If you set the Table.DataSource property instead, you will get a single table with multiple data rows as a result. More information on the topic is available in the Data Scope and Report Structure help articles.

Regards,
Nasko
Progress Telerik

[Eric]

I have the same problem My datasource have 3000 entry and i filter the data per year but in the end, i have a report that is 3000 pages long. In Telerik, the preview only has 1 page. The problem appears when running the report in QAD EQMS.

[Momchil]

Hi Eric,

You mentioned that the problem appears in the "QAD EQMS" environment. Can you share more details about this environment and how the report is integrated within it, as I am not familiar with "QAD EQMS"?

Additionally, sending the report definition would be of great help as, currently, it is hard to imagine what exactly could be causing the behavior you described.

You also explained that your filtering works correctly in Telerik but outside of it, you get 3000 pages. Can you verify that any parameters passed to the report/filters are consistent between environments?

[Eric]

I finally scrapped my report and redone it in another template.

It seems that some weird table/data was still present in my report file; this was visible or interpreted by QAD EQMS which in turn produce much more pages that in Telerik.

I found out by removing everything in my report, no data source, no table and opening the file afterward with Notepad.

The file was filled with data and command, some i could recognize!

So it was a corrupted file.

 

Thanks