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

SQL Query give results only with TOP clause

1 Answer 41 Views
Telerik Trainer
This is a migrated thread and some comments may be shown as answers.
maciej
Top achievements
Rank 1
maciej asked on 04 Sep 2018, 08:32 AM

Hello guys,

 

I'm working on some report in Telerik Report Designer R2. Using SQL database, I'm geting data by the select command. The problem is: in SQL management studio the query is working fine, in Telerik it is 'working forewer'. But when I'm adding the TOP clause, it is starting to work, but still it is not giving all expected rows as a results. In SQL managament Studio I have around 100 rows as a query result, in Telerik I have like 15-20 rows, and only if the TOP clause is added. CAn you assist with this issue?

 

Best regards,

Maciej

1 Answer, 1 is accepted

Sort by
0
Ivan Hristov
Telerik team
answered on 06 Sep 2018, 02:43 PM
Hi Maciej,

We're not aware of such behavior of SQLDataSource and we will appreciate it if you can provide additional information about the current scenario. Usually in such cases the problem is not the data retrieval, but the report structure. A very common problem is to have a data item (i.e. a Table or a Crosstab) in the report's Detail section and set its data source and the report's data source to refer to the same instance of SQL Data Source object. In this case the report will generate 100 rows with a table, which would also have 100 rows on it. Even in this case the report should appear after some delay, because we've tested our report engine with hundreds thousands data records and it performs quite well.

I can suggest to check again the report structure and if the cause of the problem is still unclear, please send us the report along with some sample data to test it and we'll examine it on our side.

Regards,
Ivan Hristov
Progress Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Telerik Trainer
Asked by
maciej
Top achievements
Rank 1
Answers by
Ivan Hristov
Telerik team
Share this question
or