I have problem with retreiving data source columns defined for my report by clicking data explorer option in telerik reporting menu .
I have a class library project and inside it I create a new telerik reporting class . then I cancel it's wizard and I put a sql data adapter into my report and set my connection string and after that select my desire stored procedure in sql data adapter wizard from the list and then finisih. After doing all of the mentioned steps I select my report and then set it's data source to sql data adapter / datasource1 , but when I refer to data explorer option and select it report designer say : procedure or function sp_GetDailyOrders expected parameters @cmp_Id which was not supplied and then no data source column will retreive for me .
If go to select command property of my sql data adapter and then select it's sub property parameters and the assign a default value for my @cmp_Id then data explorer will retreive my data source columns .
Ok, may you please tell me what is the problem ! I don't want to set default value for my paremters .
Please help me .
I have a class library project and inside it I create a new telerik reporting class . then I cancel it's wizard and I put a sql data adapter into my report and set my connection string and after that select my desire stored procedure in sql data adapter wizard from the list and then finisih. After doing all of the mentioned steps I select my report and then set it's data source to sql data adapter / datasource1 , but when I refer to data explorer option and select it report designer say : procedure or function sp_GetDailyOrders expected parameters @cmp_Id which was not supplied and then no data source column will retreive for me .
If go to select command property of my sql data adapter and then select it's sub property parameters and the assign a default value for my @cmp_Id then data explorer will retreive my data source columns .
Ok, may you please tell me what is the problem ! I don't want to set default value for my paremters .
Please help me .
1 Answer, 1 is accepted
0
Hello Reza,
You can review the following KB article that elaborates on using Telerik Reporting with stored procedures. There is a working project at the very bottom - please give it a spin and let us know of the outcome: Using data source with parameters in Telerik Reporting.
All the best,
Steve
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.
You can review the following KB article that elaborates on using Telerik Reporting with stored procedures. There is a working project at the very bottom - please give it a spin and let us know of the outcome: Using data source with parameters in Telerik Reporting.
All the best,
Steve
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.