Passing parameters to create report using sql connection

[Alex K.]

Hello,

Please split this procedure on three and create in report 3 datasources.

Thank you.

[nicegaurav]

Is there any other way to do this... I don't want to create more SP.
Please do the needful..

[HighAley]

Hello.

Unfortunately, there is no other ways.

Thank you.

[nicegaurav]

Hi,
I am doing that way, which you suggest. Now i have created 3 SP and making 3 DataSources in a single report and try to call data sources in each sections But it is not showing me any report.
For testing purpose -- When I use single data source,showing data on the report.
this is urgent.. please do the needful

[Alex K.]

Hello,

Can you please send us your report with test data for analysis.

Thank you.