Fast Report get data from stored procedure or inline table value function

[question]

Hi,
can anybody tell me please, how it is possible to get data from a Stored procedure or from a InlineTable value function in FastReport?

[Buddelfish]

Where is your problem? Create a TxxxQuery (or a TxxStoredProc, if you have one), fill it with the appropriate query statement, connect the dataset to a TFrxDataset (Forgot the exact name) open the designer, assign the data and use it.

There is a menu item 'data' where you can 'assign the data', i.e. like make it visible to the designer.

Another possibility is to directly connect to a database from within the designer.

[question]

thanks for your reply

the problem is, i have a stored procedure and i have also a query for that, but when i connect with FastReport then it does not show any column, it happen only with stored procedure and with inline table valued function

furthermore ,i have checked the query and everything is ok so far but i dont know why in Fastreport does not show any data field

[question]

for example, i have a inline table valued function 'dbo.FT_getuser'
if i run the query direct with fixed value 'select * from dbo.FT_getuser(1001)' then its work

but if i use the parameter 'select * from dbo.FT_getuser(:ID)'
and run the query like this

ADOQuery1.Parameters.Items[0].Value:=1001;
ADOQuery1.Open;

then it does not show any data field in fast report ,but in delphi it works