REPORT SLOWS WHEN USING TABULAR FUNCTION
hii alex
as we know nothing is better then fr.
i have one tabular procedure and a list of around 5000 items now how i am calling this table is
in this way if i execute this query in Sql Server also the results are slow but Results are generating and i can see that that is is returning Rows 10-15 rows every sec.
But when i generate report with FastReport it Hang on the Caption "Accessing DataSource" in the status bar and Once it Executes the Complete Query then only it Prints the 200 Pages from this Query.
Is it possible that FR desnt Execute the whole Query in the start and just once it gets data it starts printing the pages ??
ITS OK IF IT IS SLOW BUT IT SHOULDNOT HANG IT SHOULD CONTINUE PRINTING PAGES..
with regards
kutub
as we know nothing is better then fr.
i have one tabular procedure and a list of around 5000 items now how i am calling this table is
Select Item_Id, Item_Name, Opening_Stock, dbo.closingstock(item_id) as Closing Stock from Items
in this way if i execute this query in Sql Server also the results are slow but Results are generating and i can see that that is is returning Rows 10-15 rows every sec.
But when i generate report with FastReport it Hang on the Caption "Accessing DataSource" in the status bar and Once it Executes the Complete Query then only it Prints the 200 Pages from this Query.
Is it possible that FR desnt Execute the whole Query in the start and just once it gets data it starts printing the pages ??
ITS OK IF IT IS SLOW BUT IT SHOULDNOT HANG IT SHOULD CONTINUE PRINTING PAGES..
with regards
kutub
Comments
FR gets all rows from the datasource, then prepares the report. Nothing can be improved here.