SQL Query give results only with TOP clause

[maciej]

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

[Ivan Hristov]

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