creating view based on stored procedure
26 July, 2013
Hi,
I have a stored procedure which returns a result set in my data base. how can i build a view in yellow fin on this stored procedure?
In view builder i can only see tables and views from my database but not the stored procedures. is there way how i can build a view based on stored procedure?
thanks
I have a stored procedure which returns a result set in my data base. how can i build a view in yellow fin on this stored procedure?
In view builder i can only see tables and views from my database but not the stored procedures. is there way how i can build a view based on stored procedure?
thanks
Hi,
In order to base a Yellowfin view on a stored procedure, you need to create a new view, and then choose the stored procedure option.
Once you have done this, the list of stored procedures will be displayed.
E.g.
More information on this can be found here : View Creation .
Please let us know if you run into any issues with this.
Regards,
David
In order to base a Yellowfin view on a stored procedure, you need to create a new view, and then choose the stored procedure option.
Once you have done this, the list of stored procedures will be displayed.
E.g.
More information on this can be found here : View Creation .
Please let us know if you run into any issues with this.
Regards,
David
Hi David,
thanks for you reply.
i have tried this but i haven't succeeded.
when i select the option stored procedure while creating the view, i can see the list of stored procedure displayed on the screen.
but the list shows the system stored procedures and table-valued functions from my DB but not the use defined stored procedures. i would like to build the report on a user defined stored procedures.
how can i achieve this?
thanks
regards
Subash Amara
thanks for you reply.
i have tried this but i haven't succeeded.
when i select the option stored procedure while creating the view, i can see the list of stored procedure displayed on the screen.
but the list shows the system stored procedures and table-valued functions from my DB but not the use defined stored procedures. i would like to build the report on a user defined stored procedures.
how can i achieve this?
thanks
regards
Subash Amara