In the Report Manager click by the side of the report to bring on the other options. Click on Manage. In the report properties, click on Parameters. Set the default...

A TVF is used If you want a table as an output of a function. The results can be used in a stored procedure.

Syntax:

CREATE FUNCTION [dbo].[functionname]

(

@inputvraiables Datatype

)

RETURNS @tablevariablename...

Thanks Ron. Got it.

Hi,

I have somewhat similar issue....I am able to invoke the application but the screen flashes once.... i think there is some issue with the parameters beings passed.... can you help...