You must Sign In to post a response.
  • Category: ASP.NET

    How to Call Multiple Stored Procedure

    Hi
    Experts

    I designed one Crystal report But I need how to include Multiple stored Procedure in the one Crystal Report. Is it Possible? any one share with the code.
  • #762046
    Hi DotnetDeveloper,

    This link will help you how to call procedure inside another procedure.

    http://sqlmag.com/blog/debugging-nested-stored-procedures-sql-server-profiler

    Hope this will helpful to you..

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #762049
    Hi

    naveensanagasetti

    I asked include 2 stored procedure using one Crystal report file. I no need sql side call sp .
    I need in crystal report include multiple stored procedure and drag and drop 2 sp data fields .

    Name : Dotnet Developer-2015
    Email Id :kumaraspcode2009@gmail.com

    'Not by might nor by power, but by my Spirit,' says the LORD Almighty.

  • #762055
    Hi DotnetDeveloper,

    Please check the below link here they explain clearly how to use multiple datasource / tables while generate crystal report with step by step,

    http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-multiple-tables.htm

    http://highoncoding.com/Articles/556_Creating_Crystal_Report_with_Multiple_Tables_in_ASP_NET.aspx

    Hope this will helpful to you...

    --------------------------------------------------------------------------------
    Give respect to your work, Instead of trying to impress your boss.

    N@veen
    Blog : http://naveens-dotnet.blogspot.in/

  • #762059
    Hello Kumar,

    Go through the below links for your refence :

    http://www.aspsnippets.com/Articles/Create-Crystal-Report-using-Stored-Procedure-in-ASPNet-with-C-and-VBNet.aspx

    http://scn.sap.com/thread/3344782


    You can merge two stored procedures also :

    https://scn.sap.com/thread/1962611


    Hope this will work for you.

    Regards,
    Nirav Lalan
    DNS Gold Member
    "Failure is the path of least persistence"


Sign In to post your comments